f2s_default_letter_casing¶
Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers
Syntax
set_attribute f2s_default_letter_casing of {DriverID} to {constant}
get_attribute f2s_default_letter_casing of {DriverID} to {constant}
Parameter |
Description |
|---|---|
DriverID |
The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID. |
constant |
Integer constant: 0=FILE_CASING_UPPER; 1=FILE_CASING_LOWER; 2=FILE_CASING_KEEP |
Description
This attribute is used to get or set the file casing standard when creating or restructuring tables. By default, all table and column names are created using the specified casing. Setting this attribute does NOT need to be done within a structure_start/structure_end block. This does not make changes to the structure, it just sets the default for when you do.
Constant |
Value |
Description |
|---|---|---|
FILE_CASING_UPPER |
0 |
All created or edited object names will be converted to uppercase |
FILE_CASING_LOWER |
1 |
All created or edited object names will be converted to lowercase |
FILE_CASING_KEEP |
2 |
All created or edited object names will keep their inputed casing |
Examples
get_attribute
Integer iCasing
String sCasing
get_attribute f2s_default_letter_casing of _f2s_ActiveDriverId to iCasing
If (iCasing=FILE_CASING_UPPER) Move "Upper" to sCasing
Else If (iCasing=FILE_CASING_LOWER) Move "Lower" to sCasing
Else If (iCasing=FILE_CASING_KEEP) Move "Keep" to sCasing
Showln (SFormat("The casing is %1",sCasing))
set_attribute
set_attribute f2s_default_letter_casing of _f2s_ActiveDriverId to FILE_CASING_UPPER
In the above example, the default letter casing of all columns and tables created after setting this attribute will be uppercase regardless of the case of the string used.
Replaces: Commands GET_DEFAULT_FILE_CASING and SET_DEFAULT_FILE_CASING