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' ?.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center