Subject | Re: [IBO] Using bookmarks with IB_Query1, to select, then only dispaly selected resultset in IB_Query2? |
---|---|
Author | Andreas Pohl |
Post date | 2005-08-07T20:46:18Z |
Hello Adrian Wreyford,
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
> What I now need to do is to create IB_Query2, that is equivalent to only theyou can retrieve all primary keys from
> bookmarked records in IB_Query1
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