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?
_______________________________________________
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.
