Pull data from a dataset and data table with OLEDB

[TonyScarpelli]

I'm pulling data from three free FoxPro tables using OLEDB. They are all related by the Reqnum field.

The first run is just to see if there are records that can be used. I'm just looking for open requistions so this is the fastest way to see if there are any.

Now that I have the limited number of records in a dataview, I want to pull all the related records from the two other tables.

Can I pull the records from the other two tables just using the the dataview records?

Thanks.




Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[SqueakinSweep]

Put simply...No.

I can only assume you're having speed issues in asking if you can use your first dataview.

I think you may be confusing dataview with Foxpro views, which you can use as a filtered dataset to perform other queries, much as you can by using SQL Views too. ADO.Net Datasets are by their very intended nature disconnected recordsets.


Sweep
...if it works dont mess with it