syntax error?

[MichaelTJ]

Cursor1 = SQL1.ExecQuery("CREATE Table DataTable_backup As Select * FROM DataTable")

the above gives an error if the "DataTable_backup" already exists and no error if the "DataTable_backup" does not exist however, it will not create the "DataTable_backup" nunder any circumstances.....

is my syntax incorrect?

 

[barx]

The SQL statements, looks ok to me. Although I have never used that type of statement, though a CREATE statement should be used with sql.ExecNonQuery()

 

[MichaelTJ]

gave it a try but....

it pops back with something about not assigning a void value.... really i just want to do a table backup so a delete followed by a create will do me.... could you please give me the minimalist query for moving all records from one table to a second and completely identical table..... thank you

 

[mc73]

1) Check if the new tables already exists and if so, drop it

SQL1.execNonQuery("DROP TABLE IF EXISTS DataTable_Backup")

2) Follow the change proposed by Barx.

 SQL1.execNonQuery("CREATE Table DataTable_backup As Select * FROM DataTable")