Package SQL Query

Command sqlquery_addCondition	Adds a condition to a query by creating a scope and assigning the condition to it.
Command sqlquery_addScope	Adds an existing Scope object to a SQL Query Object.
Command sqlquery_close	Closes an open database cursor associated with a SQL Query Object.
Command sqlquery_convertToArray	Converts a SQL Object's open database cursor into an array.
Command sqlquery_convertToRecords	Converts a SQL Object's open database cursor into records.
Command sqlquery_create	Creates a record in a table.
Command sqlquery_currentRowToArray	Converts the current row of the SQL Query Object cursor to an array.
Command sqlquery_delete	Executes a DELETE query using the "where clause" of the SQL Query Object.
Command sqlquery_moveToFirstRecord	Navigates to the first record in a SQL Query Object's database cursor.
Command sqlquery_moveToLastRecord	Navigates to the last record in a SQL Query Object's database cursor.
Command sqlquery_moveToNextRecord	Navigates to the next record in a SQL Query Object's database cursor.
Command sqlquery_moveToPreviousRecord	Navigates to the previous record in a SQL Query Object's database cursor.
Command sqlquery_moveToRecord	Navigates to the specified record in a SQL Query Object's database cursor.
Command sqlquery_retrieve	Opens a database cursor for a SQL Query object.
Command sqlquery_retrieveAsArray	Executes a SQL Query Object query and returns the result as an array.
Command sqlquery_retrieveAsData	Executes a SQL Query Object query and returns the result as data from the selected columns (no cursor).
Command sqlquery_retrieveAsRecords	Executes a SQL Query Object query and returns the result as a Records array.
Command sqlquery_set	Sets properties on a SQL Query Object array.
Command sqlquery_setConditionsFromUserSearchString	Converts a search string into the condition property of a SQL Query Object.
Command sqlquery_update	Updates a record in a table.
Function sqlquery_createObject()	Creates a SQL Query Object from a SQL Query Template or a table.
Function sqlquery_get()	Retrieves properties of a SQL Query Object array.