>hi all,
>I'm trying to update a VFP table from c# code. It's a simple update command, update 1 field based on 1 condition in the where clause. It works on several other tables so I know that the code is okay. However I need to update 1 table which happens to have a trigger on the update. When I try this in VFP it's fine, however when trying it in .net it gives an error on the trigger element and does not work. I get this as the error
>system.data.oledb.oledbconnection (0x80004005): Trigger failed in TableName

What are you doing in the Trigger code?

The VFP OleDb driver is does not have access to all of FoxPro's language features, most likely you're using some language construct that's not supported in the trigger.