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

:-D I am surpised (and pleased - it means a LOT less work for me) that FB
1.5 and IBX work so well together .. if you treat this as a return
parameter, rather than a query field, it works, BTW :

with IBSPInsertSMS do
begin
{Fill in parameters}
if not Prepared then Prepare;
ExecProc;
end;

SMSRecord.MsgID := IBSPInsertSMS.ParamByName('MSGNO').AsInteger;

for i := 1 to 8 do
begin
{check here if the record has data}
if HasData then
begin
with IBSPInsertTankData do
begin
{Fill in parameters}
ExecProc;
end;
end;
end;

IBSPInsertSMS.Transaction.Commit;

Thanks for the advice and suggestions,

Tim


[Non-text portions of this message have been removed]