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