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