Page 1 of 1

Cannot use this otherwise legal fieldname with SDAC

Posted: Fri 27 Nov 2009 19:05
by DerPaul
Hi

Logget på is a legal fieldname in SQL, but I can't make it work with SDAC.

If I use [], it's not reckognized, if I don't I get a syntax error and ' or " doesn't work either.

What can I do?


Yours

Poul

Posted: Mon 30 Nov 2009 07:41
by Dimon
Please send me a complete small sample to dmitryg*devart*com to demonstrate the problem, including a script to create and fill table.

Posted: Mon 04 Jan 2010 14:57
by Dimon
The problem is that the field name contains Unicode symbol and only Delphi 2009 allows to use Unicode characters in a SQL query.