A Dataset represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.
How to get dataset
Create a new behavior. Put the appropriate caption. Click Action wizard.
Click Create an action.
Click Other Scribe Functions.
Select Get Dataset in Other Scribe Functions dropdown. Click OK.
Click Save changes.
Click View code. This example of default code:
Change form name, field name and value accordingly. This code will set to display information if Department equal to 'Dep1'.
Add this below code after the default code. This code will display Admin Name and Department which department equal to 'Dep1'
Dim deptTable as Datatable=Data("Display")
Dim idept as Integer=0
If _Set151731 is nothing=false then
If _Set151731.tables(0).rows.count>0 then
for idept=0 to _Set151731.tables(0).rows.Count -1
dim _rowBInewxc as datarow=deptTable.NewRow()
dim _rowBIxc as datarow = _Set151731.Tables(0).Rows(idept)
_rowBInewxc("Department") = scribe.GetText(_rowBIxc("Department"))
_rowBInewxc("AdminName") = scribe.GetText(_rowBIxc("Admin Name"))
deptTable.rows.add(_rowBInewxc)
next
End If
End If
Data("Display") = deptTableScreenshot as per below. Click Check Syntax, if no error then click Save and close.
Click Create now.
Example how it look in the form:
