Page 1 of 1

Parametrized queries on insert

Posted: Thu 25 Mar 2010 07:48
by 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).

Posted: Thu 25 Mar 2010 10:32
by 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;