QuerySQL

<< Click to Display Table of Contents >>

Manual > Control Reference > Other > Direct query database(SQL) control > Method >

QuerySQL

 

Get the records resulting from executing SQL.

 

syntax

QuerySQL(

         sqlString,

         &fieldNum,

         &recordNum,

         &fieldName,

         &fieldType,

         &data

         )

 

Parameters

 

sqlString

Type:

character

SQL Command string.

 

&fieldNum

Type:

Number

Variable for storing the number of columns (number of fields) of the retrieved data.

 

&recordNum

Type:

Number

Variable for storing the number of rows (records) of retrieved data.

 

&fieldName

Type:

character

Variable for storing field names. This will be a one-dimensional array with the same number of columns.

 

&fieldType

Type:

Number

Variable for storing the code of the field data type. This will be a one-dimensional array with the same number of columns.

ODBC SQL data type or driver-specific SQL data type. Please connect to the target and check what code is obtained.

 

&data

Type:

Number

Variable for storing the acquired data. It is a two-dimensional array of number of columns x number of rows. Each data is acquired by data[column, row].

 

Return Value

Type:

Boolean

FALSE - Failure. TRUE - Success.

 

hmtoggle_plus1Explanation

Retrieves records resulting from executing SQL. The only required parameter is "SQL", and the rest are variables for storing information about the retrieved data and the data itself.

 

 

hmtoggle_plus1Example

 

 

 

var vFieldNum, vRecordNum, vFieldName, vFieldType, vData;
if (this.QuerySQL("SELECT * FROM TABLE1", vFieldNum, vRecordNum, vFieldName, vFieldType, vData))
{
a = vData[0,0]; //Data in column 0, row 0
a = vData[0,1]; //Data in column 0, row 1
}

 

 

reference

 

Connect

DisConnect

ExecuteSQL

QuerySQL

BeginTrans

CommitTrans

Rollback

SetQueryTimeout

GetLastError