>
> 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