I have been looking at a very good demo that uses executeSQL to gather data for a virtual list. The from statement appears to have an argument with a value of v in it. What is the purpose of the v argument?
The executeSQL statement is in a set variable script step and uses substitution to develop the text of the statement. The initial setup is:
Let ( [ $~sql = "
FROM ~@Values v
|SELECT ~level||FROM ~@Values v||WHERE ~id=?|
The actual query is:
$sqlResult = ExecuteSQL ( $sqlQuery ; "" ; "" ; $id )
The query appears to work with and without the v in the FROM statement. I am very far from being an expert on SQL but my experience is that it is very syntax sensitive and have an invalid argument usually results in a ? or error as a result.
Thanks for you help with this. I know curiosity will killed the cat.. but I am curious about this.