Page 1 of 1

I want to delete all the unposted contributions

Posted: Tue Dec 03, 2024 11:47 am
by John Dykema
We're using PC v14. I messed up the unposted contributions entries and will need to reenter.
In the past I've used Database Manager with the command
USE COTRANS
DELETE ALL

Now when I enter 'USE COTRANS' I get an error saying COTRANS.dbf does not exist in v14.
Please help with this command. Thanks. John

Re: I want to delete all the unposted contributions

Posted: Tue Dec 03, 2024 11:57 am
by Zorak
Right, in Version 14, there are now no separate posted vs unposted data files. That introduced an opportunity for data corruption and other messes during the posting processes while moving data from one table to another.

As always, a huge disclaimer must be in place, since this is a public forum and people will find it in Google searches for eternity:

PLEASE MAKE A BACKUP BEFORE PROCEEDING

Code: Select all

USE CO
DELETE ALL FOR POST_ID = 0

Re: I want to delete all the unposted contributions

Posted: Tue Dec 03, 2024 2:19 pm
by John Dykema
I entered CODE; SELECT ALL
and it gave me a verb error. I then only put in the USE CO, ........ and it was successful. What's with the CODE; SELECT ALL?
Thanks.

Re: I want to delete all the unposted contributions

Posted: Tue Dec 03, 2024 3:00 pm
by Zorak
That's just put there in the

Code: Select all

code tag
in the forum. The Database Manager still just needs one command at a time.