[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Query parameters

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

                        Tanks in advance.
0
oberdan
Asked:
oberdan
1 Solution
 
dwwangCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now