Subject Re: [IBO] Using bookmarks with IB_Query1, to select, then only dispaly selected resultset in IB_Query2?
Author Andreas Pohl
Hello Adrian Wreyford,

> What I now need to do is to create IB_Query2, that is equivalent to only the
> bookmarked records in IB_Query1

you can retrieve all primary keys from
query1.SelectedBookmarks-StringList and store it in a separate
stringlist ("transforming" bookmark value into pk value). Then copy
query1.sql.text to query2.sql.text and add a in()-clause to query2:


query2.sql.text:=query1.sql.txt;
query2.SQLWhere.Add(format(' and %s in(%s)
',[pkfieldname,pkstringlist.commatext]));

--
Andreas