Hammer wrote on Oct 24
th, 2007 at 11:46am:
1. Sesame is not flat file. We don't have JOIN. We do have relationships.
I'd call it a flat-file/RDBMS hybrid then, one which behaves far more like a flat-file system than a RDBMS system.
Hammer wrote on Oct 24
th, 2007 at 11:46am:
2. Yes, you can do this with X-Commands.
What I don't follow is how to implement the X-Commands efficiently. If I understand how reports work, there's only a Global Code section which runs once at the start of the report. Then, as each row is generated, you could call the necessary X-Command in the On Print event. My normal instinct would be to create one XResultSet per row and then share that data across all cells in the row. But all I see is the ability for each cell to do its own lookup.
Quote:If you want more information, more specifics about the format you want to produce would be helpful. If your question is purely a theoretical exercise using the classic Teachers/Classes/Classrooms problem let me know and I'll just pick an output format.
To take my theoretical example, let's say I want to print the following columns:
Class Name (from Classes)
Class Description (from Classes)
Teacher First Name (from Teachers)
Teacher Last Name (from Teachers)
Classroom Number (from Classrooms)
Classroom Floor (from Classrooms)
Classroom Seats (from Classrooms)
As the report is running through the set of Classes to print, does it have to do five separate lookups per row or can you get it do to only two?