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
On 18/01/2007, at 11:56 AM, Roger Clary wrote:
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>
_______________________________________________
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>
