Yeah, I'm just realising this...

Back when I started with PHP and Firebird (0.9 ish), connects and prepares
took ages.
So the process of:
prepare a query to retrieve a generator value
run the query
get the value
prepare a query to insert a record with the new value
run the query
wasn't very appealing, as it took a while.
They were the old days. The wire protocol has improved(compression on
varchars), and things are much quicker now...

The method of using a single call to a SP, and getting the ID back in one go
was very attractive.
I'll try the 'Recommended by the Elite' method of obtaining a value from a
generator, then inserting.

Thanks all!

Nige.

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Wednesday, 17 November 2004 3:40 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
>
> why is that so important a task Nigel? What's wrong with a 2
> step procedure?
> -----Original Message-----
> From: Nigel Weeks [mailto:nweeks@...]
> Sent: Wednesday, November 17, 2004 3:22 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
> Yes, normal usage is a single transaction, but it's not
> always the case.
>
> The other problem is that the 'Firebird Elite' have frowned upon
> the practice of using a 'Selectable Procedure' to do both:
> A DML operation (Insert/Update/Delete), and
> A return of a record set(via the suspend)
>
> Sure, it's possible, and I like using Procs in this way A
> LOT!!, but I've
> heard
> it's just not the right way to do it...
>
> It's been recommended that the following should be adhered to:
> 'Execute Procedures' should be used for DML ops (Ins/Upd/Del), and
> 'Selectable Procs' should only be used for returning
> datasets, fancy
> queries, etc.
> -> No data changes.
>
> I dunno yet, I can't think of a better way:
> There's a six-pack of Cascade Beer for anyone who can solve it!
>
> Summary of Challenge: Insert a row, and return the new
> generator-seeded ID
> in ONE COMMAND/ONE QUERY from PHP, without using a selectable stored
> procedure to do it...
>
> Nige.
>
>
> Yahoo! Groups Sponsor
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
>
> --------------------------------------------------------------
> --------------
> --
> 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
>
>
>
>
>
>
>
>