>Thanks, everyone, for your input on this. I believe I finally discovered the problem. Through trial and error, I pinpointed the line of code that caused the C5. I had a query similar to this:
>

>SELECT * FROM TableA WHERE tableA.id IN (SELECT id FROM TableB)
>

>The query usually worked fine and returned the desired results, but it apparently corrupts some memory. After running this SQL multiple times (in my testing, as few as 2 times and as many as 290 times) eventually a subsequent command causes a C5 and sometimes a VFP error, Error # 43-There is not enough memory to complete this operation. Most times (but not always), the vfp8err.log is updated and references the object, method and line number of the code that was executing - but that really wasn't all that helpful (in fact, misleading) because it only referenced the subsequent command and not SQL that caused the problem.
>
>When I commented out the above SQL, the C5 disappeared.


Did you just re-type the line or modify your command?

I am curious if this type of select statement was causing your C5 or if there was some type of corruption in your form or class itself.

I am battling a similar problem with a single client having a problem with a line of code that 'seems to be fine'.