RDO -> Access97 -> Qry w/ Parameters HOW? 
Author Message
 RDO -> Access97 -> Qry w/ Parameters HOW?

Can anybody help out with the following:

I wish to open an Access97 Query that has 2 parameters

ex:
    Select * from XXX where f1=[Param1], f2=[Param2];

using RDO.  However, RDO recognizes the Access queries as Tables (in the
rdoTables collection).  The tables collection does not support
rdoParameters...

When I try to open the query through the rdoTable object i get an odbc error
from Access (07001) saying that 2 parameters were expected, 0 were supplied.

Does anybody know how i can accomplish this using RDO?  Thanks

Regards,
Steve



Sun, 15 Oct 2000 03:00:00 GMT  
 RDO -> Access97 -> Qry w/ Parameters HOW?

The ODBC driver for ACCESS does not support rdoParameters!
You should use DAO with and Access MDB file!

If you use RDO you will find that performance is slow and some features
DON'T WORK!

SimonJ
PC Pro Magazine



Sun, 15 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. RDO -> Access97 -> Qry w/ Parameters HOW?

2. using The Shell Command >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

3. <<<<<<<<ComboBox>>>>>>>>>>>>

4. >>>>>>While Not rst.EOF

5. PSUDOCODE HELP >>>>>>>>>>>

6. >>>Feed Access Parameter From A Batch File

7. >>>>> Serial Communications

8. VB5 >>>>> Academic Version

9. <<<<HELP- OLE container Control>>>>>>>>>

10. !!! URGENT HELP REQUIRED !!!>>>>>>>>

11. rdo-->ODBC-->SQL6.0 (Errors on Addnew, Update)

12. >>= bitwise operations >>

 

 
Powered by phpBB® Forum Software