APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Tips & Techniques :
Copying Files between Databases/Versions
The following example shows how all of the records in the CUSTOMER file in database AAA can be copied to the CUSTOMER file in database BBB:
      *      
      *        Open file in source database      
      *      
      SET      --- NEXT DATABASE              =      AAA      
      OPEN     SPF CUSTOMER  SHARE? Y  FAIL 0 CACHE? N      
      *
      BEG READ SPF CUSTOMER               HOLD 0 KEY IS  CUSTOMER NO
      *
      *        Open file in destination database
      *
      SET      --- NEXT DATABASE              =      BBB
      OPEN     SPF CUSTOMER  SHARE? Y  FAIL 0 CACHE? N
      WRITE    SPF CUSTOMER               FAIL 0
      *
      *        Open file in source database
      *
      SET      --- NEXT DATABASE              =      AAA
      OPEN     SPF CUSTOMER  SHARE? Y  FAIL 0 CACHE? N
      *
      END READ SPF CUSTOMER
When you use the above technique to switch between a file that has been created in two different databases, the two databases MUST be associated with the same application version. In the System Administration file for Databases / Applications, database AAA and database BBB must both identify a startup application with the same Version.
For example, if the Startup Application for database AAA is XXX 01, then the startup application for database BBB must also have a version of "01". The application ID can be different but the version must be the same.

[Append to This Answer]
2005-Oct-07 3:43pm
Previous: (Answer) How can i set default values during data entry and make Appx remember them from one entry to the next one?
Next: (Answer) Adding new fileds with defualt values to an existent file
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=603
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.