At 04:03 PM 06-07-02 +0000, you wrote:

>I went with the DSQL way (since I'm only doing the insert once),
>however, when it runs the GEN_ID line.. It comes back saying 'Unable
>to get generator value'.
>
>I'm sure this has been seen before... What might be causeing this?
>
>- Roger

Check whether the generator exists. If you created it using IBConsole, it
possibly has a case-sensitive identifier.

Alternatively, you may need to start your transaction. Before the business
starts, test for it with
with DSQL1 do
try
if not IB_Transaction.TransactionIsActive then
IB_Transaction.StartTransaction;
...

Don't forget to Commit when the task is finished.


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com