Try selecting the alias of the table you just opened just before the ZAP command.
regards
Mathias
>>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
Mathias Banda
Time is longer than a rope.