what is PEAR? is it a database?
Alan
-----Original Message-----
From: Almond [mailto:almond@...]
Sent: Friday, 14 November 2003 1:40 AM
To: firebird-php@yahoogroups.com
Subject: Re: [firebird-php] Inserted record cannot be selected


Thank you for you reply. Is the code work on PEAR ?

Best regards,

Almond Wong

At 14:50 03/11/13 +0100, you wrote:

>Hi.
>
>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=egrou

pweb/S=1705007183:HM/EXP=1068818073/A=1524963/R=0/*http://hits.411web.com/cg
i-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.

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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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