>I don't give them temp names. I give them regular table names. I don't want to have to put the path in because I want to avoid doing SELECT..INTO (tablepathandname). Then I always have to refer to it with the ().
>
>Thanks,
>
>-Michelle

Yea... life as a programmer is tough isn't it...

OK... how about if you put an entry for any temp file names that you use into your global header file to shorten your typing...

#DEFINE WorkPath home()+'work\'

#DEFINE ThisTable (WorkPath+'ThisTable')
#DEFINE ThatTable (WorkPath+'ThatTable')

????????????????

Now you can do...

SELECT INTO ThisTable

BTW: You could make your temp tables cursors... FoxPro would take care of swapping to disk if need be... based on your tempdir setting of course.

Lots of options, that is the nice thing about VFP.

BOb