I have an application written in Delphi that uses dBase IV tables. The data
is entered into the detail table using a dbgrid. With the master-detail
settings made (MasterSource and MasterFields in the detail table pointing to
the master table's datasource, etc), creating a new record in the grid will
propagate through the key field from the master table. Is this reliable? And
as someone else said, cascaded updates/deletes?
I had a line of code in the OnNewRecord event of the detail table to put in
the key value but commenting it out means this appears to happen
automatically.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Cree
> Sent: Wednesday, 12 May 1999 14:46
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Simple database Q (Paradox/dBase)
>
>
> I don't think it will propagate the linked fields. I write code in the
> BeforePost event of the detail table, to put the key values in if they
> are not already there. That seems to work alright, though it's not quite
> as good as the way Access does it.
>
> __________________________
> Scott Cree
> Knowlysis Limited
>
> Phone: +649-358-0017
> Fax: +649-358-3534
> E-Mail: [EMAIL PROTECTED]
>
>
>
> -----Original Message-----
> From: Patrick Dunford [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 12 May 1999 13:27
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Simple database Q (Paradox/dBase)
>
>
>
> If I have two tables set up in a master-detail relationship using the
> properties in the TTables and the detail has a foreign key from the
> primary
> table, if I add a new record to the detail table, will the key value
> from
> the master table propagate automatically to the linked field in my new
> record in the detail table?
>
> I remember that this works in Access, but I don't have any information
> on
> how the BDE does it for Paradox/dBase tables.
>
> TIA
>
> ============================================
> Patrick Dunford, Christchurch, NZ
> http://patrick.dunford.com/
>
> ------------------------------------------------------------------------
> ---
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
