> I am using Delphi 5 with ADO and I need to append Records to a table.

> This is what I defined, but when I call Append I receive error, that the
> dataset is "closed" (German translation). Does somebody know what is wrong
> with my dataset?

> Thanks in advance

> Klaus

>     ADOConnectOpenView.ConnectionString :=
>         'Provider=MS SQL Server;'
>       + 'Password=' + OVSAP + ';'
>       + 'Persist Security Info=True;'
>       + 'User ID=' + OVSAU + ';'
>       + 'Initial Catalog='OpenView';'
>       + 'Data Source='GO;'
>       + 'Use Procedure for Prepare=1;'
>       + 'Auto Translate=True;'
>       + 'Packet Size=4096;'
>       + 'Use Encryption for Data=False;'
>       + 'Tag with column collation when possible=False';

>   ADODataSetCommitment := TADODataSet.Create (self);
>   ADODataSetCommitment.Connection := ADOConnectOpenView;
>   ADODataSetCommitment.CursorType := ctDynamic;
>   ADODataSetCommitment.LockType := ltPessimistic;

>   ADODataSetCommitment.CommandType := cmdTable;
>   ADODataSetCommitment.CommandText := 'COMM01';

>     try
>       ADODataSetCommitment.Append;