SQL Anywhere ultralite - Re: Insert record, SQLE_PRIMARY_KEY_NOT

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Insert record, SQLE_PRIMARY_KEY_NOT_UNIQUE error

Philippe Bertrand

2005-05-16, 8:23 pm

Please do not post word documents (for security reasons many people don't
like to open them).

Please post what API you are using, what version and build number.

If you are using 9.0.2, did you use the ulview and ulisql to confirm the
schema and data of the UltraLite database? (in the word doc you appear to
be using Sybase Central on a reference ASA database)

From the doc file:
("INSERT Location_crop_data( customer_id, Location_name,
address_id) VALUES (?,?,?)")

primary key( Customer_ID, Location_ID )
Customer_ID integer not null
Location_ID integer not NULL default autoincrement

--
- Philippe Bertrand
iAnywhere Solutions, Inc.

Please include in your subject line what UltraLite API are you using
(I.E. UltraLite.NET, Native UltraLite for Java, Embedded SQL, C++,
(pure) Static Java UltraLite, etc.). Please include version and BUILD
numbers in your post.

Sponsored Links