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.