selecting records from already running dataset

[trainee]

I need help,
I'm building a'n application in c++, in one form the program executes one gigantic query (9 pages) to show data from employees. This already takes to much time, I have the names from the employees in a treeview (the names i also getr from the same query). When i click on a person in the treeview i want to see the data in the detail view bu then i have tot execute the query all over again, is there any way to search records in a running dataset. please help!

------------------
dude

 

[Marco Kalter]

If the query is running in a background thread, then you cannot search records in another thread. Is this the case?

Maybe you can modify your application and initially query just the information that is visible in the TreeView? When a user expands a node of the TreeView, you can subsequently fetch the additional information.

------------------
Marco Kalter
Allround Automations