> 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

just don't forget the backslash for the $ sign :-)
$newcontactid = $db->get_var("SELECT GEN_ID(GEN_CONTACT,10000) FROM
RDB\$DATABASE");

Alan