RequestLive property |
Applies to
TIB_Dataset
Declaration
Property RequestLive : boolean;
Description
This property is used in order to make a SELECT statement updatable
and deletable. Even if a dataset is not "live" it can still be inserted into
because in SQL there is no concept of a INSERT INTO CURSOR.
What this does is include the FOR UPDATE clause in the SELECT statement. Keep in
mind that manually including this clause in your SQL will toggle the setting of
this property.
I have it setup this way so that you can also include the list of columns with
the OF clause.
SELECT COL1, COL2 FROM TABLE FOR UPDATE OF COL1
This will make it so that only COL1 can be updated. IBO will make all columns
not included in the OF list readonly automatically.