Has anyone used the  'Unique Table' dynamic property of the ADO RecordSet?
I intend to append record to one base table of the 2 join tables. I issued
the following statement in the AfterOpen event of the dataset:
  ADODataSet1.Recordset.Properties['Unique
Table'].Value:='name_of_one_table';

However, this does not work at all. At run-time it still tries to insert
records into another table.

Who can give me any advice? Thank you!
BTW: I use SQL2000 on Win98, and Delphi 5.

The ADO's 'Unique Table' dynamic property only works for deletes.
It takes a lot more than that to restrict inserts and updates. I have
implemented that functionality in TBetterADODataSet. Get it from
the link below. It's free and it gets the job done.

With MS SQL you also need to specify the 'Unique Catalog' property
in conjunction with the 'Unique Table'.

HTH
--
Vassil Nazarov
http://web.orbitel.bg/vassil/

Dynamic properties are visible and interactive with this browser Trial
www.adoanywhere.com/cnet

--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial  www.adoanywhere.com/cnet
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com
Email m...@adoanywhere.com
--