Board index » delphi » insert into error with Access table
insert into error with Access table
2004-02-03 11:07:02 AM
I am trying to insert a new record into an Access table using ADODataset.
The following code will actually get the new record/values added, but
generating an error message
"Current provider does not support returning multiple recordsets from a
procedure TForm1.Button2Click(Sender: TObject);
with ADODataSet1 do
CommandText := 'insert into ProblemSeverity (Severity,Description)
There are only three fields in the table, ID (auto number), Severity
(number), and description (text). I tried both Client Cursor and Server
Cursor locations, and still have the same problem.
Any help is appreciated.