>Hi
>In C# app, I want to Zap a VFP table using an OleDb Command Object
>I've tried for the Command.Text:
>" Set Exclu On ; Use MyTable ; delete All; Pack; Use"
> and
>" Set Exclu On \r\n Use MyTable \r\n delete All \r\n Pack \r\n; Use"
>
>but neither seem to work
>
>Any idease ,
>Tia
>Ger
Have you tried
CommandText = @"SET EXCLUSIVE ON
USE myTable IN 0 EXCLUSIVE
ZAP in MyTable";
If it's not broken, fix it until it is.
My Blog