[Lazarus] TSQLWebDataProvider setting Params

[Leonardo M. Ramé]

On 2011-08-25 13:00:58 -0300, Leonardo M. Ramé wrote:
> I'm trying to set params for a query contained in
> TSQLDBWebDataProvider's SelectSQL property.
> 
> The query is similar to this:
> 
> select * from table where field=:Field
> 
> I set the param value with this code:
> 
> myDataProvider.Params.ParamByName('Field').Value := 1;
> 
> But it doesn't seems to be assigned.
> 
> Any hint?.

The problem was that .Value is a variant field, it apparently doesn't
work. Setting to AsInteger or AsString works as expected.

-- 
Leonardo M. Ramé
http://leonardorame.blogspot.com