Compact DB and primary keys
Posted: Wed 25 Jul 2018 15:25
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
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