I have a VB6.0 application with Oracle(oo4o 8i).
I use DBGrid and Oracle Data Control.
My table is
My client want the number in DBGrid shown in certain format. For example, number with two decimal points like(11.00).
if I change the ORADC recordsource from
oradcEmp.RecordSource = "select empno, ename, salary from emp "
oradcEmp.RecordSource = "select empno, ename, to_char(salary,'99.00') from emp "
The my recordset become not updatable set. I cannot update DBGrid.
Can someone tell me how to solve this?