Hello,
I have a problem with TMSQuery, supose this simple SQL put into a TMSQuery.SQL property
DECLARE @CLIENTE_ID INT
SET @CLIENTE_ID = :CLIENTE_ID
SELECT 'CLIENTE :'+CAST(@CLIENTE_ID AS VARCHAR)
When Set Active the component, get thiw message :
The name of variable @CLIENTE_ID has already been declared. The names of variables must bue unique on every batch os queries or stored procedures
Do you know a way to fix this error.
I have used this kind of querys years ago with BDE, TADOQuery, TFDQuery but is not working with TMSQuery.
Thank you!
Error with Parameters named "like" variables
Re: Error with Parameters named "like" variables
SDAC replaces Delphi parameters with SQL parameters with the same name in SQL statements. In this case, the :CLIENTE_ID is replaced with the SQL parameter @CLIENTE_ID. Since the @CLIENTE_ID parameter already exists in the SQL statement, the exception "The variable name '@CLIENTE_ID,' has already been declared" occurs. To solve the issue, you can change the parameter name, for example:
Code: Select all
DECLARE @CLIENTE_ID INT
SET @CLIENTE_ID = :CLIENTEID
SELECT 'CLIENTE :'+CAST(@CLIENTE_ID AS VARCHAR)