'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
