I had this problem before and I couldn't find it in the archives. I am doing a select statement and I am getting an 1806 error "SQL: Column 'mycol' is not found. mycol is definitely in the table. You gave me an SQL clause that fixed this before but I can't find it. Something about using the drive instead of memory.
Anyone remember that or have the solution? It is not in the VFP help file. -- Jeff --------------- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ebbedc2.30...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.