I am developing a VB6 application which connects with an Access 2010 database.
I want the application to execute queries stored in the database.
Some of the queries include Access functions in field names.
For example- FieldName: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])"
Is there a way in VB6 to execute the queries natively in the Access database?
A code example would be very helpful.
dbellerue 0 Newbie Poster
Recommended Answers
Jump to PostIIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])
I'm not sure what the above is for...
In vb6, open connection. open recordset. code should look similar to this -
If rs!Fieldname1 = rs!fieldname2 Then ''code here to handle returned boolean of true Msgbox "field1 is equal to field2" End If
All 4 Replies
AndreRet 526 Senior Poster
rishif2 57 Posting Whiz in Training
TnTinMN 418 Practically a Master Poster
QVeen72 104 Posting Shark
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.