|Subject||RE: [firebird-support] Returning values from INSERT|
> Tim Ledgerwood wrote:just don't forget the backslash for the $ sign :-)
> > 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
> 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
$newcontactid = $db->get_var("SELECT GEN_ID(GEN_CONTACT,10000) FROM