Subject | Re: [firebird-php] Inserted record cannot be selected |
---|---|
Author | Almond |
Post date | 2003-11-13T14:39:36Z |
Thank you for you reply. Is the code work on PEAR ?
Best regards,
Almond Wong
At 14:50 03/11/13 +0100, you wrote:
Best regards,
Almond Wong
At 14:50 03/11/13 +0100, you wrote:
>Hi.[Non-text portions of this message have been removed]
>
>This is because of the PHP default transaction, which is automatically
>committed or rolled back on script termination.
>
>Just use single transactions for your queries, that should do the trick,
> so like:
>
>$tr = ibase_trans(IBASE_COMMITTED, $conn);
>ibase_execute($tr, "SOMETHING WITH YOUR SP");
>ibase_commit($tr);
>
>$tr = ibase_trans(IBASE_READ, $conn);
>ibase_execute($tr, "SELECT STUFF");
>ibase_commit($tr);
>
>Hope that helps.
>
>Thomas
>
>Almond wrote:
> > Hello all.
> >
> > I insert a record through a "execute procedure" query in PHP, and I found
> > that the new inserted
> > record cannot be retrieved until I execute a "commit" through isql.
> >
> > Is that I can force the write in a stored procedure ?
> >
> > Best regards,
> >
> > Almond Wong
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-php-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
> >
> >
>
>
>Yahoo! Groups Sponsor
><http://rd.yahoo.com/SIG=12cc140pi/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/EXP=1068818073/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>ebf3565.jpg
>
>ebf35fb.jpg
>
>To unsubscribe from this group, send an email to:
>firebird-php-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.