The update statement is staright from the MM class library.
>Bob, It would appear you have an UPDATE statement with a WHERE clause. The error message is saying that you cannot use a general field in the WHERE clause section of your UPDATE statement, at all. Can you post your update statement here.
>
>>I am appending an Excel spreadshhet into a General field in a local view. I get the following error when I save the row. "General fields cannot be used in the where clause of an update statement. Change the where type property of this view."
>>
>>Change it to???
>>
>>TIA
Bob Kocher
www.swfox.netStart making your plans now to attend Southwest Fox 2006