At 11:12 PM 29/01/2004 +0100, you wrote:

>Hello,
>
>I have been truggling with how to use TIBOQuery on an updateable dataset to
>retrieve a dataset, using execute procedure SP_Get_X,
>and to insert a record against the dataset, using execute procedure
>SP_Insert_Y.
>
>Does someone have a sample project that show that?

Yup. I've made you a little sample with its own database (+ script in case
you are on IB 5.6). The selectable sp GET_TESTME gets all of the records
in a table called TESTME. This is selected into an IBOQuery.
The executable sp INS_OR_UPD_OR_DEL_TESTME deletes, inserts or edits a
record, as requested by the program.

There are some notes at the head of the unit1.pas file.

Download here:
File : /ronan.zip
Uploaded by : helebor <helebor@...>
Description : Demo using IBOQuery with 2 stored procedures

You can access the file at the URL

http://groups.yahoo.com/group/IBObjects/files/ronan.zip

cheers,
Helen
----------------------------
The 50/50/90 rule: If you have a 50/50 chance of being right, there's a
90% probability that you will get it wrong. -- S. Murphy
----------------------------