<i><font color="#663300"><i><font color="#663300">HI ALL,
Bonjour à tous(tes),
I place in the list of left of the elements selectionnables.
SELECT DISTINCT Teleph.cnomteleph, Teleph.iid;
FROM amline!resident INNER JOIN amline!Teleph ;
ON resident.itelephoneid = Teleph.iid;
WHERE EMPTY( resident.dsortie );
ORDER BY Teleph.cnomteleph INTO ARRAY taFullList
I place in the list of right-hand side of the préselectionnés elements.
SELECT Teleph.cnomteleph, Teleph.iid FROM Teleph WHERE ;
teleph.iid IN ( SELECT itelephoneid FROM cfiltre WHERE lactif = .t. AND ireport = goapp.noreport );
INTO ARRAY taSelectedList
How to return the items of left gray color to announce that they are
already on the right?
Thanks
</font></i>
Salut Bernhart,
You need to make a UNION to build taFullList
SELECT ALL records that are not already selected in taSelectedList ;
UNION;
SELECT "<" + Teleph.cnomteleph AS cNomTeleph, Teleph.iid FROM Teleph WHERE ;
teleph.iid IN ( SELECT itelephoneid FROM cfiltre WHERE lactif = .t. AND ireport = goapp.noreport );
INTO ARRAY taSelectedList
Beware, this is pseudo code only, you'll have to match the length of the two cNomTeleph fields.
Jose</font></i>
Sorry for the typing mistake, please read SELECT "" + ...
José
Jose Constant
Constant Software Systems
Belgium
<a href=http://www.constant.be/css target=_blank>Jose's Web Site</a>
©2001 Jose Constant |
