Query parameters

How can I create and set query parameters at run-time (thus, without use the parameters editor) ?

                        Tanks in advance.
oberdanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dwwangConnect With a Mentor Commented:
You can just simply write the SQL statement with the ':' to create and use parameters.

query1.sql.text:='Select * from my table where myfield1=:myvalue1'

query1.parambyname('myvalue1').asstring:='xxxxx';
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.