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


Sharon,

You have to either select the table first or specify what/where to zap

>lcOutputName = "tableB"
>lcOutputPath = "C:\Output\tableB.dbf"
>IF NOT USED(lcOutputName) THEN

USE (lcOutputPath) IN 0 EXCLUSIVE alias (m.lcOutputName)
local s
s = select(0)
select (m.lcOutputName)

>SET SAFETY OFF
>ZAP
>SET SAFETY ON

select (m.s)
>ENDIF

>lcOutputName = "tableB"
>lcOutputPath = "C:\Output\tableB.dbf"
>IF NOT USED(lcOutputName) THEN

USE (lcOutputPath) IN 0 EXCLUSIVE alias (m.lcOutputName)
>SET SAFETY OFF

ZAP in (m.lcOutputName)


>SET SAFETY ON

>ENDIF

>Any guidance please.