List problem
Thanks Paul
Problem is solved but I will certainly look into your code.
Might learn something.
Regards
Bo
På 4 februari 2018 kl. 04:50:51, Paul Mulroney (pmulroney@logicaldevelopments.com.au) skrev:
Hi Bo,
I wrote a routine called “ListIntersect”, which I’ve posted on GitHub.
We originally wrote it in Omnis Studio 3, but it’s up on GitHub in
Studio 8 format.
Basically you use it like this:
Do voListInterection.$ListIntersect(plList1,plList2,psFieldname,psFieldtype)
IN:
* plList1 – the larger of the two lists to process. It can have
duplicate values in the column that you’re testing
* plList2 – the smaller of the two lists.
* psFieldname – the column name in the list that you’re comparing again
* psFieldtype – options are Char, Int, Num or Date.
OUT: All lines in list1 that exist in list2 will be selected in list1.
NOTE
Both lists will be sorted by the nominated field name.
The comparison column must be the same name/type in both lists.
You can download the code here:
github.com/pmulroney/ListIntersect_for_Studio5
Regards,
Paul.
> Message: 19
> Date: Sat, 3 Feb 2018 14:27:26 +0100
> From: Bo Carle? <bo@corbisoft.com>
> To: OmnisDev List – English <omnisdev-en@lists.omnis-dev.com>
> Subject: List problem
> Message-ID: <etPan.5a75b8be.30116908.3a7@corbisoft.com>
> Content-Type: text/plain; charset=”utf-8″
>
> Hi
>
> I have 2 lists. List 1 with 1226 lines. List 2 with 9663 lines.
> All lines from list 1 are also included in list 2.
> What I want to do is to clear list 2 from all list 1 lines.
>
> Anyone who has a solution for this task?
>
> TIA
> Bo
—
(sent from the webmail of)
Paul W. Mulroney Logical Developments
pmulroney@logicaldevelopments.com.au 86 Coolgardie Street
www.logicaldevelopments.com.au BENTLEY WA 6102
Ph: +61 8 9458 3889 Fax: +61 8 9458 2169
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com