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

glenn_r used Ask the Experts™
I'm working with pervasive 7.9 and trying to query data into an 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 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?

Watch Question

Do more with

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

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