Good morning to all. My question today is. Can you delete a transaction from the data base? Example your running a part in PCDMIS and the data is sent to Datapage , you now realize that the data is bad , you would like to remove just that transaction. Can this be done? Is it too late? Thank you for the help.
Data cannot be removed within Datapage. You have to use Datapage Editor. I'm usnig version 3.24 Your's may or may not be the same.
Once you are in the correct database in Editor go to the VIEW pulldown menu, then DATA VALUES. DATA VALUES will fly open then choose DATA VALUES again. This will give you a dialog box with a pull down at the top showing all the parts in that database. Scroll down and find the part you need to change. Once you have selected to right one make sure to SELECT ALL under both the VARIABLES and TRANSACTIONS sections.
When you have done this a window will open showing your data. Find the transaction you want to delete and click on it to highlight it. As a precautionary measure also click on the first data entry for that transaction. ONce these are selected go to the EDIT pull down menu. In EDIT you have SAVE, NEW, DELETE, and COPY options. Move the mouse pointer to DELETE and it will fly open giving you SELECTED VARIABLES, SELECTED TRANSACIONS SELECTED DATA VALUES. Pick the one you need. You will get a confirmation message but once you delete something it's gone and cannot be recovered so be sure you have the correct data chosen.
HTH
BEFORE deleting any data/transactions, BACK UP YOUR DATABASE, then if you do a 'boo-boo', you can get it back. While in the editor, simply go to:
DATABASE
ASCII ARCHIVE ~ DUMP
enter a FILENAME in the filename box
click on LIST DATABASE
Select ALL the parts in the list (or just the one you are working on)
click on DUMP.
This will dump ALL the data into an ascii text file
OR,
Find the directory that holds the database and make a copy of it.
Data cannot be removed within Datapage. You have to use Datapage Editor. I'm usnig version 3.24 Your's may or may not be the same.
Once you are in the correct database in Editor go to the VIEW pulldown menu, then DATA VALUES. DATA VALUES will fly open then choose DATA VALUES again. This will give you a dialog box with a pull down at the top showing all the parts in that database. Scroll down and find the part you need to change. Once you have selected to right one make sure to SELECT ALL under both the VARIABLES and TRANSACTIONS sections.
When you have done this a window will open showing your data. Find the transaction you want to delete and click on it to highlight it. As a precautionary measure also click on the first data entry for that transaction. ONce these are selected go to the EDIT pull down menu. In EDIT you have SAVE, NEW, DELETE, and COPY options. Move the mouse pointer to DELETE and it will fly open giving you SELECTED VARIABLES, SELECTED TRANSACIONS SELECTED DATA VALUES. Pick the one you need. You will get a confirmation message but once you delete something it's gone and cannot be recovered so be sure you have the correct data chosen.
HTH
BEFORE deleting any data/transactions, BACK UP YOUR DATABASE, then if you do a 'boo-boo', you can get it back. While in the editor, simply go to:
DATABASE
ASCII ARCHIVE ~ DUMP
enter a FILENAME in the filename box
click on LIST DATABASE
Select ALL the parts in the list (or just the one you are working on)
click on DUMP.
This will dump ALL the data into an ascii text file
OR,
Find the directory that holds the database and make a copy of it.
