Subject Editing data from a SP
Author Lele Gaifax
Hi all,

I have to browse/edit a table but I need to fetch it's data using a
stored procedure. Such SP takes to parameters, the access keys to the
table, and if both are set the SP returns just the indicated single
record, otherwise it returns a subset of the records in the table
indicated by the first one.

So my query is something like

SELECT Model, Operation, ...
FROM TheSP (:MODEL, :OPERATION)

I'm wondering if there is any way to teach IBO to take advantage of
this when it needs to refresh a single record. With other engines
there is some kind of RefreshSQL to do that, but I did not find
something similar in IBO. Given that the SP does compute some values,
I'd like to refresh a single row whenever it changes, maybe using the
BufferSynchroFlags...

thanx in advance,
bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.