View Single Post
Old 10th February 2017, 10:42
pralash pralash is offline
Senior Member
Join Date: Feb 2017
Posts: 217
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Basic Report in ERP Ln

A new blog entry has been added:

Basic Report in ERP Ln


I'm freher to ERP Ln... I am create a Report and also execut it successfully.
But i can't get the clear idea of the following codes in the programming script. 

|****************************** declaration section ***************************

  table   ttfedu710 | testing table 3 employee

   extern  domain  tfedu.inte       emid.f
   extern  domain  tfedu.inte       emid.t 
 |****************************** field section *********************************
   emid.t = emid.f

function read.main.table()
    select tfedu710.*
    from tfedu710
    where   tfedu710._index1 inrange {:emid.f}
                                    and {:emid.t} 
    order by tfedu710._index1

While i execute the sesion, i'm getting two text box for getting initial and last employee id....
But in the previous script, the value of emid.f is assigned to emid.t....
So how can i get the report from 1 to 5 (if i give 1 and 5 are the first and last value)...
 Anybody please guide me....

Reply With Quote