SQL functions: Special case

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Access via ODBC or OLE DB

Big Data

HFSQL functions

Handling a CEDB database

Managing 3-tier architecture

Managing HFSQL Client/Server

Managing HFSQL Cluster

Managing log processes

Managing replications

SQL functions: Special case

Managing tabulations in the items

Managing Float during an Oracle access via ODBC

See also

Accessing HFSQL files via SAMBA on Linux

Accessing the databases: summary

Analysis shared between earlier WINDEV applications and WINDEV 24 applications

Assisted management of HFSQL errors

Automatic data file modification: new date format

Automatic modification of data files

Browsing the HFSQL data files

Communication by GPRS

Connecting to a database via RPC

Errors while managing data files

Filtering a data file, a view or a query

Functions for HFSQL management

HFSQL data files exceeding 2 gigabytes

HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003

HFSQL management functions (prefixed syntax)

HFSQL thumbnails

HFSQL: Change of name

Hyper File functions available for backward compatibility

Locking data files: correspondence between WINDEV 5.5 and the later versions

Management errors specific to Native Accesses

Managing NULL in HFSQL

Managing aliases on the data files

Managing connections

Managing space characters in the searches?

Managing the Unicode format in the HFSQL files

Managing the automatic identifiers when adding a record

Modifying the query content

Native Access access

Native XML Access

Optimizing the remote access

Partial indexing of memos

Remote access (RPC on HFSQL)

SQL functions: Special case

Search and full-text index

Synchronizing data (Windows CE)

The .REP file

The HFSQL views

The composite keys

The different types of browse available in SQL

Unalterable data files

WDModFic : Tool for automatic modification of data files

Managing tabulations in the items
Managing Float during an Oracle access via ODBC
Retrieving Float items on Oracle (via ODBC)

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

The different types of browse available in SQL

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. See the help about SQLCol and SQLAssociate for more details.	This type of browse can be used to retrieve the tabulations found in the values of records. See the help about SQLGetCol for more details.
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")

See Types of SQL browse for more details.

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")