AnsweredAssumed Answered

ExecuteSQL FROM with a v?

Question asked by BruceHerbach on Nov 21, 2016
Latest reply on Nov 21, 2016 by jfletch

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 = "

    SELECT ~level

    FROM ~@Values v

    WHERE ~id=?";

 

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.

Outcomes