I want to apply to my GLEntry recordset a filter to "G/L Account No." field.
I have a string variable in wich value can is: '2110', or '2110..2220' or '2220|7130' and so on..
This is the code:
GLEntry.SETRANGE("G/L Account No.",myVariableString);
but no results
How I do it?
0
Comments
GLEntry.SetRange("G/L Account No.",'2110');
GLEntry.SetRange("G/L Account No.",'2110','2220');
However, boolean logic (such as the or pipe, |) can't be used in SetRange. Instead, use SETFILTER for the third one:
GLEntry.SetFilter("G/L Account No.",'2220|7130');
Tim Larson
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.