Also you might try selecting all of the fields into a cursor with a * and seeing how the results are displayed for the field.
Rick Q quilh...@gmail.com On Thu, Nov 10, 2011 at 10:29 AM, Jeff Johnson <j...@san-dc.com> wrote: > 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 > > [excessive quoting removed by server] _______________________________________________ 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/cadazp2nnjion7k7nkf_cnr+kjgfhxvvpm0b5kafy8osubak...@mail.gmail.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.