Subject | Re: [ib-support] Using a Generator when creating a new record |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-02-28T14:10:11Z |
>How would I get the value myself?Have a separate query with
SELECT GEN_ID(GEN_NEW_AUTHOR_ID, 1) AS MYGENERATOR FROM RDB$DATABASE;
and then add something like
DataSet.FieldByName('AUTHOR_ID').Value :=
DataSet2.FieldByName('MYGENERATOR').Value;
>For the first option, if I just removed the AUTHOR_ID from the InsertSQL,Yes, that ought to do (though I've never used IBX).
>will the server put it in for me?
Set