We are attempting to import a solution that was developed in Servoy 6.0.9 - build 1239 into 7.2.0 - build 2013. One of the solution’s databases contains Visual FoxPro DBF files. The solution import process fails with the following error message:
Could not import solution: Data model change needed: server - arm_data_vfp table - aorders missing sequence(s) - ‘seq_aorders_pk’ but is not allowed from import preferences.
where ‘arm_data_vfp’ is the database name, and ‘aorders’ is the VFP DBF table name. ‘aorders’ does have a pk column that is set to Row Ident = row_ident, and Sequence Type = db_seq in the 6.0.9 solution.
Does anyone have any idea why the import is failing?
The ‘Allow data model (database) changes’ checkbox is ticked by default, and I do not change it when importing.
I think I stumbled across the problem…
When importing DBF tables, I discovered that a file is created for each table (e.g. seq_tableName_pk.SEQ) in the folder containing the DBF files. Apparently, if these SEQ files were created with a previous version of Servoy, they will not import into a newer version of Servoy. After deleting the SEQ files, I was able to successfully import the solution (which created a new set of SEQ files).
Question: What creates these files, Servoy or the HXTT DBF driver? If Servoy generated, it would be nice to know what the data represents:
