FAQ's - APPX Software, Inc.: Merge and Replace application data files with the Database Management Import utility.

APPX is the Premier Development and Runtime Environment for Business Application Software

	FAQ's - APPX Software, Inc. : APPX Utility : APPX System Administration : Merge and Replace application data files with the Database Management Import utility.
	You have two options for importing data into an Appx application data file, Merge and Replace. Both options require an import file matching the specifications of the application file. The import file must reside in the Portdata directory for the application. The Replace option (defualt) initializes the existing application file and then reads and writes all the records from the import file into the application file. Similarly, merge writes records to the application file from the merge file however the application file is not initialized. If the primary key value in the import file and application file match, then the application file record is replaced with the record from the import file. If the primary key value from the import file is not found in the application file then the import file record is added to the application file. The only time a matching primary key record is not replaced is when there is a unique alternate key defined and the unique key value exists in another application file record. Records in the import file are fixed length and should not be altered before importing. We recommend backing up your application file .dat and .key file before importing records. The application file should be free of structure errors prior to importing records.
	[Append to This Answer]
	2009-Sep-04 5:38pm

	[Search]	[Appearance]
This is a Faq-O-Matic 2.719.