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
SP ParamPrefix
Re: SP ParamPrefix
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.
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.