Hello all,

I have a little reindex routine which bascially does the following

scan through all dbf files in a folder 
deletes the .CDX file
A)select * from "Original" into Table temptable 
B)recreates the CDX on temptable
C)Copy To "Original" With Cdx Type Fox2x
D)Use In Select("temptable")
endscan

This is the log file produced when one of my users ran this routine.

B)Index on P_EAN_CD tag P_EAN_CD : There is not enough memory to complete this operation.
B)Index on EXT_WK tag EXT_WK : There is not enough memory to complete this operation.
C)There is not enough memory to complete this operation.:       183
D)Cannot close table during execution of table-bound expression.:       186
A)Cannot close table during execution of table-bound expression.:        93
B)Index on RC_EAN_CD tag RC_EAN_CD : Variable 'RC_EAN_CD' is not found.
B)Index on STR(P_EAN_CD,16)+STR(RC_EAN_CD,13)+STR(EXT_WK,6) tag PR_RC_WK : Variable 'RC_EAN_CD' is not found.
D)Cannot close table during execution of table-bound expression.:       186

I have letterd each section to try and show where each error is generated.

The end result of all this is that the temptable was not closed, the 2nd iteration of the select statement did not close the temptable either then it copied the 1st table over the top of the 2nd table.
4 months later the user decided to show me this error log and is asking where his data is :)

What is a table-bound expression? and why can I not close a table or select into a table which is in one?

Thanks for any assistance

BTW all running on VFP7 sp1 in a standalone .EXE