Occurs when a query submitted to a database is done executing. This event returns information that indicates whether the query was successful. Error number 0 means that the query was successful.
Syntax
object_ExecuteComplete(pStatus as ErrObject,sQuery as String)
NOTE (CIMPLICITY USERS ONLY): The event handler above is named in accordance with the standard VBA naming convention. In CIMPLICITY, this convention is not followed and the default name for this event handler is OnExecuteComplete. You can use a name of your own choice for the event handler and use the Event tab to associate it with the ActiveX event in question. For some events you may notice that there are already handlers, in which case you should add your own processing to the existing handlers rather than replacing them.
Parameters
The ExecuteComplete event syntax has this part:
|
Part |
Description |
|
object |
An object expression that evaluates to an object in the Applies To list. |
The event returns a VB Error Object (pStatus) that contains the specific error number, description, source, and so on as defined in the following table:
|
Property |
Value |
|
object |
An object expression that evaluates to an object in the Applies To list. |
|
Number |
The Error code that specifies the error that occurred. |
|
Source |
The Name of the component that generated the error. |
|
Description |
A string corresponding to the return of the Error function for the specified Number, if this string exists. If the string doesn't exist, Description contains "Application-defined or object-defined error". |
|
HelpFile |
The fully qualified drive, path, and file name of the Visual Basic Help file. |
|
HelpContext |
The Visual Basic Help file context ID for the error corresponding to the Number property. |
|
LastDLLError |
On 32-bit Microsoft Windows operating systems only, contains the system error code for the last call to a dynamic-link library (DLL). The LastDLLError property is read-only. |
sQuery is a string that displays the parsed value of the last query submitted to the database. For example, it displays the last Select statement submitted, including the values assigned to any query properties defined to the query.
Remarks
Use the sQuery string, displayed in a Message box, to help you debug queries. For example, if the query returns no data or if the query returns unexpected results, you can use this string to determine the exact query submitted to the database.
