VFP Tables

Questions and answers regarding general SQL and backend databases

VFP Tables

Postby kiernan7a » Sat Oct 28, 2017 4:53 am

(I didn't know where else to put this, as there isn't a "Other Databases" section.)

I'm trying to hook up a form to a Visual Foxpro table. However, I get an error where it says the table does not have a primary key. It does indeed, an "ID" field that is an autocrement field. There is no official Primary Key like in mySQL. What is it that Servoy wants from that table.

Thanks in advance!

John Kiernan
TBC Software
kiernan7a
 
Posts: 2
Joined: Sat Oct 28, 2017 4:49 am

Re: VFP Tables

Postby patrick » Sat Oct 28, 2017 11:00 am

To be able to update records, Servoy needs to know how to uniquely identify which record it wants to update. Usually this is done with primary keys.

If you know what makes a record unique in your table, you can let Servoy know by selecting "row_ident" from the drop down in the "Row ident" column in the table editor. That can be set on one or more columns. Servoy will use all row ident columns then to uniquely address a record.
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 7 guests