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?
Cascaded updates work well when Referential Integrity is set on Paradox tables.
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
begin 600 WINMAIL.DAT
M>)\^(@(%`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`* $```$````,`````P``, (````+``\.``````(!_P\!````2P``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&1A=&%B87-E0&1E;'!H:2YO<F<N;GH`
M4TU44 !D871A8F%S94!D96QP:&DN;W)G+FYZ```>``(P`0````4```!33510
M`````!X``S !````%P```&1A=&%B87-E0&1E;'!H:2YO<F<N;GH```,`%0P!
M`````P#^#P8````>``$P`0```!D````G9&%T86)A<V5 9&5L<&AI+F]R9RYN
M>B<``````@$+, $````<````4TU44#I$051!0D%314!$14Q02$DN3U)'+DY:
M``,``#D`````"P! .@$````"`?8/`0````0````````"Y#<!!( !`#$```!2
M13H@6T151RU$0ETZ("!3:6UP;&4@9&%T86)A<V4@42 H4&%R861O>"]D0F%S
M92D`- \!!8 #``X```#/!P4`# `1``8`- `#`#4!`2" `P`.````SP<%``P`
M$0`#`#0``P`R`0$)@ $`(0```$-#1D0X-3$V.$,P.$0S,3$Y134R,#!#,$1&
M,C(T-39$`"D'`0.0!@!@" ``% ````L`(P```````P`F```````+`"D`````
M``,`+@```````P`V``````! `#D``'&!/S6<O@$>`' ``0```#$```!213H@
M6T151RU$0ETZ("!3:6UP;&4@9&%T86)A<V4@42 H4&%R861O>"]D0F%S92D`
M`````@%Q``$````6`````;Z<-3]X%H7]S0B,$=.>4@# WR)%;0``'@`># $`
M```%````4TU44 `````>`!\,`0```!(```!T:6U =&AI;F-N>BYC;RYN>@``
M``,`!A!%(1>[`P`'$(0(```>``@0`0```&4```!)2$%614%.05!03$E#051)
M3TY74DE45$5.24Y$14Q02$E42$%455-%4T1"05-%259404),15-42$5$051!
M25-%3E1%4D5$24Y43U1(141%5$%)3%1!0DQ%55-)3D=!1$)'4DE$``````(!
M"1 !````N08``+4&``#/#P``3%I&=: :J:__``H!#P(5`J0#Y 7K`H,`4!,#
M5 (`8V@*P'-E=.XR!@`&PP*#,@/&!Q,"@S(S$P]F- /%`@!P<G9Q$B 3A7T*
M@ C/"=D[\1>/,C4U`H *@0VQ"V!@;F<Q,#,4( L#;!!I,3@P`M%I+3'\-#0-
M\ S0&_,+5152# &:8P! ( J'"V@Q-@J@/0-@= 60!4 *BQM0,S9/')<4(@P!
M'S9)(!' =B1E( .187 +4&ECR&%T:0(@('<%$ ) !0GP( N ($1E;'"P:&D@
M=!' !4!U$?"Q!"!D0F$1\"(P5B2PA0&@; >0+B!4:"*0VF0C0&$*A00`( GP
M'V#S%Y$D$71O)+$FD1(`"W!O`R E\R4!"X!G(J E4&*I"<!I9"905R/ :"A3
M]0# <R>Q+2BD"H41\2-0CQJ0!" `P VP("A-*Q.Z4PAA8R*2)_ M-$8(D)QL
M9 0@)"$H;W!O*!'?*9(H, J%*L@EY"<E02;!BG,MHRPG@'1C*3- [04`92-!
M*:-N!]$7D 6A_R?R+S,J$B.0`Q KQA\Q"K">9R- (I DP -@=6<JI/!K97D@
M&\ NP3@@`V'[,6\F4$D$("3 )V$7D!M0_28"/Q-P+A *A26 +# #<%YE`B B
MD"1@)9%S"W!DGS.A)8 C, VP)_!U<":QW0>0+PVP)B ]\3\*CQS_W3[B0ST]
M(Y %L&LCD"1@[0,@=R: `Z!2#< GP3"![P= (C GH2H1=#@0)V$1\9H@(W%0
M"L LX&]X)>;_'[\@SQ],(D(G\"G0&U \09QO9C.P!'$O!D]N!\'[0Q TTV4B
M@ (P2<(O3R@QO'!U!4 +@#$)-_)V!T#9"E @8DUA!:!M!X PA/\CP$3036$'
M@ 8B.C,BX3/@WQ'@31(1P%$A3:9A36 #<3<C4",P-@!Y1?8^M3X@:BU4<D\%
M$&<+@$.A3;,'D#S 9V54<U/G1@-ANCI$T'<T<"M1)L%B)8$60#XQ)($N!;!G
M+F[Z>E/G6T<M'9$,8!=P'S5Y&T!N:R?P`, #$"@P.B]7#U@91R\?5%U*P"!"
MJF41P&Q)X$])X%,%H'\"0$$`"=%3YP9@`C!6X%>K"8 T<',FL'DS0#$2(#,M
M,#@0,3EBT&) -#KT-#93YU1;X 706I C4/\+4"*0-+$%( B0`C $($G1'QM0
M*R FHURB8+AU8FH3'W%6X%)%5N!;1%6@1RU$0EU6X%,'</-D@EQF(%$M$$45
M/B E<IXI4^9JCB(Q15!N)P5 _SHQ6U!/XC7B-HLBD$F!-_#_.'$NLSGA(Y,B
MD$H)4^=?</,"$!>04&]EP4N/*.8S0-]-)4XK+O,&D'(R>5/G"L"M(I!N'U B
MH&PST60X$)],$1>0)E(DX1'P96U1<Z="(W9Q5.!H='-!:#=CYR/ ,G%V,G%U
M;X%U: 0@7&=O!' [LDP2=V*10=YC+= $$450=))T1?9K>)Y??C]^QF"X8"\@
M2W8P[G=30 "0!"!,!W!O@3M&+6MX4'DP-' Z#((@*P`V-#DM,S4X+<D;D#$W
M5AAA>(0-A+#D,S13YT4M+3 #$(0$HP3P@(%C0&N!IBX%H+]8F8G?4_]5#U8=
M11!T!1#B8T)01'5N<2$G\%E?[UIO6W<]P(\$0",P(H #8/^.P%B0$@!=GUZH
M8+]ASV+3^#,Z,H4H8_]E#V8?9R5_9]]H[VG_GK]KETG@(D5T_T(@)>5$DSVP
M)!(IT"L+.G+](T-S))"B8"ET<$HVD@20YR-0=)1,$E14H;0N`DP9_Q' 4/$X
M('$QC% #H#?S.*7_I1D'< K =5AR]73Q(D LX/])0C1Y*#]S(FTC3BN+5P-2
M?ZK8,8TVB5*;K29N6B02;?\X$#1QBU<TO"BJ/J9K>A>0_P> !M Q\B32.C-"
M(B[S?#3_,T!/`FP6(F5$48\24M("(!^+5[SY>3 'X$P20D1%/WR6J()%!IY$
M18UK>%1)^D'!+SW#?\2/Q2>#*(Z,O3- 0S= FB$1L"VQ:#- ?$Y:BU>/CY"?
M(E "0'#8.B\O/N".DRZ2-8EQ_&TODZ\?6XM-T _1'](OW],^BUJ+5]6 !\):
M,^ :<?LG\"1551'P46$)P A@HF#^+21 G2:",)HQ5@A<;UA\^]LOE@%B`) ?
M8%;@R6_*?_W+AG??@,QP70_-GU/=XM__X^_D_].OXGG5#]8?UR_8-O_9/]I/
MVU_<;]U_WH_?G^"O_\YO4[CEK_:_]\_XW^9,Z&__Z7_JC^N?6'K_S^Z?[Z_P
MO[_QS_+?'T]&KA+R!?\@&@$"``G@`````P`0$ `````#`!$0`````$ `!S!@
M(7/4-)R^`4 `"#!@(7/4-)R^`1X`/0`!````!0```%)%.B ``````P`--/TW
$``"@V9R^
`
end
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
