Here is another problem. I am wondering if there is a bug. I am
selecting database records with two conditions (e.g. Year = 2003 and
Term = Fall). The year part works fine (its a string). If I hardcode
in 'Fall' it works fine. But if choose it from the pop menu in the
same way, it gives everything for that year (SUMMER, FALL, SPRING). I
have msgbox'ed the exact search and it appears correct. It seems that
if it didn't recognize the term from the pop menu for any reason,
then it would not return anything - rather than return everything. Is
this a bug or am I missing something?
-------- The following gives the year correctly but gives ALL values
of term -------
"select * from AllClasses where year = " + popMyear.text + " AND
term = " + popMterm.text
-------- The following works
-----------------------------------------------------
"select * from AllClasses where year = " + popMyear.text + " AND
term = 'Fall' "
---------------------------------------------------------------------------------
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|