See Also Properties Methods Events Example
Unit
MySQLDataset
Applies to
TMySQLDataset TMySQLTable and TMySQLQuery components
Declaration
property CachedUpdates: boolean;
Description
Setting this property to True will cause all SQLUpdate, SQLInsert, SQLDelete, SQLBatch statements to be cached locally in final format and only be executed with the next Close or Refresh method calls on this dataset. This gives your dataset an almost "offline" mode in which it can collect all your updates and only post them to the server as specific times instead of in realtime to the mysql server. You can access these updates using the SQLCached property at runtime, if you wish to save them to file in case of failure of the mysql server or even just to inspect the final sql statements the dataset is sending to the server for debug purposes.