Page 1 of 1
Query and Parameters
Posted: Mon 14 Feb 2011 17:17
by cooltool
Hello,
how can i use Parameters in Querybuilder
I tried ""Parameter or :Parameter or 'Parameter'
nothing works. The Helpfile said ""Parametername. I think you missed a Character between the ""
best Regards
Stefan
Posted: Tue 15 Feb 2011 11:31
by .jp
With the help of the Edit Parameters dialog you can set parameter values if they exist in your query. For example, you have a query:
Code: Select all
SELECT
Department.Name,
Department.DepartmentID
FROM
HumanResources.Department
WHERE
Department.DepartmentID = @depID
Open the Edit Parameters dialog and type a value for the @depID parameter. If the parameter value is not entered, the Edit Parameters dialog will appear automatically.
Posted: Tue 15 Feb 2011 12:47
by cooltool
Please put this example and the @ sign in the Helpfile under the Topic Parameter
Thanks
Stefan
Posted: Tue 15 Feb 2011 13:41
by .jp
cooltool wrote:Please put this example and the @ sign in the Helpfile under the Topic Parameter
Of course, we will fix this bug in the user documentation and add a more detailed description.
By the way, we are going to release the new version of the product soon.