Conversion error in routine decimal_from_string

raghu.chandra · Post by **raghu.chandra** » Thu Jul 23, 2009 7:30 am

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

ArndW · Post by **ArndW** » Thu Jul 23, 2009 7:51 am

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?

Sreenivasulu · Post by **Sreenivasulu** » Fri Jul 24, 2009 1:34 am

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