Update calculated fields.
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL