Subject Re: [IBO] Selectable stored procedures and IBO
Author Helen Borrie
At 11:33 PM 7/09/2007, you wrote:
>Hello everyone, im new to this discussion group and to IBO. I've
>recently been developing an application using IBO and Firebird and i've
>acome across come problems.
>
>I would like to use a selectable stored procedure as a dataset using
>TIBOQuery and then edit that data. The problem is the records are read
>only, and when i turn on requestlive it gives me an error message
>telling that the record cant be edited.

That's right, because the data you get from a SP is manufactured
data. It doesn't have any links back to the tables it came from.


>So the question is:
> How do i use selectable stored procedures with IBO and freely edit
>the data on it?

Well, first figure out whether it makes logical sense to edit
non-existent data fields. If you think it's right to do it, then you
will need to populate the EditSQL, InsertSQL and DeleteSQL properties
of your query, using parameterised statements targetting the table
and columns of that table that you want to change.

If your SSP has fields that come from multiple tables, you can't
perform DML this way. Instead, you will need to write one or more
executable SPs that take input arguments from your SSP set, and
perform the separate DML statements inside that (or those) procedure[s].

Take extreme care to exclude any derived fields from your DML
statements or ESP calls.

Note, setting RequestLive has no effect whatsoever on non-updatable
datasets. IBO makes the dataset "live" if there are valid XxxSQL
statements provided.

Helen
p.s. It's considered good etiquette to sign your name when you're
asking people to help you out.