Hi!
If this is a view, stup it to use only key field(s) in the SQL WHERE clause. When using all fields or modified fields, there will be a lot of fields in the WHERE part of the UPDATE-SQL command that can cause error. If you need this anyway, than take a look to the SYS(3055) function. Look to help on this function anyway, it mentioning the error you posted here.
HTH.
>well, the error message lists the update with all the fields in my table. I'm assuming this is what happens when an Tableupdate command is issued?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.