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