Tutorial n°3 : Access an SQL Database
Step 6 : Create a sequence #4
Everything has now been implemented, it should work!
To be sure, let's test it by adding a "Test case" by right clicking on your sequence -> new -> Test case. Name it "Test_Case_phosphate", and then open the Testcase "Variables" folder.
Click the "c8o_title" variable and, in the "Properties" window, fill in the "Default value" property with the "phosphate" value.
Right click the Testcase and select "Run". It will execute the "get_references_by_id" sequence that will call the database query transaction which contains the word "phosphate" in the title.
To be sure, let's test it by adding a "Test case" by right clicking on your sequence -> new -> Test case. Name it "Test_Case_phosphate", and then open the Testcase "Variables" folder.
Click the "c8o_title" variable and, in the "Properties" window, fill in the "Default value" property with the "phosphate" value.
Right click the Testcase and select "Run". It will execute the "get_references_by_id" sequence that will call the database query transaction which contains the word "phosphate" in the title.
Click to expand...
The Back-end steps are now done. Let's move on the Front-end to display the data in the application.
