Hi Bob,
I could not recreate the problem with the attached project, and I'm certain the reason for this is that you did not include the database itself (there's a checkbox in the export dialog which determines whether or not to include the database, which is unchecked by default), and therefore an empty database, whose schema is determined by the Database Record data elements in the model, was created once I launched the application.However, I'm pretty certain the origin of your problem has to do with the same mechanism which maintains the database schema. This mechanism is only able to create tables and add new columns to existing tables (it does not remove, rename or change the type of existing columns), and I'd hazard a guess that the Ship Database Database Record (mapped by default to the Ship_Database table in the database) did at one time contain a column whose name is the same as the ones it currently contains (Ship Name, Cost, Attack, etc.), but of a different data type, and along the way, you realized its type should be different and removed it only to recreate it as a different type.
The easiest solution to all of this, would be to delete the existing database and have it recreated. To do so:
Alternatively, if your database already contains data which cannot be easily recreated, you can edit the database structure as follows:
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign