Re: [DUG]: Data aware controls [was: ADO access]

[Neven MacEwan]

Dennis

Re:

> RequestLive can only work if:
>
> 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!
     - 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)

Regards Neven

N.K. MacEwan B.E. E&E

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz