Thanks again Helen

Also no flowers for me , you are of course right, the original solution using a TIB_Cursor would have fetched every available pin of that type.
It took me a while to realise what I was doing.
I was only saved by the low stock levels in the db, I'll make sure I don't make that mistake again. The server side procedures work well and are much less greedy on network bandwidth.

Your a Star

Peter

----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Friday, August 15, 2003 11:59 AM
Subject: Re: [IBO] TIB_Cursor edits Final Solution


At 10:59 AM 15/08/2003 +0100, you wrote:
>Hi Helen
>
>Thanks again and Hope you finally got some sleep !

Oh yes, thanks. Actually, I was fasting for a blood test, so I needed to
stay up late in order not to wake up too early and be craving for coffee
for too long. :-))


>I wasn't sure where to post my final solution, but as I used 2 IB_Stored
>Pocedures in the end I thought I would post it here.
>As you suggested and I suspected using a TIB_Cursor was not the correct
>thing to do.
>It all fell neatly into place using stored procedures.

Yup. Well, not everybody would keep bringing the results back to the
client that way. It's a lot of wasted network traffic. Time for you to
try and part from your desktop database mindset, Peter.

Just a point with Prepare and Unprepare - basically, don't do it like
this. You should always do

if not Prepared then Prepare;

Merely slotting in new values for parameters does *not* change the query
specification and so repreparing is lotsa totally redundant network
traffic. I know you think you client-heavy processing is wizz-bang, but,
believe me, when you get a point-of-sale system out there on site, you'll
be kneeling at the foot of your bed every night praying for every tiny drop
of performance improvement God wants to cast upon you...

If I'm wrong, I will send you carnations by Interflora.

regards,
Helen





Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

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


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