Sanya
User
Senior Boarder
| Posts: 33 |   |
Karma: 0
|
|
ADUpdateSQL потерял SEt
|
|
Posted: 2008/02/26 05:39 |
|
|
|
|
Есть компонент ADUpdateSQL Свойство ModifySQL =
UPDATE basepost.id_ob
SET id = :NEW_id, nom = :NEW_nom, name = :NEW_name, id_tip = :NEW_id_tip,
id_group = :NEW_id_group, id_class = :NEW_id_class, index = :NEW_index,
id_city = :NEW_id_city, address = :NEW_address, id_region = :NEW_id_region,
description = :NEW_description, contact = :NEW_contact,
tel1 = :NEW_tel1, tel2 = :NEW_tel2, fax = :NEW_fax, email = :NEW_email,
pass = :NEW_pass, kod = :NEW_kod, client_ok = :NEW_Client_OK,
guard_ob = :NEW_guard_ob, guard_ob_edit = :NEW_guard_ob_edit,
sost_ob = :NEW_sost_ob, data_time_create = :NEW_data_time_create,
data_time_edit = :NEW_data_time_edit, user_edit = :NEW_user_edit,
journal = :NEW_journal, user_resp = :NEW_user_resp, id_foto = :NEW_id_foto,
id_plan_ob = :NEW_id_plan_ob, mold = :NEW_mold, mold_n_del = :NEW_mold_n_del,
ch_main = :NEW_ch_main, ch_slave = :NEW_ch_slave, nom_main = :NEW_nom_main,
nom_slave = :NEW_nom_slave, nom_main_nom = :NEW_nom_main_nom,
map_x = :NEW_map_x, map_y = :NEW_map_y, rez1_int = :NEW_rez1_int,
rez2_int = :NEW_rez2_int, rez3_int = :NEW_rez3_int, rez4_int = :NEW_rez4_int,
rez1_dt = :NEW_rez1_dt, rez2_dt = :NEW_rez2_dt, rez1_vc_45 = :NEW_rez1_vc_45,
rez2_vc_45 = :NEW_rez2_vc_45, rez3_vc_45 = :NEW_rez3_vc_45,
rez4_vc_45 = :NEW_rez4_vc_45, rez1_vc_128 = :NEW_rez1_vc_128,
rez2_vc_128 = :NEW_rez2_vc_128, rez1_vc_256 = :NEW_rez1_vc_256,
rez1_vc_512 = :NEW_rez1_vc_512, rez1_char_16 = :NEW_rez1_char_16,
rez2_char_16 = :NEW_rez2_char_16, rez5_int = :NEW_rez5_int,
rez6_int = :NEW_rez6_int, rez7_int = :NEW_rez7_int, rez8_int = :NEW_rez8_int
WHERE id = :OLD_id
|
На практите в при выполнении редактирования в лог файле отоброжается:
UPDATE basepost.id_ob
id_group = 1, id_class = 1, index = NULL,
tel1 = '123 45 89', tel2 = NULL, fax = NULL, email = NULL,
guard_ob = 0, guard_ob_edit = 0,
sost_ob = 1, data_time_create = NULL,
data_time_edit = NULL, user_edit = NULL,
journal = NULL, user_resp = NULL, id_foto = NULL,
id_plan_ob = NULL, mold = 0, mold_n_del = 0,
ch_main = 0, ch_slave = 0, nom_main = NULL,
nom_slave = NULL, nom_main_nom = 0,
map_x = NULL, map_y = NULL, rez1_int = NULL,
rez2_int = NULL, rez3_int = NULL, rez4_int = NULL,
rez1_dt = NULL, rez2_dt = NULL, rez1_vc_45 = NULL,
rez2_vc_45 = NULL, rez3_vc_45 = NULL,
rez4_vc_45 = NULL, rez1_vc_128 = NULL,
rez2_vc_128 = NULL, rez1_vc_256 = NULL,
rez1_vc_512 = NULL, rez1_char_16 = NULL,
rez2_char_16 = NULL, rez5_int = NULL,
rez6_int = 0, rez7_int = 0, rez8_int = 0
WHERE id = 2
|
Должно быть:
UPDATE basepost.id_ob
SET
id_group = 1,
...
|
Вопрос: Куда делся оператор SET?
|
|
