Hi Helen,

I did what you asked and i saw that when i open the query it is prepared
with the parameter "MES=0", as you can see bellow:

EXECUTE STATEMENT
'TR_HANDLE = 14156328 STMT_HANDLE = 14201584 PARAMS = [ Version 1 SQLd 1
SQLn 1 [MES] = 0

So the statement "qryVctDsc.ParamByName('Mes').AsInteger := 12" has no
effect since it occurs after de prepare.

If i put the last statement on the AfterPrepare event i get:

EXECUTE STATEMENT
TR_HANDLE = 14156328 STMT_HANDLE = 14201584 PARAMS = [ Version 1 SQLd 1
SQLn 1 [MES] = 12

and it works fine, but the problem is that the AfterPrepare event don't fire
every time the parameter is changed.

Helton