Re: SQL Column not found

2011-11-10 Thread Jeff Johnson
Works fine! I can ditch the order. Thanks, Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 11/10/2011 09:00 AM, Richard Quilhot wrote: > Remove the order by clause and see what names are assigned to the columns. > > Rick Q > quilh...@gmail.com > > > > > On

Re: SQL Column not found

2011-11-10 Thread Richard Quilhot
Remove the order by clause and see what names are assigned to the columns. Rick Q quilh...@gmail.com On Thu, Nov 10, 2011 at 10:44 AM, Jeff Johnson wrote: > SELECT * from caml_dctemp into table ADDBS(SYS(2023)) + 'dctemp.dbf' > order by wkname, wkdriver, DTOS(CTOD(wkdate)), wktripno, STR(wks

Re: SQL Column not found

2011-11-10 Thread Jeff Johnson
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

RE: SQL Column not found

2011-11-10 Thread Lou Syracuse
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...@lea

Re: SQL Column not found

2011-11-10 Thread Richard Quilhot
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 wrote: > I had this problem before and I couldn't find it in the archives. I am > doing a se