CODEWITHSUNDEEP
sqlitedelphiparadox
user3140961
user3140961

Reputation:

Porting Paradox tables to SQLite with Delphi 11

I am trying to port my Paradox files, created with BDE components, to SQLite database. I tried the CopyDataSet() method of TFDTable with the below code, but I received an error:

unrecognized token ":"

procedure TForm19.FormCreate(Sender: TObject);
begin
    with FDConnection1, Params do
    begin
        Close;
        clear;
        Add('DriverID=SQLlite');
        Add('Database=.\test.sql');
        Open;
    end;
end;

procedure TForm19.Button1Click(Sender: TObject);
begin
    with openDialog1 do
    if Execute then begin
        Table1.TableName := fileName;
        Table1.Open; // opens without problem
        FDTable1.TableName := Table1.TableName;
        FDTable1.CopyDataSet(Table1,[coRestart,coStructure,coIndexesCopy]);
        FDTable1.Open();
    end;
end;

Why?

Upvotes: 0

Views: 93

Answers (0)

Related Questions