syntax error?

M

MichaelTJ

Member
Licensed User
Longtime User
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?
 
Sort by date Sort by votes

barx

Well-Known Member
Licensed User
Longtime User
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()
 
Upvote 0
M

MichaelTJ

Member
Licensed User
Longtime User
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
 
Upvote 0

mc73

Well-Known Member
Licensed User
Longtime User
1) Check if the new tables already exists and if so, drop it
B4X: 
SQL1.execNonQuery("DROP TABLE IF EXISTS DataTable_Backup")
2) Follow the change proposed by Barx.
B4X: 
 SQL1.execNonQuery("CREATE Table DataTable_backup As Select * FROM DataTable")
 
Upvote 0
You must log in or register to reply here.

Similar Threads

E
  • Question
Android Question Pragma table_info SQLite error
Replies
7
Views
1K
spsp
S
T
  • Question
Android Question Select Case Missing Parameter error and syntax error
Replies
7
Views
2K
aeric
  • Question
Android Question SQLite syntax request error
Replies
14
Views
5K
LucaMs
  • Locked
  • Question
Android Question Variable table name through jRDC
2
Replies
22
Views
9K
Erel
3
  • Question
Android Question Syntax error on sql
Replies
14
Views
4K
3394509365
3
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…