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.