>>So... this seems to be the limitation. One way would be to break this into two shorter (insert plus update, or two updates) statements, or as many as needed.
>
>You can also use stored procedure (especially if you're talking about SQL Server) and just pass all fields new values
There's no problem with SQL, the length of the command that can be passed through the ODBC driver was increased in the client for SQL 2005, so we're fine there - haven't run into any problems. It's when running against dbfs when using a cursoradapter (or a local view - the generated command is the same, I guess) that the generated command becomes too long for Fox to compile and execute. At least with a CA we can cook our own commands (and even with SPT on dbfs, though it's mostly not necessary).