meekee3
12-01-2000, 10:48 AM
I am using a command object and a recordset object to access data in a DB2 database. When I am trying to return a recordset that contains decimal values, I am getting an empty recordset error. I have used the DB2 Command Prompt and ran the querry and was able to retrieve data so I know there is data out there. I have also used this code to retrieve other data like text, so I know my code is O.K.
Is there something special you need to do to format the recordset when trying to retrieve decimal values? I tried using CStr(recordset) but that was giving me a type mismatch error. Any help would be appreciated. Thanks.
Is there something special you need to do to format the recordset when trying to retrieve decimal values? I tried using CStr(recordset) but that was giving me a type mismatch error. Any help would be appreciated. Thanks.