you might need to setup a trigger in SQL7 that deletes the other records.
There will be an event like BeforeDelete that you can use to get the ID of
the record (assuming you are sing ID to tie the master detail records
togeither, then in the AfterDelete event, tell it to delete the other
records based on the ID you got.
I could be wrong about the names of these events, I have not got SQL7
istalled at the momnet, only Interbase.
Or even a Cascade Delelte might be the answer too...
hopefully someone else might be able to help a little more, but in the mean
time, you might beable to get somethig underway that will work.
Cheers,
Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Moises Lopez
> Sent: Sunday, March 12, 2000 6:46 AM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: A little help wih ADO.... please?
>
>
> HI, ppl.
>
> (rookie question..)
>
> I have a little problem...
>
> I'm using Delphi 5/ADO/MIDAS/SQL server 7 ....
>
> and i have the master detail clientdataaset connected
> via datasetfield.
>
> But, for some reason when i delete a master record i
> cant'seem to delete the corresponding detail records.
>
> any weird thing i'm missing out?
>
> (well obviously there is..)
>
> thanks in advance...
>
>
> Moi.
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
