Subject | Assigning IBOQuery, the SQL with Search criteria of an IB_Query, but limiting the IBOQuery to only contain bookmarked records in IB_Query for use in reporting tool. |
---|---|
Author | Adrian Wreyford |
Post date | 2008-02-02T18:35:58Z |
OK, let me explain my self.
Currently I enforce certain search criteria on an IB_Query.
I then Assign the SQL with search criteria to the IBOQuery, for use in
ReportBuilder report, with the following line of code:
IBOQuery1.AssignSQLWithSearch(IB_Query1);
This works like a bomb!
But I need the user to be able to further refine the search, by clicking on
the search resultset in a grid, and bookmarking a few records, and it is
these few records, that the IBOQuery1 should obtain, and not the entire
resultset of the search.
Var
sSelecte : Tstrings;
.
IB_Query1.Bookmark(sSelected)
sSelected contains the bookmarked records.
How can I limit IBOQuery1 to only these records in sSelected?
? Is there something like AssignSQLWithSearchBookmarked .. if you understand
what I'm getting at?
Thanks in advance
Adrian Wreyford
[Non-text portions of this message have been removed]
Currently I enforce certain search criteria on an IB_Query.
I then Assign the SQL with search criteria to the IBOQuery, for use in
ReportBuilder report, with the following line of code:
IBOQuery1.AssignSQLWithSearch(IB_Query1);
This works like a bomb!
But I need the user to be able to further refine the search, by clicking on
the search resultset in a grid, and bookmarking a few records, and it is
these few records, that the IBOQuery1 should obtain, and not the entire
resultset of the search.
Var
sSelecte : Tstrings;
.
IB_Query1.Bookmark(sSelected)
sSelected contains the bookmarked records.
How can I limit IBOQuery1 to only these records in sSelected?
? Is there something like AssignSQLWithSearchBookmarked .. if you understand
what I'm getting at?
Thanks in advance
Adrian Wreyford
[Non-text portions of this message have been removed]