Quoting Paul McNett <[EMAIL PROTECTED]>: > This probably sounds very messy, and that we should just allow querying from > related cursors, but I've used this 'denormalized cursor' approach for years > using a tool that easily handles related cursors (Visual FoxPro). I've found > it > to be simpler and much easier to maintain using the single denormalized > cursor > approach.
While I understand that using the 'denormalised' approach would simplify the coding of the reportwriter, how does the whole app cope with extremely complex SQL? For example, one report that I'm running at the moment uses 'insert into.. select from...' and takes an entire page. I think that would be quite hard to code using Dabo's .setBaseSql(). Using Firebird, I can create this sql and store in the database- would that be the best approach? > Okay, but *please* understand that the report writer is in its infancy. We > only > really started developing it this year. If you understand the implications of > that (you may have to struggle because of problems with the report writer, > you > may have to update your reports over time as the reportwriter changes, etc.) > and > you are willing to work with me to get the problems ironed out and to advance > the state of the report writer, then I'm stoked to be working with you!! I'm happy to do all of the testing for you- on a live project. I'm also going to write up a tutorial for using AppWizardX and adding all the little features we've discussed- this will give me practice, and also let me consider how everything will fit together. > > > > What I will do is: > > 1. create the database using embedded Firebird (this will be 2 main tables, > with > > about 20 tables for values to input into these 2 main tables (is there a > term > > for this?), > > Do you mean the 2 main tables have a one-to-many (1:M) relationship with the > 20 > tables? Yes. The two main tables join the other (20) tables, for values like loadPorts, stockTypes etc. Regards, Matthew. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
