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>

Reply via email to