U++ forum: Welcome to the forum

607-Dev3 Errors (worked previously) [SOLVED] [message #4305]

Tue, 01 August 2006 00:24

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

Member

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