How do I create a query then use data bound controls on the query 
Author Message
 How do I create a query then use data bound controls on the query

I want to projece a query to extract certain records from a table, then I
want to use the data bound controls on the query projuced.

How can I do this from within VB4, The database is in dbase format.

Thanks
  Brian.



Sat, 19 Aug 2000 03:00:00 GMT  
 How do I create a query then use data bound controls on the query
@cts.com
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: CTS Network Services
Newsgroups: comp.lang.basic.visual.database

Use the query as the data control's recordsource:

data1.recordsource="SELECT * FROM mytable..."

When you refresh the data control, the recordset will be composed of the
selected records.

Chris

Quote:

>I want to projece a query to extract certain records from a table, then I
>want to use the data bound controls on the query projuced.

>How can I do this from within VB4, The database is in dbase format.

>Thanks
>  Brian.



Sat, 19 Aug 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Parameter query for Bound Data Control

2. How to bind Parameter Query to Data Control ?

3. How to bind Parameter Query to Data Control ?

4. SQL queries with data bound controls

5. Controls bound to a Data Environment Parameter query

6. Bound Controls Using Parameter Query

7. How: Query using VB Data Control?

8. Using queries with Data control HELP!!!!

9. Using Parameter Queries and Data Controls

10. Using a parameter Query with VB data control?

11. How to create a data bound control that binds to a row

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

 

 
Powered by phpBB® Forum Software