Forum Post: odbc IsNumeric function

  • Thread starter Thread starter scottemick
  • Start date Start date
Status
Not open for further replies.
S

scottemick

Guest
I am writing reports against the SQL Engine for 10.1C and have a situation where some money amounts are stored in a varchar field instead of a numeric field and when I try to convert this a numeric, I get an error because there is something non-numeric somewhere. I tried the to_number function and also the odbc {fn convert} and {fn cast} functions, all give me the same error. I cannot find any built-in isnumeric function in either progress or odbc. I did find an isnumeric.p abl file that I was able to compile and can use inside progress iteself, but I cannot figure out how to call it from odbc. Any information on how I can check for numerics or do a trycast, or run abl from sql would be greatly appreciated.

Continue reading...
 
Status
Not open for further replies.
Back
Top