I am trying to build out a master/detail form. When I go to build the master/detail section nad pick the link “Link between applications - Parameters Definition” is just shows Without Parameters. Where do you go in Scriptcase to layout your Parameters. I have all of my joins mySQL set up but it does not seem to carry over to scriptcase. Please help!
Re: Master/Detail No Parameters
Do you have a primary/unique key defined in your master form?
Re: Master/Detail No Parameters
First of all
PrimaryKey of the detail table (application) is always queried. If this is not the case, you forgot to define it. See TreeNode SQL in the DetailApp
If you want to transfer more/other parameter(s) from the master to detail (Grid) you have to define in detail grid global variable(s).
Example
Master
t_company (comp_id, caption)
Detail
t_employee (empl_id, comp_id, name)
Select statement in the Master Application:
Select comp_id, caption from t_company;
Select Statement in the detailed application:
Select empl_id, name From where t_employee comp_id = [comp_id]
If now Master/details are defining content, the global variable [comp_id] queried in the parameter assignment and you you can get a map from the master field in the masterapp. The value of the field is then passed to the detailed application and run the SQL statement accordingly.
In the example, the Employees of the Company shown