🚀 go-pugleaf

Hi,

I have some newbie problems to get started with ADO components.

My MS ACCESS file has 3 tables, 1 fully hidden to the user, and 2 to be
partially edited by a DBGrid.

The component sequence is based on 1 ADOConnection and 3 ADODataSET, one for
each table. They activate at runtime loading the complete field
specifications by a SELECT * FROM <table_name> comand.

For the tables to allow partial editing, the sequence continues by a
TDataSetProvider, a TCustomDataSet with partial fields, a TDataSource and a
TDBGrig with persistent columns:

ADOConnection
    |
    -> ADODataSet2 (table2)
    |      |
    |      -> TDataSetProvider2
    |           |
    |            -> TCustomDataSet2
    |                 |
    |                  -> TDBGrid2 ( for table2)
    |
    |
    -> ADODataSet3 (table3)
          |
          -> TDataSetProvider3
                |
                -> TCustomDataSet3
                      |
                      -> TDBGrid3 ( for table3)

The runtime activation works fine upto the ADODataSEt, but the Append() to
create a new/first record fails, or at least the RecordCount is always 0,
while the other relevant properties are all true (Active,CanModify etc) as
well as reporting correctly FieldCount.


  SqlStr="SELECT * FROM MicList;";
  AdsMicList->CommandText=SqlStr.c_bstr();
  AdsMicList->Open();

  AdsMicList->Append();
  AdsMicList->FieldValues["NetId"]=4;

What might be wrong?

Tks & Rgds, Martin