I want to delete all the unposted contributions

[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

[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

[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.

[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.