Hi,
Don't know ColdFusion - how does it connect to the VFP data? Is it using the ODBC or OLE DB drivers?
I think you would need a stored procedure. If you want to delete ALL records in the table then you can use the ZAP command which is quicker than a DELETE ALL and PACK and doesn't require exclusive use of the table. Something like:
USE myTable IN 0
ZAP
USE IN mytable
should do the trick. Or you could use SQLEXEC() to drop and recreate the table.
Regards,
Viv