List - I am trying to select from table TakeData from field TestNm a
recordset where the values match EITHER 'myTest' or 'altTest'
I have checked to make sure both myTest and altTest contain valid
values, but the command below is finding only myTest matches.
I probably don't have valid syntax, if I'm even allowed to do such a
SELECT at all.
Help much appreciated.
Dim rs AS recordset
rs = App.QMPdata.SQLSelect("SELECT * FROM TakeData WHERE TestNm = '"
+ myTest + "' OR TestNm = '" + altTest + "'")
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>