Fieldname must be case sensitive IOS Firemonkey when region changed on iPad

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
witzl
Posts: 14
Joined: Fri 21 Apr 2017 10:01

Fieldname must be case sensitive IOS Firemonkey when region changed on iPad

Post by witzl » Fri 28 Dec 2018 18:19

Hi,

when setting the iPad to Region "Belgium" and Language "Netherlands" I encounter SQL-Errors. When setting it to german or english it works all fine.

After reseach I fuggured that the Fieldnames have to be case-sensitive:

locate('DeviceID', 12345, []) works,
locate('DEVICEID', 12345, []) does not work - Error Field not found!

SQL-Server is 2016
SDAC-Client is 8.1.6, provider is prDirect
iPad OS is 11.4.1

I cannot change all Fieldnames to lower case.

Thanks in advance,
Dietrich

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Fieldname must be case sensitive IOS Firemonkey when region changed on iPad

Post by Stellar » Fri 04 Jan 2019 16:11

Unfortunately, we can't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

Post Reply