Description
Executes a given SQL statement and returns a copy of record data in the form of an array.
Syntax
x = CExec.ExecFillArray (ByVal sConnect As String, ByVal sQry As String, sTemp As Variant, Optional ByVal bAddColumnName As Boolean)
Parameters
ByVal sConnect as String
ByVal sQry as String
sTemp as Variant
Optional ByVal bAddColumnName as Boolean
Return type
Boolean
Remarks
Given a connection string and a SQL statement to execute, ExecFillArray will fill a user-supplied array with the returned data. The first column of the array corresponds to the first field returned by the query; the next column corresponds to the next field, and so on. Each row of the array corresponds to an individual record. Optionally, each element in the first row can contain the name of the field for that column.
Description
Executes a given SQL statement and returns true or false depending on the success of execution.
Syntax
x = CExec.ExecQuery (ByVal sConnect As String, ByVal sQry As String)
Parameters
ByVal sConnect as String
ByVal sQry as String
Return type
Boolean
Remarks
This method does not return any data other than success or failure of execution of the supplied SQL statement. In order to have data returned from a query execution, use the ExecFillArray method.