Tim Ledgerwood wrote:

> Now that is a bright idea!
>
> Thanks Alan
>
> At 12:07 PM 12/10/2004, you wrote:
>
>
>>>Nope - I am doing something wrong, and I don't know what I am
>>>doing wrong.
>>>Both the SP and the Query have the same (IBX) transaction object. The line
>>>
>>>SMSRecord.MsgID := IBQryInsertSMSMSGNO.AsInteger;
>>>
>>
>>I don't know what IBX components do here...
>>but just make a query which gets the gen value and open it.
>>The use the returned value to set your insert parameters for your other
>>queries.
>>Alan

We get spoilt with IBObjects because it does it automatically - I keep
forgetting to do it manually in my PHP code ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services