Sequence Type 'servoy seq' in Table

Classic Servoy
1

We are converting our Visual FoxPro (VFP) product to Servoy. Most of the tables we use in Servoy are SQL-based, however, we have a need to connect to some legacy VFP free-standing tables. To do this, we purchased the StelsDBF jdbc driver and installed it. The first time we attempted to attach to a VFP table, Servoy complained that the table did not have a primary key.

In VFP, we modified the table structure and added a field called ‘pk’ which contains unique sequential numbers. When we use Servoy to attach to the table a second time, it still complained about not having a primary key.

What we discovered, using Servoy Developer, is that we have to open the table properties and set its Sequence Type to ‘servoy seq’. Once we do this, Servoy can then use the table without throwing an exception error. I have a couple of questions:

What is the ‘servoy seq’ type, and what does it do (automatic sequencing of a field from the Servoy reference guide)?

Can the Sequence Type be set programatically such that we do not have to manually set it to ‘servoy seq’ . And, if so, how do you do this?

Thanks!

2

Servoy complained that the table did not have a primary key.

Something Servoy doesn’t discover the pk,

Considering that your Foxpro table has a primary key
You don’t need to create new fields
Goto to database manager , on each table , verify that you have at least one field with pk in RowIdent Properties, if not assign “pk” in the RowIdent propertie of your pk fields