Query and Parameters

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
cooltool
Posts: 10
Joined: Sat 04 Jun 2005 15:29

Query and Parameters

Post by cooltool » Mon 14 Feb 2011 17:17

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

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 15 Feb 2011 11:31

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.

cooltool
Posts: 10
Joined: Sat 04 Jun 2005 15:29

Post by cooltool » Tue 15 Feb 2011 12:47

Please put this example and the @ sign in the Helpfile under the Topic Parameter

Thanks
Stefan

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 15 Feb 2011 13:41

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.

Post Reply