Start a new topic
Solved

@ Symbol Interpreted As Query Parameter

database query contains the @ symbol where the symbol in not intended to represent a parameter. However, the symbol and the characters proceeding it are interpreted as a parameter.


Example:


image


@acme will be interpreted as a parameter, displayed on the Parameters tab, and will require a value to run the query.


image


To prevent the string from being interpreted as a parameter, add a backslash directly preceding the @ symbol in the string.


Example:


image


Result:


image




Login or Signup to post a comment