Re: Refresh
Re: Refresh
- Subject: Re: Refresh
- From: Chuck Hill <email@hidden>
- Date: Wed, 28 Feb 2007 09:09:00 -0800
On Feb 27, 2007, at 9:44 PM, Guido Neitzer wrote:
On 27.02.2007, at 22:07, Jeff Schmitz wrote:
Hello again,
I'm using Frontbase as my database and I'm trying setup a
second test machine by exporting my frontbase database data from
one machine and import it into the database on the test machine.
This seems to work fine as far as the frontbase part of it (using
sql92 commands), but then when I then try to add a record using
the ec.inserObject from within my application, the primary key ID
it assigns to the new record is one that already exists in the
database, and I get an integrity constraint. Actually, it is
assigning the first key (1000001), like it thinks my table is
empty. Any ideas on why it's showing this behavior?
You have to update the "unique" count to the correct value:
set unique = (select max (id)+1 from your_table) for your_table;
There is a much easier syntax for that
set unique for table_name(pk_name);
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden