How to insert records to database
Posted on 2001-08-29
Hi, all Experts
I am using ADO to connect to MS Access database. I created the following codes to insert a record:
procedure TForm1.Button1Click(Sender: TObject);
with dm.ADOQuery1 do
Active := false;
SQL.Add('insert into category (description) values (''category1'')');
Active := true;
But when I run the program and click on button1, it shows some errors:
1. The operation requested by the application is not supported by the provider;
2. CommandText does not return a result set.
Please help me to fix it.