Easy to Create, Easy to Change - Easy to use!


Importing a Form & data from a different DE8 app


Started by dtagcayman@yahoo.com
Search
You will need to Sign In to be able to add or comment on the forum!

Importing a Form & data from a different DE8 app

Greetings all  Simple question ( I hope...)  I have two separate DE8 applications.  How can I import a form and it's data from one DE8 application to another DE8 application?  The form is flat with no lookups - it has about 40 records.  Can this be done easily?  Thank you !

Written by dtagcayman@yahoo.com 24/10/14 at 09:03:18 Dataease [{8}]FIVE

Re:Importing a Form

You can install a form with table and Data via Application/Utilities/Install in the Main Menu/Designer Menu.

To be able import the data with the Form and TDF file you need to make sure you run on a local drive without the Shared Local Database switch set. You find the Shared Local DataBase switch in the file menu before you open an app in DE8. Simple escape the Welcome Dialogue and choose.File/Options/Database Engine(tab). There you will she a check box for Shared Local Database. Uncheck this.

When installing a Form with Table and data, DataEase will sugest a Table with the same file name as the FRM. file. As TDF (and DBM) Change names when you change the table this might not be correct, so do a Status Report (Records) first and make sure that you have the matching .TDF filed for the FRM.
Typical would be (Customers form) CUSTAAAA.,FRM and CUSTAAAB.TDF.


 

It is important to do this check before importing as you will either import a wrong TDF for the form or the Table will not exist.

Written by DataEase 28/10/14 at 07:52:26 Dataease [{8}]FIVE