>I have a table (not free table) with 33 fields, lenght of record is 411 and aprox. 40,000 records.
>I made a local view for a certain filter (Table.data = ?varData .AND. Deleted() = .F.), SQL WHERE=Key and Updatable Fields, Send Update = .T., all fields marked as updatable, no. of records filtered is about 100.
>My computer: 486DX/120MHz, 16Mb RAM, 850Mb HDD, Windows 95.
>Problem is: when I replace value for a field (inside an application) and I move from the record (to send the updates to parent table) I receive the error 1812 and I can do nothing from here (not even close the view).
>I mention that I use the database shared (in multiuser environment).
>What can I do about it? There are some setings to solve this problem, or the view is too big.
>Thanks,
>Laurentiu

I encountered the same problem and was unable to get the view to update with that many fields. What I ended up doing was changing the view to non-updatable and doing the update manually, using UPDATE-SQL. I wrote a loop which would issue an update on the first 10 fields, then the next 10, and so on until done. This avoided the "SQL Statement too long" error. Kind of a pain, but it worked.

Mark Peter