strSQL=strSQL & ",REQ_name as " & chr(34) & "REQUESTOR NAME" & chr(34) . what will this command do?

Question

plz explain the code

Answer 1

This seems to be part of code that puts together an SQL query. It adds the field REQ_name to be included in the result and specifies the alias REQUESTOR NAME to be used as name for the column in the result.

The code creates a new string to assign to the variable strSQL that consists of the current content of the variable and this:

,REQ_name as "REQUESTOR NAME"

Instead of using the code chr(34) to get a quotation mark, you can put them inside a string as double quotation marks:

strSQL=strSQL & ",REQ_name as ""REQUESTOR NAME"""

Answer 2

Chr(34) returns double quote,

so you have REQ_name as "REQUESTOR NAME"

Answer 3

strSQL = (previous value of strSQL) + ,REQ_name as “REQUESTOR NAME”

if previos value of strSQL = "SELECT some_fieds" then strlSQL value will be "SELECT some_fields, REQ_name as “REQUESTOR NAME”"

Answer 4

I would guess that the code is part of a SQL SELECT statement. The column retrieved would be psycically named REQ_name and aliased as REQUESTOR NAME.

The language used could be Visual Basic.