Compact DB and primary keys

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Juergen Bauer
Posts: 4
Joined: Fri 13 Jul 2018 09:54

Compact DB and primary keys

Post by Juergen Bauer » Wed 25 Jul 2018 15:25

I want to use the data access components to access a SQL compact DB.
The connection works as expected.
But as soon as I try to get the primary keys, I get only an empty list.

My code looks like this (Memo1 is a TMemo component on the form):

UniConnection1.Connected := True;
UniConnection1.GetKeyFieldNames ('SYS_HELP', Memo1.Lines);

When I do the same with a "real" SQL database, I get the expected column names.

Any idea?


Devart Team
Posts: 248
Joined: Tue 03 Oct 2017 11:00

Re: Compact DB and primary keys

Post by Stellar » Mon 30 Jul 2018 13:38

Thank you for the information. We have fixed the issue with getting the list of primary key fields for SQL Server Compact, and the fix will be included in the next SDAC build.

Post Reply