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
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://us.ard.yahoo.com/SIG=129e7e63o/M=294855.5468653.6549235.3001176/D=groups/S=1705115386:HM/EXP=1097662047/A=2376776/R=0/SIG=11ldm1jvc/*http://promotions.yahoo.com/ydomains2004/index.html>
>1597f0f4.jpg
>
>[]
>
>
>
>----------
>Yahoo! Groups Links
> * To visit your group on the web, go to:
> *
> <http://groups.yahoo.com/group/firebird-support/>http://groups.yahoo.com/group/firebird-support/
>
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

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