I have been having difficulty finding a solution to a data-type conversion for an Oracle number (x,x). Each time I reference it, it displays as a 0. Does anyone have any ideas?
Do a TO_CHAR() on the column, eg, SELECT TO_CHAR(id) AS id FROM table.<BR><BR>To avoid having to do this, quit using that manky Microsoft driver :) We had this problem until we switched to Oracle's driver.<BR>
Your suggestion doesn't work. I already tried it. Can you think of anything else?????