ask again, how to use Record Object

  • Thread starter Thread starter help
  • Start date Start date
H

help

thank you for answer this question

please access this url:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;248255

in the example code ,microsoft can use the Recordset denote a website

rs.Open "test.txt", "Provider=MSDAIPP.DSO;" & _
"Data Source=http://localhost/test", _
adOpenForwardOnly, adLockReadOnly, adCmdTableDirect

and user these code

'Read the current row of the Recordset into a Record
rec.Open rs

if i can use recordset open a table . i can reason out use a Record denote
a Row,is it right?
 
rs.Open "test.txt", "Provider=MSDAIPP.DSO;" & _
"Data Source=http://localhost/test", _
adOpenForwardOnly, adLockReadOnly, adCmdTableDirect

and user these code

'Read the current row of the Recordset into a Record
rec.Open rs

if i can use recordset open a table . i can reason out use a Record denote
a Row,is it right?
Click to expand...

No. There is no "record" object.

You would need to move through the Recordset, one record at a time.
For example, after rec.Open rs you could have code like:

Do Until rs.EOF
Debug.Print rs.Fields("SomeFieldName"), rs.Fields("anotherfield")
rs.Move 1 ' move to the next record
Loop
 
help said:
thank you for answer this question

please access this url:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;248255

in the example code ,microsoft can use the Recordset denote a website

rs.Open "test.txt", "Provider=MSDAIPP.DSO;" & _
"Data Source=http://localhost/test", _
adOpenForwardOnly, adLockReadOnly, adCmdTableDirect

and user these code

'Read the current row of the Recordset into a Record
rec.Open rs

if i can use recordset open a table . i can reason out use a Record
denote a Row,is it right?
Click to expand...

See KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;248144
PRB: Error: "Not capable" When Opening a Record Object Off a
Recordset

"The ADO documentation states that an ADO record can represent a row in
a Recordset. However, the underlying OLE DB provider must support the
ADO Record object. For example, the Microsoft OLE DB Provider for
Internet Publishing supports the ADO Record object. "

The Microsoft Jet OLEDB provider doesn't support the ADO Record object,
so you can't use it with a Jet table.
 
thank you very much!


Dirk Goldgar said:
See KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;248144
PRB: Error: "Not capable" When Opening a Record Object Off a
Recordset

"The ADO documentation states that an ADO record can represent a row in
a Recordset. However, the underlying OLE DB provider must support the
ADO Record object. For example, the Microsoft OLE DB Provider for
Internet Publishing supports the ADO Record object. "

The Microsoft Jet OLEDB provider doesn't support the ADO Record object,
so you can't use it with a Jet table.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top