I am having an requirement, to show the data on Xpages, and the data will be fetched from Oracle Database. For that I have written an agent in Lotus Script, it's working fine.Now my problem is I have to show 3 fields in Xpages, field no 1 user can Input some data like part no after putting the part no the data should automatically come to Field 2, and Field3.Please help me how should gather this.I am totally new to xpage.
Some of my lines in agent
qry.SQL = "select * from od2 where Part_NO='4000000710(here I will pass the input field name)'"
If result.IsResultSetAvailable Then
msg = "Contracts:" & Chr(10)
Quantity = result.GetValue("Quantity", _
Contract = result.GetValue("Contract", _
Part_no = result.GetValue("Part_no", _
Loop Until result.IsEndOfData