There are 4 fields(ID, FName,LName and Address). Entering ID in text1 and clicki

There are 4 fields(ID, FName,LName and Address). Entering ID in text1 and clicking on button/image, FName, LName and Address should be displayed for the entered ID. Data should retrieve from database. Does any one know. Thanks in advance.

OriginalPostID-149372

OriginalPostID-149372

  Discussion posts and replies are publicly visible

Parents
  • You can use a!save() on the saveinto for the button, example: a!save(ri!FName, index(rule!getPersonInformation(ri!id),"FName","")). Its not necessarily best practice to perform a query on the saveinto however as it will reevaluate every time you click. You can also load the person table before the form and then on the saveinto just pull the specific row out using index() and wherecontains(). It depends on your implementation.
Reply
  • You can use a!save() on the saveinto for the button, example: a!save(ri!FName, index(rule!getPersonInformation(ri!id),"FName","")). Its not necessarily best practice to perform a query on the saveinto however as it will reevaluate every time you click. You can also load the person table before the form and then on the saveinto just pull the specific row out using index() and wherecontains(). It depends on your implementation.
Children
No Data