Hi,

The DECLARE VARIABLE statements are shown below :-

1) DECLARE VARIABLE myMoney Double Precision;

2) DECLARE VARIABLE MoneyInStr Varchar(50);

ivy.

----- Original Message -----
From: Ivy
To: firebird-support@yahoogroups.com
Sent: Friday, March 23, 2012 11:18 AM
Subject: Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure


Hi,

The DECLARE VARIABLE statements are shown below :-

1) DECLARE VARIABLE Double Precision;

2) DECLARE VARIABLE MoneyInStr Varchar(50);

ivy.


----- Original Message -----
From: Milan Babuskov
To: firebird-support@yahoogroups.com
Sent: Thursday, March 22, 2012 7:00 PM
Subject: Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure



Ivy wrote:
> 1) I have a double precision variable ( e.g. myMoney ) which after some calculation, it ends up with figure -0.00000199868555.
> 2) When I want to assign this value to a varchar field ( e.g. MoneyInStr) , I do the below statement :-
>
> MoneyInStr = myMoney;

What are the types of MoneyInStr and myMoney. Can you show the DECLARE
VARIABLE statements?

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================





[Non-text portions of this message have been removed]