> > And furthurmore it wouldn't make sense to in this case where there is
> > no stated relationship between the tables... I thought I saw somewhere
> > that ORACLE8 (or was it 8i) supported updatable views which can be joins
> Well the situation I have, is I have a master/detail table arangement, and
> I have a requirement to be able to "rename" an object in the master table,
> which is, change its key field, and I was wanting to have one query which
> would update the master table, -and- the child table.
> This is against a paradox tables (at the mo).
I thought that Paradox supports cascade updates -- I thinks it's simply a case
of specifying in the referential integrity rules that the key of one table references
another table and that cascade on update is desired (in database desktop I'd
expect)...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
