This problem can be remedied by...
When creating view from a database and you want to include all the fields in the "view", re-arrange the view fields order. (use dbgetprop() to see the sql statement of the view). if the result is similar to "SELECT * from dbfFile", (notice of the *), that's where the problem arrise after changing the structure of the SOURCE file. In short, avoid "SELECT *" when creating a view.


> have an application that runs on a server, but also runs locally on a lot of notebooks.

> When there are changes to the system tables/views/structures etc. they are first made on the server and then
transferred to the notebooks.

> At the moment I am copying over the database(DBC,DCT,DCX) files when anything is changed.

> But when structures of tables are changed I issue a program that does this.

> I am now experience the problem that the DATABASE files are note matching the tables. Should I be transferring
the changes differently, or should I be ok just copying over the DATABASE files?