U++ forum: Welcome to the forum

Re: 607-Dev3 Errors (worked previously) [message #4308 is a reply to message #4307]

Tue, 01 August 2006 04:00

rbmatt
Messages: 90
Registered: July 2006
Location: Tennesse, USA

Member

aroman wrote on Mon, 31 July 2006 20:48

We updated the sqlite plugin to version 3.3.6, which is not compatible with databases from the earlier version of 3.2.7. If you are using the same database file, it won't work.

If you are not using the same database file, then something else is wrong...

- Augusto

Brand new database, importing from a plaintext, tab separated file.
I had also updated my dev2 sqlite as per the forum instructions- that makes me think its something else.
My syntax is like:

Sql insert("insert into CUSTOMERS(ID,NAME,ADDRESS,CSZ,PHONE1,PHONE2,UNIT_INFO,NOTES,CURRENT,SERVICE) values(?,?,?,?,?,?,?,?,?,?)");
...
Vector<String> field = Split(in.GetLine(), '\t', false);
insert.Run(field[0],field[1],field[2],field[3],field[4],field[5],field[6],field[7],field[8],field[9]);

Again, I verified that my field[0] (which is integer primary key) is giving unique integers.

Report message to a moderator