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

You could also...

IF NOT USED(lcOutputName)
  SELECT 0
  USE (m.lcOutputPath) EXCLUSIVE
  SET SAFETY OFF
  ZAP
  SET SAFETY ON
ENDIF

Nice to see someone using ZAP. Here's another use for it: http://msvfp.advisorguide.com/doc/08218