Hello,
I would like to make a CodeJock Report which reads data from a parent table and from a child table. The find process would be (more or less):
Code:
Find ge parent by index.1
While (Finderr=false)
Move false to bHasChildren
Clear child
Move parent.id to child.id
Find ge child by index.1
While (finderr=false and child.id=parent.id)
// Here I show data from parent and child table
// The “Show” represents each columns
Move True to bHasChildren
Show parent.id
Show parent.name
Show child.field_x
Showln “”
Find gt child by index.1
Loop
If (hasChildren=false) begin
// Here I show data onlu from parent table (he doesn’t have childs)
Show parent.id
Show parent.name
Show “”
Showln “”
end
Find gt parent by index.1
Loop
I think that isn’t possible with a constrain, so I can’t use the “PeDb_Type” property to “eRC_db_Table” because (I think...) it uses constrains
Is there any way to do that?
Thank you.
Victor M. Diego
A.T. MEDTRA, S.L.
Santander-Spain