Since no one responded to this question the first time I posted it, does
anyone know to whom I might send it and get some information?
I am using Windows XP and RB2005.
This is a simple query shown here using SQLPLUS:
rlwq> select val2 from pdldetail where val2 like '%116%';
VAL2
-------------------------------------------------------------------
MH 1166
CLF-116-M2-1 Inlet flow meter needs calibration Rm 116
FDR_116_BELT3 needs adjustment
CO2_116_V5 needs adjustment
FDR_116_M3_2 connection loose; check wire Rm 116
broken door lock Rm 116
6 rows selected.
When I do the identical query from RB2005 using:
dbqMaint.sqlquery = "select val2 from pdldetail where val2 like '%116%'"
dbqMaint.runQuery
it finds NO data.
If I change the query to:
dbqMaint.sqlquery = "select val2 from pdldetail where val2 like '%Rm 116%'"
then it returns the 3 rows that contain Rm 116 exactly as it should.
If I change the query to locate data that starts with any number except 1,
then it returns the data perfectly. If I change the query to read:
dbqMaint.sqlquery = "select val2 from pdldetail where val2 like '%1%'"
then it returns every row in the entire table, whether or not it has a 1 in it.
Can anyone tell me how to get around this? It has always worked fine in VB
6, but I am trying to transfer user programs to RB2005.
Thanks a lot!
Ruth Watkins
_______________________________________________
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>
|