Hi
Connecting to postgres through UNIDAC.
Query is taken from DB monitor.
Insert to same table with same fields works fine.
query :
update eeli_1.t1009_packages("t1009_id","fd","td","t1002_id","t0106_id","package_name","start_sn","stop_sn","bar_code","user_id","in_date","comments","unit_name","s_id","pd_id","del_user_id","del_in_date","min_unit_name","code","min_unit_count") set
t1009_id = :t1009_id, fd = :fd, td = :td, t1002_id = :t1002_id, t0106_id = :t0106_id, package_name = :package_name, start_sn = :start_sn, stop_sn = :stop_sn, bar_code = :bar_code, user_id = :user_id, in_date = :in_date, comments = :comments, unit_name = :unit_name, s_id = :s_id, pd_id = :pd_id, del_user_id = :del_user_id, del_in_date = :del_in_date, min_unit_name = :min_unit_name, code = :code, min_unit_count = :min_unit_count
where eeli_id = :eeli_id and fd=:fd and td =:td
get an error.
query looks to be fine. I run this query with parameter array.
with execute(cnt);
thanks
Ilia Chachkunashvili