You can get use CURSORGETPROP() to get the connection handle that the view is using to communicate with the remote data source. I was suggesting something like this:
LOCAL hConn, nResult
USE view_name NODATA
hConn = CURSORGETPROP("CONNECTHANDLE", "view_name")
nResult = SQLEXEC(hConn, "TRUNCATE TABLE table_name")
RELEASE hConn
There is a help file that covers the VFP ODBC driver: DRVVFP.HLP. It doesn't list ZAP has an unsupported command.
-Mike
>PMFJI. I was helping someone using VB with and ADO connection to a VFP table. They wanted to zap the table, I suggeted using a VFP com object to perform a ZAP on the table.
>
>It sounds like your solution is much more effecient. Can you elaborate or give an example on how you would "Hijack the connection" and issue a TRUNCATE TABLE?