Show: Delphi C++
Display Preferences

IBX.IBUpdateSQL.TIBUpdateSQL

From RAD Studio API Documentation
Jump to: navigation, search

IBX.IBCustomDataSet.TIBDataSetUpdateObjectSystem.Classes.TComponentSystem.Classes.TPersistentSystem.TObjectTIBUpdateSQL

Delphi

TIBUpdateSQL = class(TIBDataSetUpdateObject)

C++

class PASCALIMPLEMENTATION TIBUpdateSQL : public Ibx::Ibcustomdataset::TIBDataSetUpdateObject

Properties

Type Visibility Source Unit Parent
class public
IBX.IBUpdateSQL.pas
IBX.IBUpdateSQL.hpp
IBX.IBUpdateSQL IBX.IBUpdateSQL

Description

TIBUpdateSQL provides an object for updating read-only datasets when cached updates are enabled.

Use a TIBUpdateSQL object to provide SQL statements used to update read-only datasets represented by TIBQuery components when cached updates are enabled. A dataset is read-only either by design or circumstance. If a dataset is read-only by design, the application itself does not provide a user interface for updating data, but may institute a programmatic scheme behind the scenes.

TIBUpdateSQL provides a mechanism for circumventing what some developers consider an SQL-92 limitation. It enables a developer to provide INSERT, UPDATE, DELETE, and REFRESH statements for performing separate update queries on otherwise read-only result sets in such a manner that the separate update queries are transparent to the end user.

In practical application, a TIBUpdateSQL object is placed on a data module or form, and linked to a TIBQuery component through that component's UpdateObject property. If the UpdateObject property points to a valid TIBUpdateSQL object, the SQL statements belonging to the update object are automatically applied when cached updates are applied.

See Also

Personal tools
In Other Languages
Previous Versions
Assistance