Why Field name is Case Sensitive

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Daniel Fagnan
Posts: 55
Joined: Fri 13 Oct 2006 00:08

Why Field name is Case Sensitive

Post by Daniel Fagnan » Tue 04 Nov 2008 00:06

I Used a Lot :!: MySql

But for a new job i used Sql2005

When I used field in my code

Why JobIdentification is not Valid if in create of table the fieldname
was write JOBIDENTIFICATION

I should write my code with exact character case.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 04 Nov 2008 10:51

I could not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

Post Reply