Mark,
>>What I am having problem now with is that my table has a trigger and that trigger fails. Shoud it work in case of a trigger?<If you have an update trigger, it should fire when you update your table, regardless of the fact that you're updating it through .NET ... at least that's the case with SQL Server triggers and I'm guessing the same would hold true for VFP triggers.
~~Bonnie