All of a sudden I am getting an error in retrieving form data due to no primary key. I checked the SQL table and there is a field designated as such, that same field appears in dataproviders as a Servoy Sequence but primary key box is not checked.
Any suggestions?
Using R2.2.0.2 on WinXP box
If you create a new form in a new solution on that table do you still get that error?
This just happened to me last night. I can see the Primary key the back end, but in the data provider the primary key is unchecked. At this point you cannot create a primary key through the data provider rendering your table useless.
Fortunatly, it was a small table and I am just playing around with various functions. I had to re create the table. I have come to the conclusion that might be safer to create tables through the backend first.
Using R2.2.0.2 on WinXP box
i have currently no idee why suddenly the PK property is lost from a column. We will check this out. But it is not saver to create tables through the backend. Because in servoy we have much more checks before we accept for example column names.
I like to create in the backend because I can control the field order and camel case my filed names. I would rather use servoy to cerate tables and fields, but with multiple fields I would have to create an alphabetic naming convention to sort through fields.