Page 1 of 1

Conversion error in routine decimal_from_string

Posted: Thu Jul 23, 2009 7:30 am
by raghu.chandra
Hi,

We are geeting this warning
Conversion error calling conversion routine decimal_from_string data may have been lost.

We want to remove this wariing, need your help for the same.

The code we are using is

StringtoDecimal( SourceCoumn) < 1800

Please help me to remove this warnings
Thanks in advance
Raghuraj

Posted: Thu Jul 23, 2009 7:51 am
by ArndW
Do you want to remove the warning message (job or project level message handler will do that for you) or remove the cause of the problem?

Posted: Fri Jul 24, 2009 1:34 am
by Sreenivasulu
Message handler will do this but its not a complete solution. Message handler just hides the output from the job log. I get a similar error on using strintotimestamp but i do not get this warning on using stringtodate function.

Regards
Sreeni