CreateTable FieldDefs AddFieldDef

__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
  Table1 = new TTable(Form1);
  Table1->Active = false; // The Table component must not be active.
  Table1->DatabaseName = "DBDEMOS";
  Table1->TableType = ttParadox;
  Table1->TableName = "CustInfo";
  if (Table1->Exists)
        MessageDlg("CustInfo table already exists.", mtWarning, TMsgDlgButtons() << mbOK, 0);
  else // Do not overwrite an existing table.
  {
        // describe the fields in the table
        Table1->FieldDefs->Clear();
        TFieldDef *newDef = Table1->FieldDefs->AddFieldDef();
        newDef->Name = "Field1";
        newDef->DataType = ftInteger;
        newDef->Required = true;
        newDef = Table1->FieldDefs->AddFieldDef();
        newDef->Name = "Field2";
        newDef->DataType = ftString;
        newDef->Size = 30;
        // Next, describe any indexes
        Table1->IndexDefs->Clear();
        /* The first index has no name because it is a Paradox primary key. */
        Table1->IndexDefs->Add("","Field1", TIndexOptions() <<ixPrimary << ixUnique);
        Table1->IndexDefs->Add("Fld2Index", "Field2", TIndexOptions() << ixCaseInsensitive);
        // Now that you have specified what you want, create the table.
        Table1->CreateTable();
        Table1->Active = True;
        for (int i = 1; i <= 20; i++)
          Table1->AppendRecord(ARRAYOFCONST((i*111, i*222)));
  }
  DS2->DataSet = Table1;
  DBGrid2->DataSource->DataSet = Table1;
  Table1->Active = True;
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button1Click(TObject *Sender)
{
  Table1->Close();
  Table1->DeleteTable();
}

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值