Overview
The purpose of this lesson is explain the Actions in Wayfast. This “Actions” are events that allow us to interact with our Project DB. To make this connection, it’s mandatory to associate an action with a control. In previous tutorials, we analyzed how to create controls and how they are connect to dataset. Actions will be connected to those entities when the application user has to interact with the interface.
Actions
Preconditions
We need to create a Dataset and Controls in our project’s page:
...
Also a Stored Procedure is needed to save the input information in the frontend
...
See that the @Dato1 @Data1 and @Dato2 @Data2 are connected to the inputbox controls and the grid_column controls previously created in Wayfast. Once that the Stored Procedure is created, we can go back to Wayfast application and synchronize the SP in the environment.
...
| Code Block | ||
|---|---|---|
| ||
CREATE PROCEDURE spHola_Mundo_AccionesTest_Insert
@Data1 nvarchar(50)
@Data2 nvarchar(50)
AS
BEGIN
INSERT Hola_Mundo_AccionesTest(Data1,Data2)
SELECT @Data1, @Data2
END
GO |
Click “End Task” button related to Project’s requirement. This step is only needed for synchronization of the new Table and Stored Procedure generated in DB.
...
Now we have the new objects available in Wayfast Application to associate with Controls and Actions.
...
How to create new Action?
Return to Page’s information details.
...
Make sure that search on “Stored Procedure” lookup field remain the created SP in DB. Automatically Wayfast detect the SP parameters: “Dato1” “Data1” and “Dato2”“Data2”.
These parameters should also be added in the “Parameters” text field “&InpDato1” InpData1” and “&InpDato2”InpData2”. They have to be separated by commas.
Finally choose the instance (environment) where we are going to apply the Actions setting.
Click “Accept” and the new action is created and connected to the Application.
Click If you want to check the new action under the application, let’s click “Preview” button on the page and input new values. Then click on “Agregar” “Add” button which is the control associated to the action.
...
...
| Info |
|---|
...
We can verify in the DB that the |
...
table has the new input values inserted through the app. |
...
How to update Dataset with new Action created?
If the action created and linked to the control (button) is updating the DB but the new data is not displayed on screen in the moment that we inserted, we need to check how the new action is connected to the Dataset.
...
Click “Preview” button again on Page
...
Input new data and click “Agregar” “Add” button. Every time that we click on the button, the Dataset will be executed and consequently, the information will be refreshed in the grid.
Recap
In the first part, we reinforced the preconditions to create pages with basic structure (dataset and controls) and then we learnt about how to create new action items and how they can be related to these Controls previously created. In the second part, we verified how the interaction is executed in the application environment and how this can be edited to adjust the interaction regarding what we display and what we insert in the DB.