Just starting to learn it . . .

I can't get a script to run that's supposed to generate a Query
Parameters dialogue to take inputs and then run the query - for
example, the following

. . .
and fl.flow_name = [[TRUE][FLOW NAME][@?]]
. . .

generates SQL Query Analyzer exceptions about "Incorrect syntax near
'FLOW NAME'.

Suggestions?

(joe@joeschweighofer
.com)  writes:
> I can't get a script to run that's supposed to generate a Query
> Parameters dialogue to take inputs and then run the query - for
> example, the following
>
> . . .
> and fl.flow_name = [[TRUE][FLOW NAME][@?]]
> . . .
>
> generates SQL Query Analyzer exceptions about "Incorrect syntax near
> 'FLOW NAME'.

I have no idea what that is supposed to mean. You get a syntax error
because first you have an identifier [TRUE. This is followed by another
identifier FLOW NAME, and this is not legal synax. Next follows
quoted identifier which lacks a closing quote - the two ]] means
a single ] is part of the idenfier.

Or in summary, the above is gibberish as far as SQL Server is concerned.
Since you can't run dialogues in Query Analyzer anyway, I suspect that
the script is intended to be run from somewhere else, although I have
no idea from where.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp