SELECT * from caml_dctemp into table ADDBS(SYS(2023)) + 'dctemp.dbf' order by wkname, wkdriver, DTOS(CTOD(wkdate)), wktripno, STR(wkseq, 6, 0)
It is telling me wkdriver is not in the table when in fact it is. VFP7 XP Jeff --------------- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 11/10/2011 08:35 AM, Lou Syracuse wrote: > Can you post the SQL? :) > > Did you use the Designer? If I recall correctly there was something it did > with the order of the Join and ON clauses that caused problems - maybe that > was the issue... > > Lou > > -----Original Message----- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On > Behalf Of Jeff Johnson > Sent: Thursday, November 10, 2011 7:29 AM > To: profoxt...@leafe.com > Subject: SQL Column not found > > 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. > _______________________________________________ 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/4ebbf176.80...@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.
