I use delphi 7 and a firebird database and i want to insert records from my delphi form into a table.I use ibquery and i want the correct sql syntax to insert records based on what the user types into some editboxes.I try this :
ibquery1.SQL.Text:='INSERT INTO people (name,address,tel) VALUES ('name.Text','address.Text','tel.Text')';
but i get an error : missing operator or semicolon.
Please tell me where am i wrong or show me which is the best way to insert a new record.
Thanks in advance!