Re: SQL Column not found

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

Re: SQL Column not found

2011-11-10 Thread Richard Quilhot
ginal 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 prob

Re: SQL Column not found

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

RE: SQL Column not found

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

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

SQL Column not found

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