Hello,
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?
Bye,
Jürgen
Compact DB and primary keys
Re: Compact DB and primary keys
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.