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