🚀 go-pugleaf

Hello all,

I am trying to create a new table within a database file that I just created
using this code:
Form1->Catalog.Exec(Function("Create") <<
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Tests.DBF"));

(I would like to use an access file, but will settle for a DBase file. it
appears that NewTable->TableType = ttDBase; does not have an Access table
listing)

I can create a table using this code:
TTable *NewTable = new TTable(Form1);
NewTable->Active = false;
NewTable->TableName = "Tests";
NewTable->TableType = ttDBase;
NewTable->FieldDefs->Clear();
TFieldDef *NewField = NewTable->FieldDefs->AddFieldDef(); // define first
field
NewField->DataType = ftInteger;
NewField->Name = "SID";
NewField = NewTable->FieldDefs->AddFieldDef(); // define second field
NewField->Name = "First";
NewField->DataType = ftString;
NewField->Size = 15;
TIndexDef *NewIndex = NewTable->IndexDefs->AddIndexDef(); // add an index
NewIndex->Name = "Tests";
NewIndex->Options << ixPrimary << ixUnique;
NewTable->CreateTable();

How do I create a table in the database that I just created..

If I can not create a table in the database, how can I open the new
standalone table?

Thanks, and sorry for the long post.

Lee