|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
In debug mode I have traced step by step every line and there I have got the values that I need. But when the update of the record has been done, different values has been updated then the ones I have got in the debug mode.
How can I correct that and what did happen with those records ? |
|
#2
|
||||
|
||||
|
Have your program output the actual insert/update query just before issueing it to database and check that one.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Quote:
Thanks for helping me, but here is a larger explanation. I have one of many stored procedures in which this has happened. Three local variables (L_neto,L_bruto,L_minrad) are computed correctly (8222, 11666, 1456) but when I do this in the procedure update table_name set neto = :L_neto, bruto = :L_bruto, minrad = :L_minrad where /*condition for update*/ then in the table are updated wrong values (8202, 11637, 1432). This is the only update or insert part of all procedures for this table. If I omit this update then inital values are set to 0 and everything is OK. I have to do this update 250 times for different input parameters, and this doesn't happen for every 250 records but only for some. I hope you understood me now, and once again thans for helping me. What could I do ? |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Different values computed from the ones that are commited ??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|