>I'm using VFP5.0a (build 415). I've got a view-based form that creates a parameter object using SCATTER...NAME and passes it to another (modal) form (which uses a private datasession).
>
>On returning from the modal form, I'd ideally like to issue GATHER...NAME to update the view form's fields with updated values from the parameter object. However, if I try, I get the above error.
>
>If I try to REPLACE just a few view fields from the parameter object, it works. If I try a REPLACE of all, or slightly more than half, same error.
>
>When the modal form is closed, the .Activate of the view form is eventually called, which refreshes the view form. The error handler is reporting the problem in a piece of code that works perfectly in every other circumstance and which contains no SELECT - SQL statements even approaching the limit.
Check the definition of the view, Update type - if it's Key and Updated fields, then it generates a SQL statement which includes all the changed fields in the Where clause, like " Where KeyField='oldkeyvalue' and Field2={old value of field2}and Field3={old value of field3} and ....", so the more fields you chenge, the longer itgets. Change it to Key Field Only.