TQuery Param
lazarus / 16-Databases

----------------------------------------------------------------------
kjteng · 2013-12-25 07:27

How do I set the value of parameter of a TSOLQuery at design time  ?
At run time the following statement works fine: 
SQLQuery1.ParamByName('mgr').AsString:= 'abc';
However I need to set the value of :mgr at design time for program
testing purposes. I cannot find 'value' property in the object
inspector for the parameter. (see attached image).

I am using  Lazarus 1.0.14.

----------------------------------------------------------------------
exdatis · 2013-12-25 09:00

Use beforeOpen event to set value. After activation you will have real
value.

----------------------------------------------------------------------
kjteng · 2013-12-25 14:47

exdatis:
Thanks for your reply but the  beforeOpen event does not  fire at
DESIGN TIME.
What I want is to  (a) set the parameters and (b) set the
SQLQuery2.active property to True so that I can check the data in the
related DBGrid at DesignTime.

----------------------------------------------------------------------
exdatis · 2013-12-26 14:23

So, change your select query with real value at design time and again
before compiling(with param). I can't do better...

----------------------------------------------------------------------
taazz · 2013-12-26 14:40

Υou can add a request in the bug tracker to make the value property of
the parameter published that will take care of your problem I think
and it will make them more delphi like which a target for lcl.