Hi,
I’m trying to copy record of one database to another database. I used the “ATTACH” SQLite statement to bind on database with another. Then used “INSERT INTO master-table (SELECT * FROM child-table)” like syntax as in the code. Both the master table (master.sl3) and the child-table (kamlapur.sl3 in the code) have same number and type of variables. But it gives message of syntax error. Can any one correct or suggest me what to do ?
N.B : kamlapur.zip is the database of the device.
regards,
I’m trying to copy record of one database to another database. I used the “ATTACH” SQLite statement to bind on database with another. Then used “INSERT INTO master-table (SELECT * FROM child-table)” like syntax as in the code. Both the master table (master.sl3) and the child-table (kamlapur.sl3 in the code) have same number and type of variables. But it gives message of syntax error. Can any one correct or suggest me what to do ?
N.B : kamlapur.zip is the database of the device.
regards,