Query built in VBA

[doci4a]

Hello guys,

I have the following piece of code:

writeQ.SQL = "BEGIN UPDATE HR_ASSOCIATE_DATA SET USER_ID = '" & IIf(PAR_USERID = "", "N/A", PAR_USERID) _
& "', LEVEL_NUMBER = " & IIf(PAR_LEVEL = "", "-1", PAR_LEVEL) _


Can someone explain what this does or...at least the syntax like underscores, quotes, double quotes and the & symbols...



I'm really lost with this type of notation...

[KathyL]

Hello guys,

I have the following piece of code:

writeQ.SQL = "BEGIN UPDATE HR_ASSOCIATE_DATA SET USER_ID = '" & IIf(PAR_USERID = "", "N/A", PAR_USERID) _
& "', LEVEL_NUMBER = " & IIf(PAR_LEVEL = "", "-1", PAR_LEVEL) _


Can someone explain what this does or...at least the syntax like underscores, quotes, double quotes and the & symbols...

I'm really lost with this type of notation...

I can never understand why some developers use such complex query SQL, when one can just use a standard Access query. I’ve done some very complicated stuff but I avoid complex SQL as I just don’t see the need for it much.
Anyway.
1. If one needs quotes inside of quotes, then one has to use single quotes inside of doubles, or vise versa.
2. The underscores are just a character as part of the full name. ‘HR_ASSOCIATE_DATA” is a full name of either a field or a table.
3. "&" is the concatenation symbol. It strings two string values together.
4. The underscore at the end of the line means the line continues to the next line.