Dispose()

Use the Dispose() method to instruct the SQLData Script Library to free all memory resources associated with the command object. If the command is running, Dispose() cancels it. It is preferred to cancel the command before calling Dispose().

Syntax

Void Dispose()

Remarks

After Dispose() is called, subsequent method calls to the command fail.

If an ID has been retrieved for this command object, you must call Dispose() or aaDBAccess.RemoveCommand().

If you requested the ID of this command object, it is very important that you call Dispose() so it can flag the SQLData Script Library to clear all the references to this object.

When you request a dataset it is very important for you to call the Dispose() method when you are no longer interested in the results of a specific command object.

If you have made changes to the memory dataset such as updating, deleting, or adding, but did not issue SaveChangesSync() or SaveChangesAsync(), all changes are discarded.

Subsequent method calls to request scrolling or to modify the memory dataset fail and return either a null object or error code 1016.