S
Sameer
Hello all,
I am retrieving records from SQL through .NET framework using ADODB.
The code executes without error, but when I debug the code and check
the recordset class, I see an error on two internal fields:
OriginalValue and UnderlyingValue. The error is: error:An exception of
type:{System.Runtime.InteropServices.COMException} occurred.
The code used to retrieve the record is as follows:
Dim rsProducts As ADODB.Recordset
rsProducts = CreateObject("ADODB.RecordSet")
strcmd = "select * from [" & tableName & "] where
product_id='" & productID & "'"
Call rsProducts.Open(strcmd, <Connection string>)
The query executes fine and is able to retrieve the desired records. I
am curious to know why the two internal fields have an error whereas
the rest of the fields are picked up correctly by the query. This is
affecting me at a later stage in the code.
Please let me know.
Thanks,
Sameer
I am retrieving records from SQL through .NET framework using ADODB.
The code executes without error, but when I debug the code and check
the recordset class, I see an error on two internal fields:
OriginalValue and UnderlyingValue. The error is: error:An exception of
type:{System.Runtime.InteropServices.COMException} occurred.
The code used to retrieve the record is as follows:
Dim rsProducts As ADODB.Recordset
rsProducts = CreateObject("ADODB.RecordSet")
strcmd = "select * from [" & tableName & "] where
product_id='" & productID & "'"
Call rsProducts.Open(strcmd, <Connection string>)
The query executes fine and is able to retrieve the desired records. I
am curious to know why the two internal fields have an error whereas
the rest of the fields are picked up correctly by the query. This is
affecting me at a later stage in the code.
Please let me know.
Thanks,
Sameer