raveens
23-Feb-2017, 03:50 PM
HI DAW,
Using the SQL Conversion Wizard - if you accidentally use a right-click on the Grid that shows the Table & indexes - you get a COM is null error as below:
10676
Also, found that (after killing the process and restarting it and carefully not touching the Grid this time), all the table & field names are created using case-sensitive names
10677
This means if I want to access the table via SQL I have to write the SQL statement as:
SELECT * FROM RP."WebAppServerProps" where "Data" = ''
The following statements will fail - because all the field names and table name are case-sensitive
SELECT * FROM RP.WebAppServerProps where "Data" = ''
SELECT * FROM RP.WebAppServerProps where Data = ''
SELECT * FROM RP.WEBAPPSERVERPROPS where "Data" = ''
SELECT * FROM RP."WebAppServerProps" where DATA = ''
It would be nice to have a "checkbox" on the wizard OR a driver attribute in DB2_DRV.INT to create case-insensitive table and field names.
See: http://support.dataaccess.com/Forums/showthread.php?60210-Suggestion-Driver-Attributes-for-Table-Field-Name-case-insensitivity
I guess the question is: But the user defined the Table as WebAppServerProps why change it?
A case-insensitive table can be create as per:
10678
Where the physical back-end table is case-insensitive or uppercased, but the FILELIST entry is recorded as above - best of both worlds !! (for table names at least)
Thanks
Using the SQL Conversion Wizard - if you accidentally use a right-click on the Grid that shows the Table & indexes - you get a COM is null error as below:
10676
Also, found that (after killing the process and restarting it and carefully not touching the Grid this time), all the table & field names are created using case-sensitive names
10677
This means if I want to access the table via SQL I have to write the SQL statement as:
SELECT * FROM RP."WebAppServerProps" where "Data" = ''
The following statements will fail - because all the field names and table name are case-sensitive
SELECT * FROM RP.WebAppServerProps where "Data" = ''
SELECT * FROM RP.WebAppServerProps where Data = ''
SELECT * FROM RP.WEBAPPSERVERPROPS where "Data" = ''
SELECT * FROM RP."WebAppServerProps" where DATA = ''
It would be nice to have a "checkbox" on the wizard OR a driver attribute in DB2_DRV.INT to create case-insensitive table and field names.
See: http://support.dataaccess.com/Forums/showthread.php?60210-Suggestion-Driver-Attributes-for-Table-Field-Name-case-insensitivity
I guess the question is: But the user defined the Table as WebAppServerProps why change it?
A case-insensitive table can be create as per:
10678
Where the physical back-end table is case-insensitive or uppercased, but the FILELIST entry is recorded as above - best of both worlds !! (for table names at least)
Thanks