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: [email protected] 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: [email protected] 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]
