What are Recordsets in VB6 ?

Answer 1

look in Mastering VB6 BOOK.

Answer 2

Definition of: recordset

The answer to a database query delivered through Microsoft's ActiveX Data Object (ADO) interface. It is a COM object that contains the query results, which is a group of records. See ADO.

Answer 3

A recordset is one of the two critical ADO objects anyone doing database work is going to use. You use an ADODB.Connection object to gain access to the database and execute SQL commands against it, and you use the ADODB.Recordset to look at the return values of your SQL statement.

The use of a recordset in code would look like this:

Function GetName(CustID as Integer) as String
'get the name of the customer
Dim SQL as string
SQL = "SELECT Name from Foo WHERE CustID = " _
& CustID
Dim Conn as new ADODB.Connection
Dim Rec as new ADODB.Recordset
Conn.Open "MyOleDbConnectionString"
Set Rec = Conn.Execute(SQL)
if Rec.EOF = False then
GetName = Rec("Name")
End if
Rec.Close
Conn.Close
End Function

Answer 4

Record sets is the functionality that allows your programming interface to correspond\access tables within a database.

Hope this helps...

Answer 5

It is entities in correct theoretical parlance, I might been off the mark here, verify it yourself.

Answer 6

it's for database programming.

Answer 7

Here you go
http://msdn2.microsoft.com/en-us/vbrun/default.aspx
///