Customers in the app from the series Building a customer app in Uniface 10 can form groups: a branch below a head office, a subsidiary below the branch. A service returns all members of the group of a customer. Stage 28 added a form that shows them.
Tested with Rocket Uniface 10.4.03 Community Edition (10.4.03.021) on Windows, October 2026. The app uses SQLite through the SLE driver (SQLite 3.50.2).
What the service returns
The service collects the ids with putitem:
vQueue = ""
putitem vQueue, -1, pRootId
vPos = 1
while (vPos <= $itemcount(vQueue) & vPos <= 1000)
getitem vCur, vQueue, vPos
sql/data "SELECT CHILD_ID FROM CUSTOMER_RELATION WHERE PARENT_ID = %%(vCur) ORDER BY CHILD_ID", "CUSTOMERS"
if ($status < 0)
pError = $concat("The group could not be read (error ", $procerror, ").")
return -1
endif
vData = $result
forlist vRow in vData
getitem vChild, vRow, 1
putitem vQueue, -1, vChild
endfor
vPos = vPos + 1
endwhile
pIds = vQueue
putitem vQueue, -1, value appends an item. The separator between the items is the Uniface list separator, the GOLD semicolon. On screen and in many editors it looks like a semicolon, but it is a different character.
Replacing ";" does not help
The first draft of the form wanted to turn the list into "1, 2, 3" by replacing ";" with ", " in the string. That cannot work: the string does not contain the normal semicolon character, so $replace finds nothing. Typing a ";" in a string literal does not produce the list separator either.
Walking the list
forlist knows the separator. The form builds the text item by item:
entry DO_GROUP
variables
numeric vParent, vRoot, vCount
string vType, vData, vRow, vError, vText, vId, vName, vIds
endvariables
call NEED_CUST
if ($status < 0)
return -1
endif
vText = ""
activate "RELATION_SVC".GET_PARENT($cCust$, vParent, vType)
if (vParent > 0)
call ADD_LINE(vText, "Parent: #%%(vParent) (%%(vType))")
else
call ADD_LINE(vText, "No parent.")
endif
activate "RELATION_SVC".LIST_CHILDREN($cCust$, vData, vError)
if ($status < 0)
INFO.REL_DMY = vError
return -1
endif
forlist vRow in vData
getitem vId, vRow, 1
getitem vName, vRow, 2
getitem vType, vRow, 3
call ADD_LINE(vText, "Child: #%%(vId) %%(vName) (%%(vType))")
endfor
activate "RELATION_SVC".GROUP_MEMBERS($cCust$, vRoot, vIds, vCount, vError)
if ($status < 0)
INFO.REL_DMY = vError
return -1
endif
vName = ""
forlist vId in vIds
if (vName = "")
vName = "#%%(vId)"
else
vName = "%%(vName), #%%(vId)"
endif
endfor
call ADD_LINE(vText, "Group of #%%(vRoot): %%(vCount) customer(s): %%(vName)")
RESULT.REL_DMY = vText
INFO.REL_DMY = "Group of customer %%($cCust$)."
return 0
end
The same entry also reads the parent with GET_PARENT and the direct children with LIST_CHILDREN. Their rows are lists too, so getitem takes the columns.
Result
Test data: three customers, customer 2 as a branch of customer 1, customer 3 as a subsidiary of customer 2. Customer 1 loaded:
No parent.
Child: #2 Example, Robin (BRANCH)
Group of #1: 3 customer(s): #1, #2, #3
Setting customer 3 as the parent of customer 1 was refused by the service: "Customer 1 is already above customer 3 in the group. This would create a cycle."
Notes
- Treat a list from a service as a list:
forlist,getitem,putitem,$itemcount. - Use string functions only on text you built yourself.
- To build a list, use
putitem; a ";" in a literal is just a character.
Top comments (0)