Repeated parameters in MSQuery

[danilo.abranches]

Hi,

I am having the following problem to set some parameters in a MSQuery. When own parameters that are repeated in the query and dynamically create (CreateParam or ParseSQL), the second value is NULL when seen in Profiler.

Example:

Code: Select all

MSQueryPl1.ParamCheck := False;
MSQueryPl1.SQL.Text := 'select * from table where field = :field and '''' <> :field';
MSQueryPl1.Params.ParseSQL(MSQueryPl1.SQL.Text, True);
MSQueryPl1.ParamByName('field', 'value', ftString);

The query is generated with the last parameter NULL. If i make a loop and set the two parameters, it works.

This way it works:

Code: Select all

MSQueryPl1.ParamCheck := True;
MSQueryPl1.SQL.Text := 'select * from table where field = :field and '''' <> :field';
MSQueryPl1.ParamByName('field', 'value', ftString);

Does anyone know why this happens?

[paweld]

http://forums.devart.com/viewtopic.php?f=6&t=30520

[AlexP]

If you are using Lazarus, then when using similar parameter names you should set a value for each parameter entry. This is due to implementation when working with parameters in Lazarus. In Delphi, the value is set for both parameters.

[danilo.abranches]

Thank you.

[AlexP]

If you have any further questions, feel free to contact us.