Hello,
is it possible to change the forum where I posted a previous message if I inserted it in a not correct place in Mibuso forums?
I have to scroll Reservation Entry table recursively with a lot of
conditions of filter.
this is a function called more times
T337.setrange(....);
T337.setrange(....);
T337.setrange(....);
T337.setrange(....);
T337.setfilter('Entry No.','<>%1',prev.'Entry No.');
now I have a case where the loop is infinite and Navision client closes.
I understand that last filter condition is not enough because if there are
more records with identical previous conditions I can return on previous one
so I have to substitute it in a manner similar to this
declare a variable where I insert all previous Entry No. already scrolled
and then use a new filter similar to following
T337.setrange(....);
T337.setrange(....);
T337.setrange(....);
T337.setrange(....);
T337.setfilter('Entry No.','NOT IN [%1]',prev.myVar);
The problem is that myVar should be of types text to concatenate previous
Entry No separated by commas [,] but after it doesn't go right because 'Entry
No.' of setfilter is of type Integer.
What do you suggest?
Thank you very much
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
rec.SETFILTER("fieldName",'NOT IN [%1]',varRange);
where varRange is a variable of type Text with more not determined values for varRange
for example varRange='12345,6789,8908,....' where the single values are
12345
6789
8908
they are a string created dinamically.
but "fieldName" is of type Integer
Thank you
Setfilter("Entry No.", '<>12345&<>6789&<>8908');
http://www.BiloBeauty.com
http://www.autismspeaks.org
The string of values is populated dinamically at run time.
There can be an only one value or 100.
Do you understand?
Thank you
into some text string? value1,value2,etc?
http://www.BiloBeauty.com
http://www.autismspeaks.org
But I'm only guessing. Because like the others; I don't exactly understand your problem.
Tino Ruijs
Microsoft Dynamics NAV specialist
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I will have to try.
Thank you