Eric ten Westenend wrote:
Hi
if i run the query SELECT B FROM TO_DP(:TRANSACTIONTIMEDP)
and have 0.25 as the parameter, the procedure return 25 where i expected 0.25
In holland i have to enter 0,25 not 0.25 could this be an issue Jeff?
Eric
yes because it is going to use the default decimal separator which for you I
suspect is a , not a .. This is a client side encoding of the parameter from a
string to a double before sending to the server and IBConsole is a Delphi app so
by default is going to use your system's decimal separator.
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Connect with Us