🚀 go-pugleaf

On Mon, 20 Aug 2001 09:44:09 -0400, "Ross Pellegrino" <rpel@home.come> wrote:

>Hi
>
>does anyone know how to create a fabricated recordset and open it for adding
>new records to it?
>
>Any help would be appreciated.
>
>Thanks in advance.
>Rp
>

Hi Ross,

    just drop a TADODataSet component from the ADO palette
page. Then, try to add, for exemple, this code in order to 
create the memory recordset.

ADODataSet1->FieldDefs->Clear();

// Create 1st field
TFieldDef *NewDef = ADODataSet1->FieldDefs->AddFieldDef();
NewDef->Name = "Field1";  // Name for Field #1
NewDef->DataType = ftInteger; // Type for Field #1

// Create 2nd field
NewDef = ADODataSet1->FieldDefs->AddFieldDef();
NewDef->Name = "Field2";  // Name for Field #2
NewDef->DataType = ftString; // Type for Field #2
NewDef->Size = 30;  // Length for Field #2

// and so on with the others fields...

// Create the dataset
ADODataSet1->CreateDataSet();

You don't need to open ADODataSet after TADODataSet::CreateDataSet().

To add some records you can use, for example, the following pattern:

ADODataSet1->Insert();
ADODataSet1->FieldByName( "Field1" )->Value = 10;
ADODataSet1->FieldByName( "Field2" )->Value = "Folaghe";
ADODataSet1->Post();

HTH

Ciao

Giuliano