|
|
|
|
|
|
|
|
- Managing tabulations in the items
- Managing Float during an Oracle access via ODBC
- Retrieving Float items on Oracle (via ODBC)
SQL functions: Special case
Managing tabulations in the items Depending on the type of browse implemented with the SQL functions, the management of the tabulations in the items will differ: | | | | Type of browse: SQLFirst/SQLCol | Type of browse: SQLFetch/SQLGetCol | | Management of tabulations | This type of browse cannot be used to retrieve the tabulations found in the values of records. A tabulation separates two items. Only the part found before the tabulation will be retrieved by the read functions.
For more details, see the help about SQLCol and SQLAssociate. | This type of browse can be used to retrieve the tabulations found in the values of records.
For more details, see the help about SQLGetCol. | | Example | ResExec = SQLExec("SELECT CUSTNAME " + ...
"FROM INV", "QRY1")
IF ResExec=True THEN
SQLFirst("QRY1")
// Transfer the name into
// LIST_NAME
WHILE NOT SQL.Out
ListAdd(LIST_NAME, ...
SQLCol("QRY1" ,1))
SQLNext("QRY1")
END
ELSE
// ProcessError
END
SQLClose("QRY1") | i is int = 0
SQLExec("SELECT LASTNAME, FIRSTNAME," + ...
"EXTENSION,PHOTO FROM CUSTOMER", ...
"QRY1" )
// Retrieve the query row by row
WHILE SQLFetch("QRY1") = 0
// There is still another line
i++
// Retrieve the data
LASTNAME[i] = SQLGetCol("QRY1", 1)
FIRSTNAME[i] = SQLGetCol("QRY1", 2)
EXTENSION[i] = SQLGetCol("QRY1", 3)
{"IMAGE" +i} = ...
SQLGetMemo("QRY1", 4)
END
SQLClose("QRY1") |
For more details, see Types of SQL browse. Managing Float during an Oracle access via ODBC Retrieving Float items on Oracle (via ODBC) By default, the decimal separator used for the Float items on Oracle is the dot. However, the ODBC driver returns the value by using the comma as decimal separator. The decimal places are lost when the value is assigned to a numeric control. To avoid this problem, you must configure the decimal separator for the current connection: // Connection to the Oracle database
SQLConnect("MyOracleDatabase", "User", "Pass", "", "ODBC")
// Request for changing the decimal separator
SQLExec("ALTER SESSION SET NLS_NUMERIC_CHARACTERS ='. '", "TempQry") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|