Data Control and parameter query 
Author Message
 Data Control and parameter query

I use a database with a QueryDef stored in it containing a parameter
query. How can I manage to set the RecordSource property of a Data
Control to that QueryDef and supply the required parameters to the query.
Without parameters no problem...
I would be very grateful for a nice tip.
Wilfried


Fri, 22 Aug 1997 18:08:35 GMT  
 Data Control and parameter query

Quote:

>I use a database with a QueryDef stored in it containing a parameter
>query. How can I manage to set the RecordSource property of a Data
>Control to that QueryDef and supply the required parameters to the query.
>Without parameters no problem...
>I would be very grateful for a nice tip.
>Wilfried

You cannot use a parameter query with a data control recordset property.
You can only use a paramater query if you create the dynaset in VB code.

The only thing you can do is build the SQL select statement and set it in the recordset
properity. I had this issue with a few tables in my database. The paramater query
ran fine, but the SQL ran slow. I had to de-normalize the tables for the
query to be acceptable. Sloppy but it worked.

BTW, if anyone knows how to get around this problem, feel free to jump in.

Sorry,
Scott.



Mon, 25 Aug 1997 07:27:15 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Passing Parameters to stored parameter queries using VB 5's Data Controls

2. Parameter query for Bound Data Control

3. VB4: Parameter query&Data Control?

4. HELP with Parameter queries and Data Control

5. Parameter Queries and Data Controls

6. Using Parameter Queries and Data Controls

7. Parameter Queries and Data controls

8. Help! Parameter Query via Data Control

9. Data Control and Query Parameters Question

10. Parameter Queries in a VB data control

11. How to bind Parameter Query to Data Control ?

12. Executing Access queries with Data Control and parameter passing

 

 
Powered by phpBB® Forum Software