hi Jeff
i've created a reduced .cgi (see attached - please don't hurt me about
this...). i'm currently out of office and have no MsSQL next to me.
1. create a Table "Test1",
2. create "TypeName" - varchar - NOT NULL - Primary
3. create "ProvLevel1" - money - default "0.00"
4. create "ProvLevel2" - money - default "0.00"
5. create "Action" - tinyint - default 0
INSERT INTO Test1 (TypeName,ProvLevel1,ProvLevel2,Action) VALUES ('A',0,0,0)
INSERT INTO Test1 (TypeName,ProvLevel1,ProvLevel2,Action) VALUES ('B',0,0,0)
INSERT INTO Test1 (TypeName,ProvLevel1,ProvLevel2,Action) VALUES ('C',0,0,0)
INSERT INTO Test1 (TypeName,ProvLevel1,ProvLevel2,Action) VALUES ('D',0,0,0)
INSERT INTO Test1 (TypeName,ProvLevel1,ProvLevel2,Action) VALUES ('E',0,0,0)
now - try to change the values... and press save. you will get the error (i
haven't fully tested this small example - out of office). additional to this
case i have moved to DBD-ODBC v1.04 today and DBI v1.34 - but the problem is
still here.
Alex
begin 666 money_test.cgi
M(R%C.B]P<F]G<F%M;64O<&5R;"]B:6XO<&5R;"YE>&[EMAIL PROTECTED]<-"@T*=7-E('-T
M<FEC=#L)"0D)(R!A8W1I=F%T92!F;W(@<')O9W)A;6UI;F<O9&5B=6=G:6YG
M(&]N;'D-"G5S92!W87)N:6YG<SL)"0D)(R!A8W1I=F%T92!F;W(@<')O9W)A
M;6UI;F<O9&5B=6=G:6YG(&]N;'D-"G5S92!#1TDZ.D-A<G @<7<H9F%T86QS
M5&]"<F]W<V5R*3L)(R!A8W1I=F%T92!F;W(@<')O9W)A;6UI;F<O9&5B=6=G
M:6YG(&]N;'D-"@T*=7-E($-'22 G<&%R86TG+"=R961I<F5C="<[#0IU<V4@
M1$)).PT*#0HC(&-O;F9I9R!V87)I86)L97,-"F]U<B D9'-N/2=D<VXG.PD)
M"0DC($1A=&%B87-E([EMAIL PROTECTED];W5R("1D8G5S97(])W5S97(G.PD)"2,@1&%T
M86)A<[EMAIL PROTECTED]<@T*;W5R("1D8G!A<W,])W!A<W,G.PD)"2,@1&%T86)A<V4@
M4&%S<W=O<F0-"F]U<B D9&)T86)L93TG=&5S=#$G.PD)"2,@4')O=E1A8FQE
M#0H-"B,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,-"@T*)'P],3L-"@T*;7D@)&1B:" ]($1"22T^8V]N;F5C
M="@B1$)).D]$0D,Z)&1S;B(L("1D8G5S97(L("1D8G!A<W,L('[EMAIL PROTECTED]&%I;G0@
M/3XQ('TI('Q\(&1I92 B)$1"23HZ97)R<W1R(CL-"[EMAIL PROTECTED]/GM286ES945R
M<F]R?2 ](#$["0DC(&%C=&EV871E(&9O<B!P<F]G<F%M;6EN9R]D96)U9V=I
M;F<@;VYL>0T*)&1B:"T^>U!R:6YT17)R;W)](#T@,3L)"2,@86-T:79A=&4@
M9F]R('!R;V=R86UM:6YG+V1E8G5G9VEN9R!O;FQY#0HD9&)H("T^('M,;VYG
M4F5A9$QE;GT@/2 Q,# P,# [#0HD9&)H("T^('M,;VYG5')U;F-/:WT@/2 P
M.PT*(R1D8F@@+3X@>V]D8F-?9&5F875L=%]B:6YD7W1Y<&5](#T@,3([(",@
M4U%,7U9!4D-(05(-"@T*#0IM>2 D86-T:6]N/7!A<F%M*"=!0U1)3TXG*2!\
M?" G)SL-"FEF("@D86-T:6]N/7XO6UY<=UTO*2![(&1I92 B8F%D(&-H87)S
M(&EN('!A<F%M971E<B$B('T-"@T*:68)*"1A8W1I;[EMAIL PROTECTED]@)U-!5D5?4%)/
M5B<I"7LF<V%V95]P<F]V.WT-"F5L<V4@"0D)"0E[)G!R;W8[?0T*#0H-"G-U
M8B!P<F]V('L-"@EP<FEN=" B8V]N=&5N="UT>7!E.B!T97AT+VAT;6Q<;EQN
M(CL-"@T*"7!R:6YT("(\2'1M;#X\2&5A9#X\5&ET;&4^5&ET;&4\+U1I=&QE
M/CPO2&5A9#Y<;B([#0H)<')I;G0@(CQ"3T19/CQ#14Y415(^/$)2/CQ"4CY<
M;EQN7&XB.PT*"7!R:6YT("(\1D]232!.04U%/[EMAIL PROTECTED]/6UO;F5Y7W1E
M<W0N8V=I($U%5$A/1#U03U-4/CQ)3E!55"!465!%/4A)1$1%3B!.04U%/4%#
M5$E/3B!604Q513U3059%7U!23U8^/%1!0DQ%($)/4D1%4CTP($)'0T],3U(]
M(T1$1$1$1#Y<;B([#0H)<')I;G0@(CQ44CX\5$0^/$(^)FYB<W [5&5X="9N
M8G-P.SPO0CX\+U1$/CQ41#X\0CXF;F)S<#M,979E;#$F;F)S<#L\+T(^/"]4
M1#X\5$0^/$(^)FYB<W [3&5V96PR)FYB<W [/"]"/CPO5$0^/%1$/B9N8G-P
M.SPO5$0^/"]44CY<;B([#0H-"@DC($US4U%,#0H);7D@)'-T:# @/2 D9&)H
M+3YP<F5P87)E*"(-"@D)"[EMAIL PROTECTED])"0D)"4E33E5,3"A4>7!E3F%M
M92PG)[EMAIL PROTECTED],@5'EP94YA;64L#0H)"0D)"4E33E5,3"A0<F]V3&5V96PQ+# N
M,# I($%3(%!R;W9,979E;#$L#0H)"0D)"4E33E5,3"A0<F]V3&5V96PR+# N
M,# I($%3(%!R;W9,979E;#(L#0H)"0D)"4E33E5,3"A!8W1I;VXL,"[EMAIL PROTECTED],@
M06-T:6]N#0H)"0D)1E)/32 D9&)T86)L92!W:71H("A.;TQO8VLI( T*"0D)
M"4]21$52($)9($%C=&EO;@T*"0D)"2(I.PT*"6UY("1R=C @/2 D<W1H,"T^
[EMAIL PROTECTED](" )=VAI;&[EMAIL PROTECTED]&UY("1R968P(#T@)'-T:# M/F9E=&-H
M<F]W7VAA<VAR968H*2D@>PT*"0EI9B H)')E9C M/GLG06-T:6]N)WT]/3 I
M('L-"@D)"7!R:6YT("(\5%(^/%1$/B9N8G-P.R1R968P+3Y[)U1Y<&5.86UE
M)WTF;F)S<#L\+U1$/CQ41#XF;F)S<[EMAIL PROTECTED](%-)6D4]
M-2!.04U%/2=,159%3#%?)')E9C M/GLG5'EP94YA;64G?2<@5D%,544])R1R
M968P+3Y[)U!R;W9,979E;#$G?2<^)FYB<W [/"]41#X\5$0^)FYB<W [/$E.
M4%54(%194$4]5$585"!325I%/[EMAIL PROTECTED])U1Y
M<&5.86UE)WTG(%9!3%5%/2<D<F5F,"T^>R=0<F]V3&5V96PR)WTG/B9N8G-P
M.SPO5$0^/%1$/B9N8G-P.SPO5$0^/"]44CY<;B([#0H)"[EMAIL PROTECTED])
M"0EP<FEN=" B/%12/CQ41#XF;F)S<#L\8CY6.CPO8CX@)')E9C M/GLG5'EP
M94YA;64G?29N8G-P.SPO5$0^/%1$/B9N8G-P.SQ)3E!55"!465!%/51%6%0@
M4TE:13TU($Y!344])TQ%5D5,,5\D<F5F,"T^>R=4>7!E3F%M92=])R!604Q5
M13TG)')E9C M/GLG4')O=DQE=F5L,2=])SXF;F)S<#L\+U1$/CQ41#XF;F)S
M<[EMAIL PROTECTED](%-)6D4]-2!.04U%/2=,159%3#)?)')E9C M
M/GLG5'EP94YA;64G?2<@5D%,544])R1R968P+3Y[)U!R;W9,979E;#(G?2<^
M)FYB<W [/"]41#X\5$0^)FYB<W [/"]41#X\+U12/EQN(CL-"@D)?0T*"7T-
M"@DD<W1H,"T^9FEN:7-H*"D[#0H-"@EP<FEN=" B/"]404),13X\0E(^/$)2
M/CQ)3E!55"!465!%/5-50DU)5"!604Q513TG4V%V92<^/"]&3U)-/B([#0H)
M<')I;G0@(CPO0T5.5$52/CPO0D]$63X\+TA434P^(CL-"GTC+R\O#0H-"@T*
M<W5B('-A=F5?<')O=B![#0H)"0D)#0H);7D@)'-T:#@@/2 D9&)H+3YP<F5P
M87)E*")[EMAIL PROTECTED],*%1Y<&5.86UE+"<G*2!!4R!4>7!E3F%M92!&
M4D]-("1D8G1A8FQE('=I=&@@*$YO3&]C:RDB*3L@(R!-<U-13 T*"6UY("1R
M=C@@/2 D<W1H."[EMAIL PROTECTED](" )=VAI;&[EMAIL PROTECTED]&UY("1R968X(#T@
M)'-T:[EMAIL PROTECTED]/F9E=&-H<F]W7VAA<VAR968H*2D@>PT*"0D);7D@)&YA;64])')E
[EMAIL PROTECTED]/GLG5'EP94YA;64G?3L-"@D)"6UY("1L979E;#$]<&%R86TH(DQ%5D5,
M,5\D;F%M92(I('Q\("<P)SL-"@D)"2 @("1L979E;#$]?G,O7"PO7"XO:3L-
M"@D)"2 @("1L979E;#$]?G,O6UY<9"Y=+R]I.PT*"0D);7D@)&QE=F5L,CUP
M87)A;[EMAIL PROTECTED]([EMAIL PROTECTED]'P@)S G.PT*"0D)(" @)&QE=F5L,CU^
M<R]<+"]<+B]I.PT*"0D)(" @)&QE=F5L,CU^<R];7EQD+ETO+VD[#0H)"0D-
M"@D)"2,@37-344P-"@D)"6UY("1S=&@Y(#T@)&1B:"T^<')E<&[EMAIL PROTECTED])
M"0D)"[EMAIL PROTECTED])"0D)"0D))&1B=&%B;&[EMAIL PROTECTED])"0D)"[EMAIL PROTECTED])
M"0D)"0D)4')O=DQE=F5L,3U#3TY615)4*&UO;F5Y+#\I+ T*"0D)"0D)"5!R
M;W9,979E;#(]0T].5D525"AM;VYE>2P_*2 -"@D)"0D)"5=(15)%(%1Y<&5.
M86UE/3\-"@D)"0D)(BD[#0H)"0EM>2 D<G8Y/21S=&@Y+3YE>&5C=71E*"1L
M979E;#$L)&QE=F5L,BPD;F%M92D[#0H)"0DC)'-T:#DM/F)I;F1?<&%R86TH
M;BQU;F1E9BQ344Q?5D%20TA!4BD[(",@=&5L;"!$0D0M3T1"0R!T:&ES(&ES
M(&[EMAIL PROTECTED]<@T*"0D)(R1S=&@Y+3YF:6YI<[EMAIL PROTECTED]"@E]#0H))'-T:[EMAIL
PROTECTED]/F9I
M;FES:"@I.PT*#0H);7D@)&QO8V%T:6]N/2(N+VUO;F5Y7W1E<W0N8V=I(CL-
M"@EP<FEN="!R961I<F5C="@M=7)I/3XD;&]C871I;VXI.PT*"7!R:6YT(")#
M;VYT96YT+51Y<&4Z('1E>'0O:'1M;%QN(CL-"@EP<FEN=" B7&XB.PT*"7!R
M:6YT("(\2%1-3#X\2$5!1#X\5$E43$4^4F5D:7)E8W0\+U1)5$Q%/CPO2$5!
M1#X\0D]$63XB.PT*"7!R:6YT("))9B!Y;W5R(&)R;W=S97(@9&]E<R!N;W0@
M<W5P<&]R="!R961I<F5C=&EO;BP@<&QE87-E(&-L:6-K("([#0H)<')I;G0@
M(CQ!($A2148]7"(D;&]C871I;VY<(CYH97)E/"]!/B([#0H)<')I;G0@(CPO
M0D]$63X\+TA434P^(CL-"GTC+R\O#0H-"[EMAIL PROTECTED]/F1I<V-O;FYE8W0H*3L-
!"@``
`
end
