i'm programming an application on VB6 and SQL Server 7.0 using ADO 2.5.

the problem is the following: i am executing some stored procedures. some
of them return recordsets with calculated fields, and some others execute
union operations. When i get the recordset object in VB i disconect the recordset
and after that i need to update many of the fields, including the calculated
fields to reflect changes on other fields, but the field is not updateable.

does somebody knows a way to retrieve the recordset so i can update such
fields? i've used by now a select into a table and then retrieve the data
from it, but it hangs my server so i don't want to use it any more.

any ideas?