Finding expression field
Recently I create a recordset based on a query. The code looks like this
Dim StrSQL as String
Dim Rst as ADODB.Recordset
StrSQL="SELECT (Quantity * UnitPrice) AS Total FROM Orders"
I want to dynamically filter the record based on the query above without
firstly knowing the name of the fields so that the query will look something
like this :
StrSQL="SELECT (Quantity * UnitPrice) AS Total FROM Orders WHERE (Quantity
* UnitPrice) > 1000".
Is there any recordset properties or any workaround at all that returns
the field expression (Quantity * UnitPrice), because if we use Rst.Fields(0).Name,
it returns 'Total' ?.
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