Convert number (type:decimal prec:13 scale:4) to a string in pervasive

glenn_r
glenn_r used Ask the Experts™
on
I'm working with pervasive 7.9 and trying to query data into an ado.net dataset.
1. With this version of pervasive how do you Convert number (type:decimal prec:13 scale:4) to a string? SELECT SOMECONVERTToSTringFUNTION(column) AS "quantity" FROM Table

2. I'm trying to fill an ado.net dataset with table where the above decimal column is throwing an exception "input string was not in a correct format". I'll try to convert to a string if someone comes up with that function or does anyone know how to solve this issue?

Thanks,
Glenn
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try

SELECT CONVERT(column, SQL_CHAR) AS "quantity" FROM Table

The solution offered raised from Pervasive documantation, so it should work.
Hmm... Valued as C grade...  I would appreciate to know what was wrong on that solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial