Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:execute [2019/05/08 16:34] – ADODB_ASSOC_CASE not $ADODB_ASSOC_CASE dregad
+++ v5:reference:connection:execute [2023/01/15 20:32] (current) – mnewnham
@@ Line 10: / Line 10: @@
 ===== Description =====
-This method executes any provided SQL statement. If the SQL statement should return a recordset, e.g. ''SELECT'' statements, it returns a handle to a recordset or false if the statement execution fails. If the statement does not return a recordset, such as in ''INSERT'' or ''UPDATE'' statement, it returns true on success or false on failure.
+This method executes any provided SQL statement. If the SQL statement should return a recordset, e.g. ''SELECT'' statements, it returns a handle to an [[v5:reference:connection:adodb_recordset|ADOrecordset_array]] object or false if the statement execution fails. If the statement does not return a recordset, such as in ''INSERT'' or ''UPDATE'' statement, it returns a handle to an [[v5:reference:connection:adodb_recordset_empty|ADOrecordset_empty]] object on success or false on failure.
@@ Line 20: / Line 20: @@
   - A string containing a complete SQL statement. ''SELECT * FROM ACT''
   - A string containing an SQL statement with bind variables, ''SELECT * FROM ACT WHERE empno>:emp'', in which case the second parameter is an array containing the bind variables.
-  - A array of SQL Statements. This is only available to internal functions.
 ==== Parameter 2 ====
 If set, contains an array of bind variables.