On Jan 17, 2007, at 8:20 PM, Tom Benson wrote:
Which database are you using??
It sounds counterintuitive, but you could try replacing the OR
operand with AND, so that you're selecting records with TestNm =
myTest AND records with TestNm = altTest.
- Tom
Thanks for your prompt reply, Tom.
Actually, further debugging revealed that I had set a var elsewhere
in the code which forced the count to be displayed incorrectly. The
syntax:
rs = App.QMPdata.SQLSelect("SELECT * FROM TakeData WHERE TestNm = '"
+ myTest + "' OR TestNm = '" + altTest + "'")
IS working as expected.
Roger M. Clary
Class One Software
http://www.classonesoftware.com
[EMAIL PROTECTED]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
