A word of advice.
If you can avoid it don't use Cached updates - There is just too many bugs
in it.
Use the TClientDataset instead - I think it only comes with the C/S version
- Works like a dream by comparison and it is especially good for Master
Detail updates etc.
> -----Original Message-----
> From: Mark Derricutt [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 25, 1999 2:35 PM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Cached updates and table dependancies...
>
> 'llo peoples....
>
> Just a question which I'm not quite sure how to best attack...
>
> I have a TQuery/TUpdateQuery attached to a DBGrid and a child form for
> editing (all fields apart from the key).
>
> Now I have a need to edit the key field (a rename function) which needs to
> trigger an update of another table that refers back to this main
> table.
>
> Whats the best way to handle this with a paradox table? Is it possible to
> put two queries in the TUpdateQuery so that it updates the child as well?
> Or would it be best for me to look at doing something with proper
> transactions (BeginTransaction on a TDataBase component) and just run
> multiple queries against that TDatabase?
>
> Thanks in advance,
> Mark
>
>
>
> --
> Mark Derricutt | Chalice of Blood
> Software Developer | New Zealand Christian Music News
> Auckland, New Zealand | http://www.chalice.gen.nz
> [EMAIL PROTECTED] | UIN: 1934853
>
> Getting jiggy with Mortification - At War With War - 97 Demo Version
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
