--- In IBObjects@yahoogroups.com, "Ronan van Riet"
<ronanvanriet@h...> 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?
>
> Kind regards,
> Ronan van Riet

For the Select:

Qry.SQL.Add('SELECT * FROM SP_Get_X');
Qry.Open;

For this make sure that SP_Get_X has a SUSPEND; statement when each
row should be sent to the client.


For the Update I would use a TIBOStoredProc.

SP.ProcName := 'SP_INSERT_Y';
SP.Prepare;
SP.ParamByName(<paramName>).AsString :=
SP.ExecProc;

Regards,

Allen.