cannot add data to a calculated field in a disconnected recordset

[alrightydooda]

VB6.0
SQL Server2000

Hi,

I am trying to add data to a calculated field in a disconnected recordset and i am getting the following error:

"Multiple-step operation generated errors. Check each status value."

Here is the query for the recordset:

SELECT table1.amount_charged, table1.deductible, CAST((amount_charged - deductible) as Numeric) as balance
FROM table1
WHERE table1.code = '0001'

Here is the VB code that is giving the error (falling over on the second line):

rsTables1.addnew
rsTable1.fields("balance").value = 0

I am using MDAC2.8 and my provider is OLEDB.1

We are conerting our oracle database into SQL Server and in oracle you can add data into a caluclated field as shown above.

My question is does anybody know if this is allowed in SQL Server or am i dealing with a configuration problem, maybe I need to use a different provider?

Any help greatly appreciated!