>>I am trying to zap a table and keep getting error message saying:
>>
>Command Cannot be issued on a table with cursors in table buffering mode
>>
>>On the form I have a grid linked to view called lv_status_tbl. In the dataenvironment I have a table exclusive status_tbl and a view lv_status_tbl. I have set buffering mode to none, optimistic and pessimistic but not difference. I am issuing the following commands in my cmdzap button:
>>
>>

> select status_tbl
>>SET SAFETY OFF
>>ZAP
>>SET SAFETY ON
>>REQUERY('lv_status_tbl')
>>thisform.Refresh()
>>

>>
>>Does anyone know what I am doing wrong?
>>
>>Thanks
>>Nick Patel
>
>Put select your table before ZAP command
Thanks for replying. Now I get the message that "file must be opened exclusively" and in my dataenvironment the status_tbl has exclusive=.t. If I do the following:

Use status_tbl exclusive
select status_tbl
SET SAFETY OFF
ZAP
SET SAFETY ON
REQUERY('lv_status_tbl')
thisform.Refresh()

I get message that "file is in use"

Thanks
Nick Patel