We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Vb.Net - Conversion from VB6 Query Question
Posted on 2013-01-04
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray.
The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Suggested Courses
Course of the Month4 days, 16 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.