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

anilkumark over 9 years ago

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.

Discussion posts and replies are publicly visible

0 sikhivahans over 9 years ago

If you are making use of SAIL, please refer the following link:
forum.appian.com/.../SAIL_Recipes.html

In order to query data from database, please refer the following link:
forum.appian.com/.../Querying_Data_From_an_RDBMS.html

Going through the links specified above will give you an high level idea.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jakeg over 9 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel