>>Not yet, it was a guess from my part. If you're sure the files were not created (did you specify the full path for the files, because they may be in a different place you expect them?), then we need to do a bit more research checking VFP OleDB documentation in regards to triggers/SP, look closely at the trigger code, etc.
>>
>>
http://msdn2.microsoft.com/en-us/library/80x51c04(VS.80).aspx - supported commands
>>
http://msdn2.microsoft.com/en-us/library/bt5d78fx(VS.80).aspx - unsupported commands
>>
>>Can you proceed from there and post your findings?
>>
>>Thanks.
>>
>>BTW, I see, that STRTOFILE is unsupported function. Let's check if there are some other means to create a log file supported.
>
>I took a quick look and I don't see an easy way to create some logfile output from the trigger since most of the commands writting to file are unsupported.
I found this
http://weblogs.foxite.com/ericdendoop/archive/2005/05/18/457.aspxSo, are you sure you specified all parameters?
RE: Trigger failed in OLEDB Thread ID:
50041 on foxite.com (
http://www.foxite.com/archives/trigger-failed-in-oledb-0000050241.htm ) with no solution.
Also I found someone with the same question but no answer
http://www.thescripts.com/forum/thread282698.htmlSo, so far I found few same quesitons on the net, but none seems to have a solutuion.
If it's not broken, fix it until it is.
My Blog