Vince Teachout wrote: > Howdy. In vfp9, I run the following query, which is wrong, because I > don't have field 'GMPARENT' in Slsxref: > > SELECT Distinct Bill_to_no, Slsperid, Regionvp, GMParent, Division_no ; > FROM Sales ; > WHERE (Bill_to_no+Slsperid+Regionvp+GMParent+Division_no) NOT IN ; > (SELECT Bill_to_no+Slsperid+Regionvp+GMParent+Division_no FROM > SlsxRef) > > I "tested" it several times in command prompt without catching the > error, and always got a result set back. (I don't know if the result was > correct, or not) > It never once complained. I then ran the form which contained the > query, and when it hit the query, it choked with a COLUMN NOT FOUND > error. Took me a few tries to spot the error (long, LONG, day). > > Obviously I've fixed it, and am going on, but does anyone know why it > would NOT throw the error in command line mode?
Was there a memvar defined named GMParent, or did the currently selected table have a field named GMParent? -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] 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/[EMAIL PROTECTED] ** 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.
