SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

Package SQL Query

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