i have written a query to fetch specific information from database table, the query is:
results= system.db.runPrepQuery("SELECT BAY_NO FROM rellocation_logic WHERE PRODUCT =? and CURRENT_TRUCK_COUNT < MAX_TRUCK COUNT ", [ProdName])
now the query will return number of rows…
Currently i am moving the result of a query in temporary table component and reading the data one by one by using tables getValueAt function
how to read the data from each row and write it to the tag with out moving it into table component .
( i am writing this script in script library [project] )