When creating the Database, it uses exactly the same table casing as shown in the GeneXus IDE; otherwise, it creates the tables using the uppercase function.
Level: Environment
The Default value is True. However, when converting a KB from GeneXus 9.0, the False value is assigned to maintain compatibility.
This property applies only at design-time.
When creating the Database, it uses exactly the same table casing as shown in the GeneXus IDE.
SQL statements are also generated using the same table casing shown in the GeneXus IDE.
Example:
reorg.cs: " CREATE TABLE Transaction1 (AaA smallint NOT NULL , BbB char(20) NOT NULL , PRIMARY KEY(AaA)) "
transaction1.cs: "SELECT AaA, BbB FROM Transaction1 WITH (UPDLOCK) WHERE AaA = @AaA "
When creating the database, it creates the tables using the uppercase function. The same criterion is used for table casing in SQL statements.
Example:
reorg.cs: " CREATE TABLE TRANSACTION1 (AaA smallint NOT NULL , BbB char(20) NOT NULL , PRIMARY KEY(AaA)) "
transaction1.cs= "SELECT AaA, BbB FROM TRANSACTION1 WITH (UPDLOCK) WHERE AaA = @AaA "