Cannot use this otherwise legal fieldname with SDAC

DerPaul · Post by **DerPaul** » Fri 27 Nov 2009 19:05

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

Dimon · Post by **Dimon** » Mon 30 Nov 2009 07:41

Please send me a complete small sample to dmitryg*devart*com to demonstrate the problem, including a script to create and fill table.

Dimon · Post by **Dimon** » Mon 04 Jan 2010 14:57

The problem is that the field name contains Unicode symbol and only Delphi 2009 allows to use Unicode characters in a SQL query.