Subject | Re: [ib-support] Using a Generator when creating a new record |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-02-28T13:30:44Z |
>I'm having a problem using a Generator when creating a new record in myHm, sounds a bit risky unless this database is supposed to have a short
>Firebird table, perhaps you could help me. I am using the TIBDataSet
>component from InterBase Express 5.02.
life. IBX only support Firebird as long as it is compatible with Interbase.
Change to one of its descendants (FIB or whatever).
>Any ideas what the problem is?Your problem is that your generator is fired on the server, whereas you
insert on your client. You have to tell IBX to not check for this value or
get the value yourself before inserting (note, the first option will mean
that the record most likely will disappear from your TIBDataset - there is
no way for the server to tell the client what the value of AUTHOR_ID is if
it is the primary key).
HTH,
Set