ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Pervasive SQL >> >> Unable to Delete record in MDB
http://www.istechforum.com/YaBB.pl?num=1622574130

Message started by gtladmin on 06/01/21 at 12:02:10

Title: Unable to Delete record in MDB
Post by gtladmin on 06/01/21 at 12:02:10

For some strange reason we are unable to delete the record for a bad sales order from the BKARINV table. In Maintain Datsabase (MDB) we find the record, select it in edit mode, then click in the minus link to delete. Confirm the delete. Nada. Still there. Go out and back in, still there for sure. It will not delete. Something weird, or something DA we are doing.

Anyone else had this problem, is there any way to delete it when it does this?

This record is causing issues--like printing sales order reports, for example. We can get a report of the latest SO # to the sales order just before this one, or the sales order just after this one to the earliest, but not a full list of the sales orders. It is also preventing us from using a range for sale order invoicing forcing the invoicing to be one at a time which is very time consuming.

Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Title: Re: Unable to Delete record in MDB
Post by Laura Oliver on 06/07/21 at 09:57:58

I assume you first tried to delete it in SO-A before BKARINV. Did you try to delete SO in both maintain database in DBA or just EVO? Did the bad SO accidentally get an unposted invoice number?