When the hQueryWithoutCorrection mode is used, the SQL statement is sent directly to SQL/400 without being interpreted or changed by WinDev SQL engine.
You must use this mode when the statement contains some syntax or keywords WinDev doesn’t know.
|
hQueryDefault |
hQueryWithoutCorrection |
|
Connection is automaticaly identified, using the files involved in the query. |
Connection must be given when calling HExecuteSQLQuery. |
|
Replace all PC Soft proprietary operator (Example: ']=' |
No replacement is done. You need to type SQL/400 compliant syntax. |
|
Date and time constant are translated into SQL/400 format. |
No format translation. You need to type data and time values in SQL/400 syntax. |
|
Decimal point is adjusted for décimal constant, depending on the system language. |
You need to use the right decimal point for your system. |
|
Alias names are replaced by original column names in the Where, Order by and Group by clauses. |
No replacement. Use only original database column names. |