rs.EOF Meaning

[jo15765]

I understand that this piece of syntax has a select statement and it is set to run the select statement. BUT, I want to granularly break it down a step further and fully understand what each line is doing. Is their a check in place that checks if the data already exists?

queryTorun = "Select userID, Salesmanager from tableSalesInfo where userid = '" & textbox1 & "' AND Salesmanager = '" & textbox2 & "';"
Set rs = dbConn.Execute(queryTorun)
If (rs.EOF) Then
  dbConn.Execute ("Insert Into tableSalesInfo Values ('" & textbox1 & "', '" & textbox2 & "');")
End If

[pbaldy]

The EOF line checks to see whether any records were returned.

[ssanfu]

If you are using DAO, the code snippet won't (shouldn't) execute.

"EOF" means End of File, ie past the last record in the recordset. If no records are returned, then .BOF will be TRUE and .EOF will be TRUE.

In this line,

Set rs = dbConn.Execute(queryTorun)

"Execute" is for action queries ("Insert INTO", "Delete"), not "Select" statements.


I would use

Set rs = dbConn.OpenRecordset(queryTorun)

This line

dbConn.Execute ("Insert Into tableSalesInfo Values ('" & textbox1 & "', '" & textbox2 & "');")

tells me that there are only two field in the table because the field names are not in the statement.
Normally the statement would be

dbConn.Execute ("Insert Into tableSalesInfo( userid, Salesmanager) Values ('" & textbox1 & "', '" & textbox2 & "');")

Remember, I am talking about DAO. I don't use ADO.


My $0.02.....