How to Use SQL commands with ADS?

[Armando]

Dear friends:

Some guru of ADS that can provide me a small example of how to execute SQL commands with ADS?
I need some commands like INSERT, DELETE, CREATE etc.

I have tried with this code without success.

Code: Select all  Expand view

    ADSPrepareSQL( hStatement,"CREATE TABLE Meses( " +;
                        "Numero Numeric(3,0)," +;
                        "Descripcion Char(10)) IN DATABASE")
    ADSExecuteSql(hStatement)
 

Thanks and best regards

[giuliano]

Hi Armando,

Try this:

Select 0
ADSCReateSqlStatement("hStatement",1)
ADSExecuteSQLDirect("CREATE TABLE Meses( " +;
"Numero Numeric(3,0)," +;
"Descripcion Char(10)) IN DATABASE")

Bye.
Giuliano

[Gale FORd]

I noticed that the Advantage Database Architect can generate the SQL code to build a table. Under "Tools"/"Export Table Structure as Code". I am using version 10 and I do not know if that option is available in older versions.

[Armando]

Guiliano:

Thanks so much, your example works fine, thanks again.

Gale:

I'm using version 9.1 and there is that posibility but I want to learn to do that via code, regards.

Best regards

[Gale FORd]

No problem. I like to see the code it generates so I can learn how to do it. I can even show you the SQL code to rebuild the data and the structure.

[Armando]

Gale:

You are right, I took the code for my example of that part, it's a good idea.

Regards