Jimbo99999
asked on
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,ADDR ESS,[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
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,ADDR
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jimbo99999