> > a. The query is very simple, like an address book type
> query (select *
> from
> > table - you might just as well use TTable), not generally
> suitable for C/S
> > programming. Can't use joins.
> > b. The datasource supports updates - which means no stored
> procedures, or
> > complex views.
> >
>
> a. Score one for ADO/MS SQL but you can edit cursors with
> joins (and both
> sides of the join)
>
> b. If you are in this situation then you have two options
> - Look at the normalisation of your Database -
> normalising generally
> makes editing easier!
My tables are always normalised :).
> - If its complex (lots of sub selects etc) dont edit the
> result of the
> stored proc but post that into
> a temporary table and then post the results with
> another SP (server
> side cached updates)
> (also relatively easy in MS SQL)
That is my point - you cannot use data controls directly off a TQuery
because the datasource may not be editable. You have to use other methods,
be it temporary tables, etc to update the database, and if you are going
down that path, you may as well use rich objects.
Regards,
Dennis.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
