Cannot use this otherwise legal fieldname with SDAC

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
DerPaul
Posts: 17
Joined: Thu 25 Jan 2007 02:35

Cannot use this otherwise legal fieldname with SDAC

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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.

Post Reply