Extracting Data from a Recordset

  • Thread starter Thread starter ElenaR
  • Start date Start date
E

ElenaR

I am trying to take data out of a recordset I pulled from
Access (using SQL)

In VB 6, the code looked like:
Variable = Recordset!field_from_access_table
For Example: intActionIdentifier = rsAction!item_identifier

In VB. Net I get the error:
Too many arguments to 'Public Overridable ReadOnly Default
Property Fields() as ADODB.Fields

How do I pull this data without errors?
 
* "ElenaR said:
I am trying to take data out of a recordset I pulled from
Access (using SQL)

In VB 6, the code looked like:
Variable = Recordset!field_from_access_table
For Example: intActionIdentifier = rsAction!item_identifier

In VB. Net I get the error:
Too many arguments to 'Public Overridable ReadOnly Default
Property Fields() as ADODB.Fields
Click to expand...

Did you try it with 'rsAction.Fields(...)'?
 
* said:
I tried intActionIdentifier = rsAction.Fields
(item_identifier). The error: Name 'item_identifier' is
not declared.
Click to expand...

I am not familiar with VB6's recordsets but enclose the
'item_identifier' in double quotes (""").
 
Back
Top