No primary key

Classic Servoy
1

Servoy 6.03
With servoy i want to look at some views in my MAXDB Database.
(no insert,update just show system informations)
These views have no primary key.
So i select the views in the developer and set one column with unique values to row_ident.
I did this before and it worked, but now i got errors:
Form xyz is based on table ‘viewxyz’ which does not have a primary key.
So i can’t export my solution.
Whats new?
What to do?
Regards
Albert

2

Hi, Albert.

You not only need to declare one of the columns as a primary key (row_ident), but you also have to declare the designated primary key column’s sequence type (try using ‘servoy seq’). We connect to Visual FoxPro tables this way, and if we forget to set the sequence type, Servoy will complain about not having a primary key.

I hope this helps!

3

Working.
Thank you !!!
Regards
Albert