Well - as they say - there's "More than one way to Skin a Cat!" (But - who the HELL ever came up with that Phrase - and did some Dude actually sit around trying to figure out how many ways to do it? If so - he's gotta be one Sick Bastard!) Ah, but, I digress...
I got it working - based upon just implementing the creation of that Grp_Vndr field within the 1st SELECT - and doing the IIF() in that Select to put in the proper data for the field. So - now it works - and I can finally move on with my life! -K- -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, September 21, 2011 5:45 PM To: profoxt...@leafe.com Subject: RE: COLUMN Not Found... Actually - when I initially had the problem - I did NOT use the Cursor name prefixes. But, after the problem 1st occurred - I stuck them in - hoping it would help. However, I guessed wrong... Anyway - I may try another was of solving the problem - so that I don't even have to use the SCAN loop OR the 2nd SELECT. Going to try to create that Var. properly in the 1st SELECT - and then ORDER BY it in THAT select! -K- -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Quilhot Sent: Wednesday, September 21, 2011 5:25 PM To: profoxt...@leafe.com Subject: Re: COLUMN Not Found... Try the second query with use "Temp_Cut" not "Temp_Cut1" in the order by clause, or just use the column names without the prefix. Rick Q On Wed, Sep 21, 2011 at 4:55 PM, Kurt Wendt <kurtwe...@waitex.com> wrote: > OK - I am getting this error - and it just does NOT seem to make sense. > This is the Clip of code: > > SELECT *, Vendor1 as Grp_Vndr FROM Cuttkt ; > > WHERE &XFILTER ; > > INTO CURSOR Temp_Cut1 READWRITE > > SCAN > > REPLACE Grp_Vndr WITH > IIF(Ct_stage="2",Vendor2,IIF(Ct_stage="3",Vendor3,Vendor1)) > > ENDSCAN > > SELECT * FROM Temp_Cut1 ; > > ORDER BY Temp_Cut1.Ct_stage, Temp_Cut1.Grp_Vndr, ; > > DTOS(Temp_Cut1.Complete), Temp_Cut1.Ticket ; > > INTO CURSOR Temp_Cut READWRITE > > > > The 1st Select works. And, the Scan/Replace works. It's the 2nd Select > that fails. The error is: > > SQL: Column "Grp_Vndr" is not found. > > > > It does NOT make sense that its not found - since I created the field in > the 1st Select - and I was even able to do all the Replaces in the SCAN > loop without a problem! > > > > So - what gives? Can anyone gimme a clue??? > > Thanks, > > -K- _______________________________________________ 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/289ea162f5642645b5cf64d624c66a140b7ce...@us-ny-mail-002.waitex.net ** 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.
