UPDATE. I downloaded server's version of the shared base program and I'm not getting that problem anymore. Not sure what exactly it was, I was reproducing it repeatedly.

Hi everybody,

I'm having a very puzzling problem. I'm trying to update a table from VFP using tableupdate command (that table is made a remote view using our special make_view_updatable method).

I'm getting this failure 219-Tableupdate() Error# 1492 - No key columns are specified for the update table ...

However, this error is misleading as the KeyFieldList is properly set to Id column. I suspect the error may be coming from a trigger on that table (I need to double check if there is one).

I want to see what exactly is being sent to SQL Server when this update command is executed. I'm firing SQL Server Profiler and I tried to include a few events, but I don't see anything being send. I did verify in the command window that the KeyFieldList is indeed set.

Did someone encounter similar error? Is there a way to figure out what may be going on?

Thanks in advance.