Re: Refresh
Re: Refresh
- Subject: Re: Refresh
- From: Guido Neitzer <email@hidden>
- Date: Tue, 27 Feb 2007 22:44:29 -0700
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;
cug (hope this works ... ;-))
_______________________________________________
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
| References: | |
| | >Refresh (From: WIESEN Bruno <email@hidden>) |
| | >Re: Refresh (From: Zak Burke <email@hidden>) |
| | >Re: Refresh (From: Robert Walker <email@hidden>) |
| | >Re: Refresh (From: Florijan Stamenkovic <email@hidden>) |
| | >Re: Refresh (From: Jeff Schmitz <email@hidden>) |