I am using MS Access to access a Pervasive P.SQL 2000i SP4 database. If I use linked tables to access the P.SQL data in Access I can have parameters in the query like:
Select * from Parts where Part_ID = [Enter Part]
When I run the Query I will get prompted for the [Enter Part] variable. I can also use QueryDefs in my VB code to pass the parameters. Can Pervasive P.SQL prompt for parameters or accept them?
Select * from Parts where Part_ID = [Enter Part]
When I run the Query I will get prompted for the [Enter Part] variable. I can also use QueryDefs in my VB code to pass the parameters. Can Pervasive P.SQL prompt for parameters or accept them?