You've hit the nail on the head right there! Well done!

You might come to a point (in your application) where you need two
transactions open, you've used a selectable procedure to do both an insert,
and a return of a dataset, and until you commit, the new record is invisible
to all other transactions.

If you then use your new value in another transaction context, the sky will
fall on your head...

Apparently there's a better way to get new inserted ID's from am insert via
PHP...

Nige.

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Wednesday, 17 November 2004 2:38 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
>
> I don't do it this way by default but I don't see what the
> problem might
> be... It's all happening in the same transaction
> Alan
> -----Original Message-----
> From: Nigel Weeks [mailto:nweeks@...]
> Sent: Wednesday, November 17, 2004 2:31 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
> It's just been revealed that my posts for this thread could cause
> problems,
> and aren't the
> best way of using Stored Procedures from PHP.
>
> Specifically, there are issues regarding DML operations,
> and returning
> rows
> in the same stored procedure.
>
> I'm going to do some learning...and might have to do some
> re-writing...
>
> Nige.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> --------------------------------------------------------------
> --------------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>