SP ParamPrefix

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
comnet
Posts: 5
Joined: Tue 13 Jan 2009 15:22

SP ParamPrefix

Post by comnet » Fri 11 Jan 2013 16:55

Hello,

I'm working on a Delphi XE / SQL2008R2 / Windows7 64 with the dbexsda 6.1.2 driver (32bit).
When I get the sp parameters using the new drivers I retrieve the parameters with the '@' prefix.
I read by default I shold retrieve parameters without '@' prefix.
I tried to change the ParamPrefix Connection params with no success.
Cause I'm working on a project developed with an older version of the drivers (where sp params were retrieved without any prefix) now I wouldn't to rewrite the code to add the prefix to all the ParamValues calls.

How can I work around this problem and retrieve the params without any prefix ?

Thank you,
Davide

AndreyZ

Re: SP ParamPrefix

Post by AndreyZ » Mon 14 Jan 2013 09:58

Hello,

In dbExpress driver for SQL Server version 6.0.1, we added support of dbExpress 4 metadata. It requires parameters to be with the '@' leading symbol (only for SQL Server). You can check the standard dbExpress driver for SQL Server, it has the same behaviour.
We will investigate this question and ways to avoid it. For the time being, you should use prefixes for parameters.

Post Reply