>>The only down-side to deleting all the rows through a view is that the DELETEs are logged. If you truly want to zap a table on SQL Server, and rollback isn't necessary, hijack the connection using CURSORGETPROP and use SQLExec to issue a TRUNCATE TABLE 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?
Michael's suggestion is SQL Server specific. Your solution was probably the fastest with VFP tables on the backend.
Erik Moore
Clientelligence