>I believe I've had this problem, or a similar one, before and resolved it. Now I cannot recall what to do. It is not actually having to do with the length of the SQL, but rather something to do, I think, with corruption of the view. I have reviewed the GenDBC output code for the database and do not see anything out of order. It only occurs after I have tried to create a new record in a particular view. After that I am unable to Close All, Clear All or Quit Foxpro due to this error. Any help understanding this would be greatly appreciated. Thanks!
>
>Regards, Renoir

I am also able to remove the error, then Close All, if I issue TableRevert() on the view from the command window. Seems like it doesn't like the data in the appended record, but I'm surprised I'm not getting the "Uncommitted" error instead if that's the case. Still don't know what's causing it...

Renoir