🚀 go-pugleaf

Ok, thanks.  I'm using straight ADO and not ADO Express. But I can look inot
CreateDataSet and see how they are doing it. Unfortunetly, I'm force to use
VC++. To cumbersom to use.

Thanks


"Giuliano" <gcardinali@remove.adhoc.net> wrote in message
news:3b833a80.15227836@newsgroups.borland.com...
> 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