USE i:\ronnie\povnst1.dbf IN 0 EXCLUSIVEDon't hardcode the path to the table. Put the path in a reference table and do a SET PATH TO at the start of your application. Also, do you really need to open your table exclusively?
USE i:\ronnie\povnst1.dbf IN 0 EXCLUSIVE SELECT 0Should read:
USE povnst1 IN 0 SELECT povnst1The next line is commented out, is that what you want?
*INDEX on vnd_id TAG vnd_id
RECCOUNT() does count the deleted records. Is that what you need? Otherwise, use the COUNT command:*COUNT1 = RECCOUNT() COUNT TO Count1HTH