Understanding of database objrs. eof

I took it for granted when I was doing database today! It took an hour to solve the problem. The premise is that when I check a column in the database, I confuse the query column with a known column. I think that no matter which column I enter, this objrs will exist in the database. eof won't be true, and the result cannot be taken for granted! Understanding of objRs. EOF:

I took it for granted when I was doing database today! It took an hour to solve the problem. The premise is that when I check a column in the database, I confuse the query column with a known column. I think that no matter which column I enter, this objrs will exist in the database. eof won't be true, and the result cannot be taken for granted! Understanding of objRs. EOF:

I took it for granted when I was doing database today! It took an hour to solve the problem.

The premise is that when I check a column in the database, I confuse the query column with a known column. I think that no matter which column I enter, this objrs will exist in the database. eof won't be true, and the result cannot be taken for granted!

Understanding of objRs. EOF:

Determines whether the result set is empty. The program will judge based on the known columns you give, rather than the columns to be queried.

For example, the query statement is: strSQL = "SELECT password, identity FROM system user WHERE UserName = '" & UserName &"'"

Enter an account in the account box. If this account exists in the Database, objrs. eof is false; otherwise, it is true.

However, if I enter the columns in the database in the password and identity, as follows:

The result is that objrs. eof is true. The user does not exist.

Interesting!

Lesson: Do not take questions for granted! You are not the result, but the fact is the result!