f$SQLSetting (f$SQLEinstellung)

f$SQLSetting (f$SQLEinstellung)

With this function you can manage the behavior of SQL functions.

The setting is integer type.

Setting 1 switches case sensitivity on and off.

Value 1: the columns in the table must be identical with the ePOS parameters

Value 0:with the f$SQLBindPG, f$SQLUpdate, f$SQLInsert und f$SQLRead_to_PG functions, the

upper and lower case writing in the ePOS parameter columns can be different.

This setting is used with Oracle.

Setting 2 inserts WHERE FALSE as a condition when reading the table information for the f$SQLInsert function, if value 1 is given. If value 2, WHERE 1=0 is entered. With some database systems this brings advantages in terms of speed.

Setting 3 activates the use of the universal date format YYYYMMDD HH:MM:SS with the f$SQLInsert and f$SQLUpdate functions.

Note: these functions are used in the SMPAPI functions.