Hi Denise,

If you are using VFP 6 then there is a new SYS(3055) function. The Programmer's Guide summary says: "Sets the complexity level of the FOR and WHERE clauses in commands and functions that support them".

Don't know if it's applicable here, but may be worth a look.

Good luck,

Jim N

>Perry,
>
>Thanks for the reminder. I checked Aerror() and it's saying "Query is too complex." But I'm not trying to do a query at that point. All I've done is changed the text in one field. I wonder if it's just too many fields -- but that just doesn't feel right. I mean, if I'm understanding the way the class is written, it just goes through each of the tables and if it finds one in which fields have changed it attempts to overwrite the old information with the new. So, since I've only changed one field, I'm not sure how that could be "too complex."
>
>But please don't think me ungrateful. I do appreciate you bringing that to my attention. Probably what's going to happen is when I get this thing licked I'm going to look back and wonder why I found it so troublesome :).
>
>>You might have missed it in the answers to your prior post. But the best way to analyze a Tableupdate() command to to look at the results using Aerror(). This will give you the reason for the failure.