Welcome, Guest. Please Login.
05/09/25 at 06:33:37
News:
Home Help Search Login


Pages: 1
Send Topic Print
Missing PO line Items, How do I rebuild (Read 380 times)
spmaurer
Browser
*


I love YaBB 1G -
SP1!

Posts: 2
Missing PO line Items, How do I rebuild
03/26/04 at 08:01:52
 
I need to rebuild my PO line item table (BKAPPOL). Something happened to our live data and we are now missing several hundred lines. I have most of them in a demo db.  I don't want to lose data we have created since this happen.  Any ideas ???
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Missing PO line Items, How do I rebuild
Reply #1 - 03/26/04 at 09:37:26
 
If you can delete everything ELSE from a copy of the demo DB, Pervasive has a utility that you can use to merge files together.  IS Tech has a $49 Search & Replace utility that can also Search & Delete so if you can define the range of parameters to delete, you could use that.  
 
Once you have the backup file with nothing in it except what you want to merge into the live data, copy that file into your company subfolder with a different extension so that you have (for example) BKAPPOL.B and BKAPPOL.BXY in the same folder where the .B is your live data and the BXY is the additional records.  Then go to the Pervasive Utilities and run Maintenance - Data - Copy and copy BKAPPOL.BXY to BKAPPOL.B and the files will be merged.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print