Search:

Hi Barry,

The exact command is
INSERT INTO expenseitem SELECT * FROM temp_expenseitem

The table structure is:

Expense ID:
Name: IEXPID_PK
Type: Int

Here's the debug output, I couldn't work anything out from it:


*
* Lianja embedded database engine
* Version 1.3.0
* Compiled on Dec 26 2015 10:24:08
*
Error reported from file sql_select.c...

Hi all, I hope this is the correct subforum.

I'm trying to copy the contents of one database into another. I am using javascript,the exact code is:


Lianja.execute("INSERT INTO table1 SELECT *...