On Jan 17, 2007, at 9:28 PM, Craig A. Finseth wrote:
Dim rs AS recordset
rs = App.QMPdata.SQLSelect("SELECT * FROM TakeData WHERE TestNm
= '"
+ myTest + "' OR TestNm = '" + altTest + "'")
Try:
rs = App.QMPdata.SQLSelect("SELECT * FROM TakeData WHERE (TestNm
= '"
+ myTest + "' OR TestNm = '" + altTest + "');")
Note the extra parentheses.
Also, for anything other than quick interactive playing with SQL,
never do "Select *". Instead, do:
Select ( column1, column2, ... ) ...
as "Select *" results will change if you ever modify the table
structure.
Thanks, Craig. I didn't know this.
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>
