Parametrized queries on insert

[polsol]

How does one add a parametrized query on inserting records using your Query component?
I need to add data taken from a combobox (DateTime) and place it in a FB field (DateTime also).

[Dimon]

The example of a code for inserting record in a table:

Code: Select all

IBCQuery.SQL.Text := 'INSERT INTO table_name(field1) VALUES(:field1)';
IBCQuery.ParamByName('field1').AsDataTime := Now;
IBCQuery.Execute;