🚀 go-pugleaf

Steve

This code will create a new table within a database.

#include <ADODB.hpp>
ADOConnection = new TADOConnection(0);
ADOConnection->LoginPrompt = false;
ADOConnection->Provider = "Microsoft.Jet.OLEDB.4.0";
ADOConnection->ConnectionString = "Data Source=c:\\DB.mdb;Persist
Security Info=False";
ADOConnection->Open();
TADOCommand *Cmd = new TADOCommand(0);
Cmd->CommandText = "CREATE TABLE TWhatever ([ID] AutoIncrement NOT
NULL, [Info1] Memo NULL, [Info2] Memo NULL, [SomeNum] Integer)";
Cmd->Connection = ADOConnection;
Cmd->Execute();
delete Cmd;
ADOConnection->Close();
delete ADOConnection;



This code will create a new column within a table

#include <ADODB.hpp>
ADOConnection = new TADOConnection(0);
ADOConnection->LoginPrompt = false;
ADOConnection->Provider = "Microsoft.Jet.OLEDB.4.0";
ADOConnection->ConnectionString = "Data Source=c:\\DB.mdb;Persist
Security Info=False";
ADOConnection->Open();
TADOCommand *Cmd = new TADOCommand(0);
Cmd->CommandText = "ALTER TABLE TWhatever ADD COLUMN [SomeNum2]
Integer";
Cmd->Connection = ADOConnection;
Cmd->Execute();
delete Cmd;
ADOConnection->Close();
delete ADOConnection;

Hope that helps.

Mike


On Wed, 5 Nov 2003 10:49:53 -0100, "Stefano" <p.bianchi@tin.it> wrote:

>Hi Mike!
>
>> Why are you using ADOX to create your tables and fields, when you can
>> use a SQL query to do the same??
>
>Can you should please show same sample using SQL ?
>
>It's possible to do the same (creating a new database, tables ect.) using
>ADO component (from C++ builder ADO component palette) via SQL command,
>without the use of  TADOXCatalog, TADOXTable etc ?
>
>Thanks in advance!
>Steve
>