Vb.Net - Conversion from VB6 Query Question

Good Day Experts!

I am converting a project from VB6 to VB.Net. I ran across an Insert statement that uses a condition in the values clause which is based on a previously executed RecordSet.  Here is the part in question:

INSERT INTO [" & strReportType & " REPORT$] (SECTOR,DIVISION,CITY,ADDRESS,[I/O]...
values ('" & IIf(Not SQLrs2.EOF, SQLrs2.Fields("Reference Notes 2").Value, "") & "',...

Ok, I am trying to understand what happens if SQLrs2.EOF was true.  If that was the case would the code just put ' ' for the value for SECTOR?

Thanks,
jimbo99999
Jimbo99999Asked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
it was putting an empty string value
0
 
Jimbo99999Author Commented:
Thanks for the clarification,
jimbo99999
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.