Scary S$#t isn't it! I've got stored procedures which do some quite
complicated stuff and ADO is still thinks most of the fields are updatable
(some particularly complicated ones it gives up on and makes readonly).
Unfortunately you don't appear to have any control over how the updates are
applied (I use stored procedures) so I actually do all my editing in
TClientDatasets.
David.
----- Original Message -----
From: "Neven MacEwan" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, November 21, 2000 6:10 PM
Subject: Re: [DUG]: Problems with CloneCursor
> Myles
>
> I will be more thoughtful about my ADO Gripes!
>
> try this for a Editable/Live dataset
>
> SELECT
> a.TMTimeSheetEntryID,
> a.Notes, a.HRStaffID, a.JSJobID, a.ARAccountID, a.TMOverheadID,
> a.Started, a.Finished, a.Chargeable, a.Booking,
> COALESCE(b.Name, c.Description, d.WorkRequested) as Descriptor
> FROM
> TMTimeSheetEntry a LEFT JOIN
> ARAccount b ON a.ARAccountID = b.ARAccountID LEFT JOIN
> TMOverHead c ON a.TMOverHeadID = c.TMOverHeadID LEFT JOIN
> JSJob d ON a.JSJobID = d.JSJobID
> WHERE
> Started BETWEEN :Started AND :Finished AND
> HRStaffID = :HRStaffID
> ORDER BY
> Started
>
> ----- Original Message -----
> From: Myles Penlington <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Tuesday, 21 November 2000 18:00
> Subject: RE: [DUG]: Problems with CloneCursor
>
>
> > 1. FetchOnDemand not fully implemented - actually reads through all data
> in
> > nested datasets and only sends to the client the requested detail
> dataset -
> > very inefficient - fatally so - we could deal with this - wrote our own
> > provider which fixes these issues.
> >
> > 2. We are using nested datasets for master/detail on the client side.
The
> > MIDAS.DLL fails to update the ChangeCount and propagate the change count
> to
> > the master datasets, hence you cannot do ApplyChanges as the changeCount
> on
> > the master dataset is zero.
> >
> > 3. After a post of a detail dataset when the detail dataset is empty, it
> > loses the record (it disappears), if you refresh/navigate etc, it
> reappears
> > later, it however you add 2 or three records it appears to be quite
happy.
> >
> > 4. Because of 2 & 3 it gives Key Violation exceptions, as it appears to
> lose
> > the data just keyed. These all seems to be related to the ChangeCount
not
> > incrementing and failure to post records.
> >
> > Can't do anything about 2,3,4 as they are all problems with midas.dll
> > <grrrrrrrrrrrr .... ^#%^%$#>
> >
> > Midas.dll works fine on single level datasets.
> >
> > Myles.
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 21, 2000 5:47 PM
> > To: Multiple recipients of list delphi
> > Subject: RE: [DUG]: Problems with CloneCursor
> >
> >
> >
> > Want to share some of the issues you have had with the clientdataset?
> >
> > JED
> >
> > >>Last I heard was that DBExpress was to be based on MIDAS which by the
> > state
> > >>of TClientDataSet is anything to go by, it gives me the shivers - I
will
> >
> >
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
