Search found 3 matches

by softshape
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...
by softshape
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

It really looks like a workaround; TZTable, in my application and in general, is quite convenient in other aspects and I don't want to drop it.
by softshape
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 ...