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
No primary key
3 posts
• Page 1 of 1
No primary key
by abeermann » Wed Nov 30, 2011 6:23 pm
- abeermann
- Posts: 106
- Joined: Fri Nov 26, 2010 12:46 pm
Re: No primary key
by kwpsd » Wed Nov 30, 2011 11:36 pm
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!
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!
Kim W. Premuda
San Diego, CA USA
San Diego, CA USA
-
kwpsd - Posts: 687
- Joined: Sat Jul 28, 2007 6:59 pm
- Location: San Diego, CA USA
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 15 guests