Heye Steve
here are the notes from the foxpro help

Note Calling TABLEUPDATE( ) for a local table or view that doesn’t use key fields generates a long WHERE clause to find the update row. The default number of fields supported in the WHERE clause is 40. If you receive the error 1812 - SQL: Statement Too Long, you should either use a key field for the update or increase the complexity of the WHERE clause with SYS(3055). If you use SYS(3055), increase its value to 8 times the number of fields in the table:


>I have been really frustrated by a grid class that I setup to allow editing of a local view. I am programmatically creating the view, setting the view and it's columns to updatable, running the custom grid class on a custom form class with recordsourcetype set to alias, then recordsource set to my cursorname.
>
>Here's the problem: I can run the code to create the view and all is well. I can open it manually, make changes and the changes are propagated to the original file.
>
>When I run the grid class, all appears to work, but no changes are made.
>
>I tested by creating a base-class grid on a form (no classes involved) and it updates the original file as well.
>
>There has to be a process error somewhere, but I can't seem to figure it out...
>
>any ideas would be greatly appreciated!