Create New DBF Table

[AngelicTech]

Hello,

Does anyone have an example sql script to create a new table for a DBF database using UniDac in Direct mode.

Thanks

[MaximG]

The standard CREATE TABLE statement, corresponding the SQL-92 standard, is used to create DBF table using UniDAC. The following snippet demonstrates this ability:

Code: Select all

UniConnection.ProviderName := 'DBF';
  UniConnection.Database := 'С:\DBF';
  UniConnection.SpecificOptions.Values['DBFFormat'] := 'dfFoxPro2';
  UniConnection.SpecificOptions.Values['Direct'] := 'True';
  UniConnection.Connect;
  UniConnection.ExecSQL('CREATE TABLE MyTable (ID NUMERIC, Customer CHAR(50), Notes MEMO)');