Search found 3 matches
- 08.05.2007, 02:16
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: How to add quotes `` to the field name
- Replies: 6
- Views: 1317
I've found the reason looking at IsCaseSensitive function. It has inernal list of reserved MySQL words, and 'limit' was not there. The reserved word list is much bigger actually - http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html - about 250 words, while this function lists only 27. I'm afr...
- 07.05.2007, 13:34
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: How to add quotes `` to the field name
- Replies: 6
- Views: 1317
- 07.05.2007, 05:28
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: How to add quotes `` to the field name
- Replies: 6
- Views: 1317
How to add quotes `` to the field name
Hi all, I have a table with a field called 'limit'. Zeos causes an exception on insert action because 'limit' is a reserved word and I need to quote it as `limit`. But how to do that ? I use DBEdit linked with the 'limit' field and can't add quotes to its FieldName property, as it causes 'field not ...