System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
IMPORTANT:
(1) This document requires knowledge of Pervasive SQL. It is imperative that you have a working backup of your data prior to running any of these steps.
(2) We cannot maintain any links to the customer and invoices for the gift card records. These links will be deleted as the invoices and or customer records would not exist after a System Restart.
Problem:
The dataset was restarted but the Gift Card transaction record is gone. A copy of the old data is available and we would like the Gift Card transaction data copied to the new dataset.
Solution
Copy giftcard.btr from the old data to the data folder of the new restarted data.
In PCC Run the following: UPDATE giftcard set Invoice=0 where Invoice > 0; UPDATE giftcard set customer=0 where customer > 0; UPDATE giftcard set trandata=0 where trandata > 0;
This will still keep the original giftcard history, even though the invoices are gone.
Author: cralph Editor: arose Last Edited: 9 -Oct-2007