hello , im new from Infor LN 10
i want to ask about debuging my report programs , so what comand should i enter for know the value for example
i have query


select * from whinr100
where whinr100._index1={:tdsls400.orno}
selectdo
qty.v=tdsls400.qty
endselect


and i want to know on debugger the value of qty.v


and 2nd i want to know about query 2 table with 1 indexing data
for example i have 2 table
tsls400 and whinr100

and i want to search by indexing on primary table whinr100.orno

what query can i use ?

thank you

Hi,

There are couple of ways to know the value of a variable in Debug mode.

1. Click on the variable name once the line is executed/stepped and you will get the value
2. Type in the debugger, the name of variable and press enter. It will show you the value

Also, in case if you want to trace the value of a variable, once the session goes into debugger, type t variable_name and press enter and continue. Now, every time the variable gets a value, it will be displayed by the debugger.

About joining the table whinr100 and tdsls400, there is no Order No index available for whinr100 hence, you might not be able to join the two tables. If you put your exact requirement, someone might provide you with a way around.

What you can do is(assuming you have a variable called hold.orno with the order Number which you require)


select whinr100.*,tdsls400.*
from whinr100,tdsls400
where whinr100.orno= :hold.orno
and tdsls400._index1 = {:hold.orno}
selectdo
qty.v=tdsls400.qty
endselect


This is the way to select records of two Tables in one query. But you need to have the "Örder Number" with you.