Hello,

This should be a simple problem but it's driving me mad:

I have a source table (tableA.dbf) and destination table (tableB.dbf) in two separate locations and i'm reading the source table, manipulating the data then outputting to the destination table. The source table is within a Foxpro database but the destination table is a stand alone foxpro table.

The problem is when i try to clear the destination table before i output to it, i get an error on the ZAP command (cannot access the selected table).

I think it's either a problem with my syntax or a problem with the data paths.

lcOutputName = "tableB"
lcOutputPath = "C:\Output\tableB.dbf"
IF NOT USED(lcOutputName) THEN
USE (lcOutputPath) IN 0 EXCLUSIVE
SET SAFETY OFF
ZAP
SET SAFETY ON
ENDIF

Any guidance please.