Visual LANSA Forum

It is a windows Front-end with a grid on it.

Good day

I have a grid in my front end but I have a subfile in the 5250 screen. The subfile has maximum on 14 entries per page and i can only have 7 pages. I can set the subfile and get the entries on the first page up until the 14th entry. But if I need to page down and hit enter I get a multiple ...

I will try creating a function and running the call server function BIF. Thanks for your suggestions, they help!!

In normal sql i want to :
Select (Fields) from tableA, tableB Where tableA.id = tableB.id


This is what I found on this
SELECT_SQL FIELDS((#EMPNO PSLMST.EMPNO) #SKILCODE #DATEACQR) FROM_FILES((PSLMST)(PSLSKL)) WHERE('PSLMST.EMPNO=PSLSKL.EMPNO AND SKILCODE=''4GL''') ORDER_BY(DATEACQR);

But with ...

Hi,

Can anyone help me with accessing multiple files data on the AS400? I have tried the select_sql method but I do not have local data as all my data is in the 400. I can fetch data on one file, but I cannot fetch data on multiple files. Your assistance will be highly appreciated.