Set Range on G/L Account Code Field

nileshr18 · 2008-09-02

I want to filter the record using setrange on No. field in G/L account table
and display the filtered record for example I want to dispaly the No. from
563. to 563.0002,I want to apply the filter on No field of G/L Account table ?

Sandeep_Prajapati · 2008-09-02

I am sure you know how to use SetRange. Can you elaborate a bit please. O:)

pranav-joshi · 2008-09-06

use following code:

GLAcc.SETRANGE("No.",563,563.002);

or u can also take help from c/side reference guide.

Pranav
Intech Systems Pvt. Ltd.

Alex_Chow · 2008-09-07

Becareful! Character counts!

563 is different than 563.000. :!:

kine · 2008-09-07

It means you need something like:

GLAcc.SETRANGE("No.",'563.000','563.002');

ssingla · 2008-09-08

Alex Chow wrote:

Becareful! Character counts!

563 is different than 563.000. :!:

That is something which one should avoid i.e having different number of characters in the G/L Account code. Place 0 to make them uniform.

Alex_Chow · 2008-09-08

kine wrote:
It means you need something like:
GLAcc.SETRANGE("No.",'563.000','563.002'); 

Thanks for the clarification.

I keep assuming people know.

Set Range on G/L Account Code Field

Comments

Categories