knulo
User
Senior Boarder
| Posts: 38 |   |
Karma: 1
|
|
Re:Lower case in update
|
|
Posted: 2007/06/30 07:39 |
|
|
|
|
Hello,
I had same problems with case sensitive table and field names. I fixed that by 'hacking' Dmitry's code (daADPhysMySQL.pas, line 432)
FNameCaseSensitive :=
QueryValue('SHOW VARIABLES LIKE ''lower_case_table_names''', 1) = '0';
|
and changed it to
FNameCaseSensitive :=
QueryValue('SHOW VARIABLES LIKE ''lower_case_table_names''', 1) <> '1';
|
In my MySQL environment there was NO variable lower_case_table_names set but tables and fields stored with upper- and lowercase letters.
You can look in debugger, how FNameCaseSensitive is set after that and if it's TRUE, your query should work.
See also:
I'm in communication with Dmitry about that issue and think it will be fixed in version 2.
Regards,
Knut
Post edited by: knulo, at: 2007/06/30 07:48
|
|
