Bob, I do not know MM but VFP has an UPDATE - SQL statement which is what I believe the error message is referring to. Can you post your UPDATE statement here?


>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