Queries with parameters, an example please

[rogermon]

Hello,

I'm getting started with your package. Static queries seem to work fine, but I'm having no luck with using parameters in queries. Can anyone provide an example using parameters for input and output variables?

I can "build" query strings, but it would be nicer if I can avoid that.

Thanks in advance,

Roger

[Ikar]

Try using something like:

Code: Select all

        MSQuery.SQL.Text := 'SELECT * FROM emp WHERE empno = :empno'
        MSQuery1.Params.ParamValues['empno'] := 7839;
        MyQuery.Execute;

By the way, using parameters in SDAC is the same as in ADO, BDE. Please, refer to the Delphi Help for detailed information.