Parameters syntex with the SqlDataSource

Progress® Telerik® Reporting Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Declined

Last Updated: 27 Nov 2017 08:27 by ADMIN

Mhd.Ahd

Created on: 13 Apr 2015 22:25

Type: Feature Request

Parameters syntex with the SqlDataSource

Create your own parameter syntex, and translate it to the database specific one according to the provider name.
For example, MsSql uses "@" character while Oracle uses ":" to identify parameters.
We need to be able to execute the same report against multi database types.

2 comments

ADMIN

Milen | Product Manager @DX

Posted on: 27 Nov 2017 08:27

Hi. It is outside of the product boundaries to parse the SQL. The Query Builder can produce basic SELECT statement, but we do not have SQL parsing engine. Parameter prefixes are returned from the currently set provider, changing the provider cannot trigger a change in the SQL statement, this is a bad API design. This cannot be approved.

erwin

Posted on: 22 Apr 2015 17:17

Also I should be allowed to define own constants/variables in the SQL Query Text without interfering with the query engine. Currently, the Report Engine insists that @MyConstant is a Parameter.

DECLARE @MyConstant AS Integer = 256;