RecClose method

Closes record level processing. Returns True if successful, otherwise False.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
✓	✓	✓	✓

Parameters

Name	Type	Description
Cancel	Boolean (optional)	Cancels database update.

RecClose must be used after any sequence of update operations, to ensure the updates are all applied. The Cancel option is only available in RsetData and cancels the database updates.

Record level procedures are used to process records individually in all Xdata objects. In the case of TableData, these record level procedures are buffered (100 worksheet rows at a time) which makes for very efficient sequential processing. However for random processing of datasets larger than 100 rows, this will be inefficient and it is better to use the Buffer, Value or Text properties.