firebird-support - Ynt: [firebird-support] Update table column from another table

Subject	Ynt: [firebird-support] Update table column from another table
Author	Sonya Blade
Post date	2016-01-02T15:28:22Z

Yes I tried that it wasn't selecting at all, it was due to the floating point comparison. It seems that hit the wall about that

floating point precision I eliminate that with subtracting the coumns and taking the absolute value if it is less than 0.000001 epsilon

reference value.

It worked for now, but I'd like to know what is the decent way of solving such issues.

Regards,

hi,

did you try select instead of update to see if select return all records which you try to update?

regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: "Sonya Blade sonyablade2010@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 02.01.2016 08:24 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Update table column from another table

Dear All,

I have difficulty with updating column records of one table from another table columns, which have common columns for relation.
Executed query is as follow :

update elements E set E.END_I = (select n.node_num from nodes N
where (E.X_I =N.XI and E.Y_I = N.YI and E.Z_I=N.ZI) )
where exists (select 1 from nodes N where (E.X_I =N.XI and E.Y_I = N.YI and E.Z_I=N.ZI))

The problem with that is , not all the columns of Elements are updated, only one portion is correctly updated and rest
remains intact. I tried to follow instructions here http://www.firebirdfaq.org/faq323/ but without success. I use old version of
Firebird which is ver 2.1.

What is rong with the code above,

Regards,