SETRANGE use

maschenada · 2009-10-08

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?

tlarson · 2009-10-08

SetRange can only be used for the first two instances. You can use the function like this:

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

kine · 2009-10-08

Look at SETFILTER instead SETRANGE...

SETRANGE use

Comments

Categories