Toad World® Forums

TSS 6.8: Parameter parsing using the ':' colon character has a space between variable and the ':'


#1

I am simply using TSS 6.8 Xpert and the Query Builder tool.

I’ve assigned a WHERE condition in the designer to say WHERE Visit_ID = :VisitID, so that when I run the TSM script, it will prompt me for a value to replace the “:VisitID”.

However looking at the automatic generated SQL, there is clearly a space between the colon-character and my variable name, which is SQL syntactically incorrect. This never happened in earlier version of TSS, unless there is an option to stop this?! May someone please assist?

Also is there a way to default the ‘:’ colon char to ‘@’ instead?