masterRowset example

The following example links an employee to the various positions they have held over the years:

emp = new Query( )

emp.sql = "select * from EMPLOYEE"

emp.active = true

pos = new Query( )

pos.sql = "select * from POSITION"

pos.active = true

pos.rowset.indexName = "EMP_ID"

pos.rowset.masterRowset = emp.rowset // Identify master rowset

pos.rowset.masterFields = "EMP_ID" // Field matches index order