cascading delete in BDE

[Guest_imported]

Hi,

I have a MSAccess database that I connect to via BDE in Delphi. I'm not sure how you programmingly set the cascading update/delete property. I know you can choose Edit->Relationship in Access and enable "Cascading updates". But surely there is a way to do that in my program... right?


Any help appreciated
Cathy

 

[Robertio]

As far as I know you can't using a paradox database we had our own routines which just looped through the detail table records and updated / deleted the appropriate records.

It may be that there are 3rd party database components which may allow you to set this property to access tables

 

[Guest_imported]

That's sad. It would be really nice if they have this option. Thanks for you help anyway.

cheers
Cathy