[firebird-support] Update table column from another table

[Sonya Blade sonyablade2...@hotmail.com [firebird-support]]

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,

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

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

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 sonyablade2...@hotmail.com [firebird-support]" 
 
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,




 

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

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Floating point values are not exact values, there is not guarantee.

If you need exact values, use NUMERIC or DECIMAL instead.

Greetings.

Walter.


On Sat, Jan 2, 2016 at 11:28 AM, Sonya Blade sonyablade2...@hotmail.com
[firebird-support]  wrote:

>
>
>
> 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.01 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 sonyablade2...@hotmail.com [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,
>
> 
>

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

[Sonya Blade sonyablade2...@hotmail.com [firebird-support]]

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.01 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 wiadomosc 
Od: "Sonya Blade sonyablade2...@hotmail.com [firebird-support]" 

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,

[firebird-support] Firebird Download Malware

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello.

I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials 
detected it as a malware.

Did anybody face the same problem?

-- 


Atenciosamente,

Hugo Eyng







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/