Home » U++ Library support » U++ SQL » 607-Dev3 Errors (worked previously) [SOLVED]
607-Dev3 Errors (worked previously) [SOLVED] [message #4305] |
Tue, 01 August 2006 00:24 |
|
I updated to dev3 and now my import and export does not work. I get the following error in my buglog file:
ERROR SQL logic error or missing database: insert into CUSTOMERS(ID,NAME,ADDRESS,CSZ,PHONE1,PHONE2,UNIT_INFO,NOTES, CURRENT,SERVICE) values(?,?,?,?,?,?,?,?,?,?)
ERROR PRIMARY KEY must be unique: Resetting statement: insert into CUSTOMERS(ID,NAME,ADDRESS,CSZ,PHONE1,PHONE2,UNIT_INFO,NOTES, CURRENT,SERVICE) values(?,?,?,?,?,?,?,?,?,?)
Now I checked to see what ID's I was inserting, and they are numeric starting with 1 and going to over 3000.
Now it does actually try to insert some stuff. I'm getting partial fields in there.
For example, "Abbott, Don" goes in as just "Abbot"
and "Abercrombie, Kathy" goes in as "Abercromb"
I downgraded to dev2 and all works ok. So this is a regression.
I can privately e-mail you my app and a sample dataset if you need it to debug.
Thanks.
[Updated on: Wed, 02 August 2006 02:49] by Moderator Report message to a moderator
|
|
|
Goto Forum:
Current Time: Sat Jun 08 06:54:37 CEST 2024
Total time taken to generate the page: 0.01480 seconds
|