X
xiaoywh
Unregistered / Unconfirmed
GUEST, unregistred user!
时间:今天
地点:DELPHI+PARDOX
人物:QUERY1+TUpdateSQL组合
起因:
if query1.Active then
begin
query1.edit;
UpdateSQL1.Apply(ukModify);
end;
!!!!“at beginning of table”
线索:
TQUERY1.SQL=以下
SELECT sbbm, c_10_1, c_10_2, c_10_3, c_10_4, c_10_5, c_10_6, c_10_7, c_10_8, c_10_9, c_10_10, c_10_11, c_10_12, c_10_13, c_10_14, c_10_15, c_10_16, c_10_17, c_10_18, c_10_19, c_10_20, c_20_1, c_20_2, c_20_3, c_20_4, c_20_5, c_20_6, c_20_7, c_20_8, c_20_9, c_20_10, c_20_11, c_20_12, c_20_13, c_20_14, c_20_15, c_20_16, c_20_17, c_20_18, c_20_19, c_20_20, c_40_1, c_40_2, c_40_3, c_40_4, c_40_5, c_40_6, c_40_7, c_40_8, c_40_9, c_40_10, c_100_1, c_100_2, c_100_3, n_1, n_2, n_3, n_4, n_5, n_6, n_7, n_8, n_9, n_10, n_11, n_12, n_13, n_14, n_15, dec_1, dec_2, dec_3, dec_4, dec_5, dec_6, dec_7, dec_8, dec_9, dec_10, dec_11, dec_12, d_1, d_2, d_3, d_4, d_5, d_6, d_7, d_8
FROM tab_sb_sbmxb WHERE sbbm =a_sbbm
TUpdateSQL.ModifySQL=以下
update tab_sb_sbmxb
set
c_10_1 = :c_10_1,
c_10_2 = :c_10_2,
c_10_3 = :c_10_3,
c_10_4 = :c_10_4,
c_10_5 = :c_10_5,
c_10_6 = :c_10_6,
c_10_7 = :c_10_7,
c_10_8 = :c_10_8,
c_10_9 = :c_10_9,
c_10_10 = :c_10_10,
c_10_11 = :c_10_11,
c_10_12 = :c_10_12,
c_10_13 = :c_10_13,
c_10_14 = :c_10_14,
c_10_15 = :c_10_15,
c_10_16 = :c_10_16,
c_10_17 = :c_10_17,
c_10_18 = :c_10_18,
c_10_19 = :c_10_19,
c_10_20 = :c_10_20,
c_20_1 = :c_20_1,
c_20_2 = :c_20_2,
c_20_3 = :c_20_3,
c_20_4 = :c_20_4,
c_20_5 = :c_20_5,
c_20_6 = :c_20_6,
c_20_7 = :c_20_7,
c_20_8 = :c_20_8,
c_20_9 = :c_20_9,
c_20_10 = :c_20_10,
c_20_11 = :c_20_11,
c_20_12 = :c_20_12,
c_20_13 = :c_20_13,
c_20_14 = :c_20_14,
c_20_15 = :c_20_15,
c_20_16 = :c_20_16,
c_20_17 = :c_20_17,
c_20_18 = :c_20_18,
c_20_19 = :c_20_19,
c_20_20 = :c_20_20,
c_40_1 = :c_40_1,
c_40_2 = :c_40_2,
c_40_3 = :c_40_3,
c_40_4 = :c_40_4,
c_40_5 = :c_40_5,
c_40_6 = :c_40_6,
c_40_7 = :c_40_7,
c_40_8 = :c_40_8,
c_40_9 = :c_40_9,
c_40_10 = :c_40_10,
c_100_1 = :c_100_1,
c_100_2 = :c_100_2,
c_100_3 = :c_100_3,
n_1 = :n_1,
n_2 = :n_2,
n_3 = :n_3,
n_4 = :n_4,
n_5 = :n_5,
n_6 = :n_6,
n_7 = :n_7,
n_8 = :n_8,
n_9 = :n_9,
n_10 = :n_10,
n_11 = :n_11,
n_12 = :n_12,
n_13 = :n_13,
n_14 = :n_14,
n_15 = :n_15,
dec_1 = :dec_1,
dec_2 = :dec_2,
dec_3 = :dec_3,
dec_4 = :dec_4,
dec_5 = :dec_5,
dec_6 = :dec_6,
dec_7 = :dec_7,
dec_8 = :dec_8,
dec_9 = :dec_9,
dec_10 = :dec_10,
dec_11 = :dec_11,
dec_12 = :dec_12,
d_1 = :d_1,
d_2 = :d_2,
d_3 = :d_3,
d_4 = :d_4,
d_5 = :d_5,
d_6 = :d_6,
d_7 = :d_7,
d_8 = :d_8
where
sbbm = :OLD_sbbm
受害人及现状:救我!!!!这段程序尝经通过过,但下午就成了BUG,救我。。。。。
地点:DELPHI+PARDOX
人物:QUERY1+TUpdateSQL组合
起因:
if query1.Active then
begin
query1.edit;
UpdateSQL1.Apply(ukModify);
end;
!!!!“at beginning of table”
线索:
TQUERY1.SQL=以下
SELECT sbbm, c_10_1, c_10_2, c_10_3, c_10_4, c_10_5, c_10_6, c_10_7, c_10_8, c_10_9, c_10_10, c_10_11, c_10_12, c_10_13, c_10_14, c_10_15, c_10_16, c_10_17, c_10_18, c_10_19, c_10_20, c_20_1, c_20_2, c_20_3, c_20_4, c_20_5, c_20_6, c_20_7, c_20_8, c_20_9, c_20_10, c_20_11, c_20_12, c_20_13, c_20_14, c_20_15, c_20_16, c_20_17, c_20_18, c_20_19, c_20_20, c_40_1, c_40_2, c_40_3, c_40_4, c_40_5, c_40_6, c_40_7, c_40_8, c_40_9, c_40_10, c_100_1, c_100_2, c_100_3, n_1, n_2, n_3, n_4, n_5, n_6, n_7, n_8, n_9, n_10, n_11, n_12, n_13, n_14, n_15, dec_1, dec_2, dec_3, dec_4, dec_5, dec_6, dec_7, dec_8, dec_9, dec_10, dec_11, dec_12, d_1, d_2, d_3, d_4, d_5, d_6, d_7, d_8
FROM tab_sb_sbmxb WHERE sbbm =a_sbbm
TUpdateSQL.ModifySQL=以下
update tab_sb_sbmxb
set
c_10_1 = :c_10_1,
c_10_2 = :c_10_2,
c_10_3 = :c_10_3,
c_10_4 = :c_10_4,
c_10_5 = :c_10_5,
c_10_6 = :c_10_6,
c_10_7 = :c_10_7,
c_10_8 = :c_10_8,
c_10_9 = :c_10_9,
c_10_10 = :c_10_10,
c_10_11 = :c_10_11,
c_10_12 = :c_10_12,
c_10_13 = :c_10_13,
c_10_14 = :c_10_14,
c_10_15 = :c_10_15,
c_10_16 = :c_10_16,
c_10_17 = :c_10_17,
c_10_18 = :c_10_18,
c_10_19 = :c_10_19,
c_10_20 = :c_10_20,
c_20_1 = :c_20_1,
c_20_2 = :c_20_2,
c_20_3 = :c_20_3,
c_20_4 = :c_20_4,
c_20_5 = :c_20_5,
c_20_6 = :c_20_6,
c_20_7 = :c_20_7,
c_20_8 = :c_20_8,
c_20_9 = :c_20_9,
c_20_10 = :c_20_10,
c_20_11 = :c_20_11,
c_20_12 = :c_20_12,
c_20_13 = :c_20_13,
c_20_14 = :c_20_14,
c_20_15 = :c_20_15,
c_20_16 = :c_20_16,
c_20_17 = :c_20_17,
c_20_18 = :c_20_18,
c_20_19 = :c_20_19,
c_20_20 = :c_20_20,
c_40_1 = :c_40_1,
c_40_2 = :c_40_2,
c_40_3 = :c_40_3,
c_40_4 = :c_40_4,
c_40_5 = :c_40_5,
c_40_6 = :c_40_6,
c_40_7 = :c_40_7,
c_40_8 = :c_40_8,
c_40_9 = :c_40_9,
c_40_10 = :c_40_10,
c_100_1 = :c_100_1,
c_100_2 = :c_100_2,
c_100_3 = :c_100_3,
n_1 = :n_1,
n_2 = :n_2,
n_3 = :n_3,
n_4 = :n_4,
n_5 = :n_5,
n_6 = :n_6,
n_7 = :n_7,
n_8 = :n_8,
n_9 = :n_9,
n_10 = :n_10,
n_11 = :n_11,
n_12 = :n_12,
n_13 = :n_13,
n_14 = :n_14,
n_15 = :n_15,
dec_1 = :dec_1,
dec_2 = :dec_2,
dec_3 = :dec_3,
dec_4 = :dec_4,
dec_5 = :dec_5,
dec_6 = :dec_6,
dec_7 = :dec_7,
dec_8 = :dec_8,
dec_9 = :dec_9,
dec_10 = :dec_10,
dec_11 = :dec_11,
dec_12 = :dec_12,
d_1 = :d_1,
d_2 = :d_2,
d_3 = :d_3,
d_4 = :d_4,
d_5 = :d_5,
d_6 = :d_6,
d_7 = :d_7,
d_8 = :d_8
where
sbbm = :OLD_sbbm
受害人及现状:救我!!!!这段程序尝经通过过,但下午就成了BUG,救我。。。。。