Reliability and robustness. Its all OO either way but if you write a lot of code at the form level its more of a hack than if you write bespoke classes. Its less important if you have one query, but if you're working with multiple tables, are you going to reuse the same query component (ie making if 'global') or have a load of form query components, or as I prefer, have the query component created dynamically at runtime and used 'behind' the scenes? I prefer the query to be part of the class.
David Bolton ----- Original Message ----- From: "David Smith" <[EMAIL PROTECTED]> > What's the big advantage to working with TQueries > non-visually? > > DJS > > --- David Bolton <[EMAIL PROTECTED]> wrote: > >> I don't use components that let a user work >> directly on the database. Oh >> sure they are ok for a quick and dirty hack, but a >> well structured >> application is done best by splitting into three >> tiers. Presentation Layer >> (the GII- front end), business logic (middle tier) >> and backend (database >> tier). For smaller apps this can be reduced to two >> tiers. Front End and >> database but again there is no direct ability for a >> user to amend values. I >> don't use ttable (or whatever the ado/mysql >> equivalent) is but mainly >> queries. And they are created dynamically as members >> of a class and do not >> exist as components on a form. >> >> David Bolton >> >> >> ----- Original Message ----- >> >> > No, DBAdvStringGrd. It was slow in reading and >> > displaying table data.. sorting too. It was the >> most >> > common complaint on their user forum and I saw >> that >> > many a programmer rejected it for that reason. >> Maybe >> > doing it yourself in AdvStsringGrid is faster. >> > >> > DJS >> > >> > >> > --- David Bolton <[EMAIL PROTECTED]> wrote: >> > >> >> The advstringgrid? Slow? No- I find it very fast, >> >> especially with sorting. >> >> Slow for doing what? Do you use BeginUpdate and >> >> EndUpdate when adding or >> >> removing rows? (same with Borland's string grid). >> >> >> >> David Bolton >> > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
