I tend not to use the generator from a trigger for this reason. Also if
you have related child records you need to have the key value before you
add them and you can't do this if you don't know the value.
Instead, I call the generator from the client code first and then use it in
the master and child records. Problem is, if the user cancels, you lose a
generator value as generators are not included in transactions.
Andrew Masters <[EMAIL PROTECTED]> on 13/04/99 11:19:58
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: RE: [DUG]: RE: Record/Key Deleted
Yep, using Interbase. Yep again, the table in question has a trigger which
gets a PK from a generator.
Figured it was something to do with this but was hoping there was an SOP
for handling this situation.
Cheers
Andrew
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 13, 1999 8:03 AM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: RE: Record/Key Deleted
What's the database? It's a server of some sort I'm guessing.
If this is the case then it's probably becuase the server has changed the
data in between the bde writing it and reading it back again after. The
bde does this to ensure that the record made it to the server in one peice.
So, you probably have a trigger or an autoincrementing field or maybe some
defaults that you haven't specified values for.
If it's not a server then I don't know.
Andrew Masters <[EMAIL PROTECTED]> on 12/04/99 16:52:01
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: [DUG]: RE: Record/Key Deleted
Well it may not have been such a dumb question... no takers. A last gasp
help on this one.. any ideas ??, I still haven't sussed it.
-----Original Message-----
From: Andrew Masters [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 09, 1999 3:40 PM
To: 'Delphi Users Group List'
Subject: Record/Key Deleted
Hi All,
Despite my gut feeling that this is a dumb Friday question......
I've got a simple dialog with 3 bound controls (DBLookup, DBMemo,
DBCheckBox) using a query with a live dataset. I simply do a query.post to
save it. For some reason when I do a post I get a "Record/Key deleted"
error, but only when I'm inserting a new record, not when editing. But the
insert still works ??
I've got loads of these types of dialogs and have never seen this error
before. Anyone know what it means ? The ONLY different thing going on here
is the DBLookup is populated from the same table I'm inserting/Editing with
a SELECT DISTINCT(FIELD1) FROM TABLE (ie. User can enter anything into
FIELD1 but can select from a list of unique values previously entered).
FYI, using D3, IB4.
Thanks
Andrew Masters
Clinical Solutions Ltd
Auckland, NZ
Ph: +64-9-476-0106
Fax: +64-9-476-0108
e: [EMAIL PROTECTED]
---------------------------------------------------------------------------
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
(UUEncoded file named: att1.unk follows)
(Its format is: File type unknown )
begin 644 att1.unk
M>)\^(A(6`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V`!``"`````@`"``$$
MD`8`J`$```$````0`````P``,`(````+``\.``````(!_P\!````1P``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&1E;'!H:4!D96QP:&DN;W)G+FYZ`%--
M5%``9&5L<&AI0&1E;'!H:2YO<F<N;GH``!X``C`!````!0```%--5%``````
M'@`#,`$````5````9&5L<&AI0&1E;'!H:2YO<F<N;GH``````P`5#`$````#
M`/X/!@```!X``3`!````%P```"=D96QP:&E`9&5L<&AI+F]R9RYN>B<```(!
M"S`!````&@```%--5%`Z1$5,4$A)0$1%3%!(22Y/4D<N3EH````#```Y````
M``L`0#H!````'@#V7P$````5````9&5L<&AI0&1E;'!H:2YO<F<N;GH`````
M`@'W7P$```!'`````````($K'Z2^HQ`9G6X`W0$/5`(`````9&5L<&AI0&1E
M;'!H:2YO<F<N;GH`4TU44`!D96QP:&E`9&5L<&AI+F]R9RYN>@```P#]7P$`
M```#`/]?``````(!]@\!````!`````````(!6`$$@`$`(@```%)%.B!;1%5'
M73H@4D4Z(%)E8V]R9"]+97D@1&5L971E9`!B"@$%@`,`#@```,\'!``-``H`
M$P`Z``(`0`$!((`#``X```#/!P0`#0`*`!``%P`"`!H!`0F``0`A````-T$P
M,C-!-#$X.48Q1#(Q,4%&,S4T-#0U-3,U-#`P,#``Q`8!`Y`&``@+```A````
M"P`"``$````+`",```````,`)@``````"P`I```````#`"X```````,`-@``
M````0``Y`*`!4IDRA;X!'@!P``$````B````4D4Z(%M$54==.B!213H@4F5C
M;W)D+TME>2!$96QE=&5D`````@%Q``$````6`````;Z%,ID.03H">_&)$=*O
M-41%4U0`````'@`>#`$````%````4TU44``````>`!\,`0```!4```!A;6%S
M=&5R<T!C<VQT9"YC;RYN>@`````#``80,YT3,`,`!Q"V"```'@`($`$```!E
M````6450+%5324Y'24Y415)"05-%645004=!24XL5$A%5$%"3$5)3E%515-4
M24].2$%3051224='15)72$E#2$=%5%-!4$M&4D]-04=%3D52051/4D9)1U52
M141)5%=!4U-/34542``````"`0D0`0```-X'``#:!P``.`X``$Q:1G5Z?LK-
M`P`*`')C<&<Q,C5&,@#X"V!N9S4.(#F=`?<@`J0#XP(`8V@*P.!S970P(`<3
M`H,`4*$0=G!R<3(1=GT*@-D(R"`["6\.,#4"@`J!;'5C`%`+`V,`00\",0@P
M,S,+IB!997"8+"!U`)`/("!)`C`I!)!B81$P+A?2(&'&9PMQ&!!T:&49X`&@
M)FP:$`N`('$*4'-TVFD"("`1``0@81G@!1!$9V<$D"!W:`W@:(H@&_!T&W)0
M2R`#4DL;@1OP;@20870%L"[W"J(*A`J`1AO0"'`)@!J`]05`=QMA<P-P$4`<
M0!AA^1X`(&0@H`/P&?`9X00`B"!B=1^4:&]P(%./&@`)<!^C`Y%33U`=(.,%
ML1$`;F1L(D0A80"0W'1U'?`;$1X[0QH`!)#;$,`>4T$C\`EP=QY*"O1Y)!`S
M-@%`%I`!0!+`;PD8L&-T$@0Q-B`M?2GR3QO!"X`'0`70!Y!S_1F`92GS'D8I
M!"C1"Q,I!F!I+3$T-`%`)!`Q'#@P`4`,T"V38B!&E0-A.@R#8A%@<&H"(%T'
MD$`"$`1P&O!U`2!S"BT`D"X%H"YN>B#`6U--5%`Z+[\PQ[Y='D4NP`9@`C`O
M)U0:T6AD87D8$$$2P`,1,1(S&!`Q.380(#@Z2Q<@$7!-,W=4;R\G3;QU;!L`
M"U`:$`EP8P4@QPB0`C`$(&]F("00&O`Q(+!E;'`<0#-X=6)&:BDQ+R=293HQ
M4$3(54==.]!213Q!!9*`9"]+97D@1#G0_Q%`"8`KGRRJ*%0/!@NG)TWE"H!7
M$0!T)P0@&?(U$/,!D1CQ/R`8@$)"&Y`1,/QR=AP!.4$?\A_A`"`8@+XG'6`?
M("KA&%$>.TDY4/<A0R%A&?)C&/$9X@.@'X#?0E$H\1C@`F`],&(%D"3@_T?$
M0]8;4A#Q#R`?41GQ'D1G0L(:@DD@='<)X1GC8O\!`!P@!1`;`!AA'X$CX3B!
MS&%D3648X&-K&709</\!@`20&2`TP$LF3.(@P`>1]R%#()$)\',?,1GA'?`9
MX_LXD3S1(`#`3/$?@2"12:EW&I$QX2^@90W@&1`>1%/Z;Q@0>0A@2(@1`$00
M&XEK!;$#D6$AH&\+@`4`9?\'@`(P&%(M8#G0'V`%L0#`_GE)(!_C2T4!$%?P
M."!"8J=2(5725J)N)P5`<U30]SBP60$?8'8'0!K1(X)%[MU(0VXI$$.X1_-)
M(+%;\OIK7L!W'CMA'T%+)M0%T&<8\!BQ!"`\80#`8^-`U&-S."!D,/0^5($U
ML&`R+S`T+S8A*<`Z[PY`-F`6(QZ&4!I@1[()<%]<,`(@2O$@H3G30#G$+O\%
ML$70,3`>2C=10U`W_SD/GFED,&C?96(>1&-C:O)H("AB;R)0/8$%P$IQ,>(O
M3&\J<!KQ9.`F_QB0(Y$`P!L"'D1O4D_1!9#&:%[`"0!G>2\F$`403QKP$/`(
M<!#P+T8R1RG_534ZQ4-0._4\7SUL=_]!Q/\YT`,@'X%9D5ZS5J-)($@19U&P
M'&$;D&1U!M`:MRZW?)!>L1HA:R9!&2!!.6#W8]$<@!CP<!Y$&@`YX&6BWR%#
M,>%\H0!P=T!I`0`;8?P_/Q@07^`:\7G16[<8,/\1,!]B'CLI_RL-+N-R8V-=
M_S%D9%\S.#0#<F,NX(``-2CD,#DUY3,Z+;`<\#:U;6K3)SU1;2)50^$$($?5
M`V!U&6!,.8$G=/YVO]5WRTAM0$%YT"P>2CU0=UPP'X`:$&V.\!\@!4!F_PG@
M)!52(T<$>Z6)1'P*?)'U1?LG5L%G7M0'<&N"3D#?!T!PP"#D-H`&X'5-X06@
MBP(P`V!L!"`H1$)PL/QO:XS@&!"9,(/@!&"0I8>9,"813N!";W@I&"7[&Y`:
MP7*.\"#S&Y`D$%;!_T+"$3$9(("AEO*.\"#!F\7^+FA0.9$>`!Y$*P!6P8(1
M_R[0!;%$@TX1'_`#H!PP7[7?&X&>TU_@')$;@2*.:3G!W3V"(AY$!)`#8'(8
M$"&2_P(@2/&A-$4Q"X!#X4U3&Y#_'<`'X%*4&!!>PJ$S"8!-0[T9($(AH4L7
MI?2`M7<%L/YK@$*5?Y:""0!.,#DC&?']1\)Y5-`Y(Y=4(P(?8%:C_QW`1!(1
M,$QS(6&D8U`E`1#_!;`9$2;05=!4H6!B'"%2(1]Z`DX@!C%#0$_Q($]._$Q9
MET$!("*A`C`A,AAA_Y:`&%(;(B*AJ05"9)DV1R+]:%!P:T`=\!]1'3-)HX;P
M\QH6I;LO1:@4(.,>1!N00%-%3$5#5#U`21!35$E.NK`H1DD)NH!$,9M`1E)/
M3?4TP$&90$5O@`B0&2",4O]'D:?A&*)_LB`T"X"?)KMT_R&#O4(1,!I@*4`=
M)CES.4']F%!I&L%<QA+`KJ`;$!@PETCQO8,)@"D>/%E)&!;B1#7124(T'CM/
M\`!P]ZI@8O\F1T,D$0W@@[%5D'<*0!L"!"!,91`F=18`:U,/`:=!3EIG56@[
MT"L`-C0M.2TT-S:2+6;0,#8>I6%XRSW^.*0%.]"&_VGM@JG0_](/W],?U"\K
M=F]2!\):3B#*,N\]0HP8"<",TBW6MHT2U^'?;7]IYW)DVJIYL&(DL3O!#Q:#
M:T`;0`)`<#HO+_IWW3`NV6PHLFM`0._?;__0+^'?XN_C_]1OU7_6C]>?_]BO
MV;_:S]O?W._=_QZ&$X$"`/!P```#`!`0``````,`$1```````P"`$/____]`
M``<P(!B^&3*%O@%```@P(!B^&3*%O@$+``"`""`&``````#`````````1@``
M```#A0````````,``H`((`8``````,````````!&`````!"%`````````P`%
M@`@@!@``````P````````$8`````4H4``+<-```>`"6`""`&``````#`````
M````1@````!4A0```0````0````X+C```P`F@`@@!@``````P````````$8`
M`````84````````+`"^`""`&``````#`````````1@`````.A0````````,`
M,(`((`8``````,````````!&`````!&%`````````P`R@`@@!@``````P```
M`````$8`````&(4````````>`$&`""`&``````#`````````1@`````VA0``
M`0````$`````````'@!"@`@@!@``````P````````$8`````-X4```$````!
M`````````!X`0X`((`8``````,````````!&`````#B%```!`````0``````
@```>`#T``0````4```!213H@``````,`#33]-P``Z4.4
`
end
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
