I have a record set variable which contains a particular one type of records.I would like to filter it our further under query editor and display its results in "Main query window". Under query editor if you give the record set variable as source for the query we face "Run time error 6, overflow", Any help from fellow users?
We can filter the record set by another filter record set variable.But how to display the filtered record set in the main window?
Why I want to display the results in query main window is that we can build a tool set to process these record set further.
Thank you Don.
In the query folder you can save only certain type of query.That too only a paticular query.I feel similar to query folder a variable recordset folder will be good.
In my requirements I need to display various sets of recordsets frequently.
I was playing around with this concept, and I think a roundabout way to do this is to create a folder named "First Query Results". In the query editor under actions for the First Query, check "execute a script one time after the query is complete" and execute a script to clone recent query results and then move selected records to the First Query Results folder. You can then use that folder as the source for further queries (on the First Query results). You could get really fancy and continue this process with multiple folders and queries.
I may be off target here but is it not possible just to run secondary query based on original criteria plus new criteria. Original search term stored in global or static after user input dialog, then run first query. May be have a flag check field to mark records needed for further processing and run second query with same term ( global var) plus 1 in marked flag field? This is just one possible idea but would seem to be quite flexible. End result is always a displayable record set. Thinking as per car sample - find all blue cars for customer then tick off cars for shortlisting and run secondary query (with the 2 criteria) to print out units of interest. Copying records to folders is possible but I worry about writing and deleting records within database over long period with this method.
Just my thoughts