Hi,
>>Viv, Coldfusion uses ODBC for VFP. I think using a stored procedure would do the trick. However, I'm not sure how to implement it. Where exactly do I put the code and how is it triggered to run? Is there a quick tutorial somewhere? Thanks for your help.
I think you need OLEDB to execute a VFP stored procedure directly. With ODBC you could bodge it by having the stored procedure as, for example, an update trigger on a 'dummy' table. However,given the handle, you should be able to just use :
=SQLEXECUTE(nHandle,"SET EXCLUSIVE ON;PACK mytable")
See Q234756 in the MSDN KB for more detail.
HTH,
Viv