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
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
Visual Basic.NET
Last Comment
Jimbo99999
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
jimbo99999