TLiteTable DetailFields = Unrecognized Token ':' Errors

[Bob Boyd]

I have been unable to create a master - detail table relationship when the field names contain spaces. I used the selection dialog to create the table link using the 'Sequence ID' fields which automatically fills both the MasterFields and DetailFields properties for the linked detail table. When the linked table is activated an error is generated indicating - unrecognized token: ":" and the table can only be activated if the MasterFields or DetailFields property is cleared which breaks the one to many relationship display I need for the form grid. The debugger error indicates an exception class ESQLiteError with the same message.

I have enabled the QuoteNames property for each of the tables, is there something I'm missing about creating a master detail link?

Code: Select all

  With SequenceLiteTable do
  begin
    Close;
    Connection := WC6SourceLite;
    Options.StrictUpdate := False;
    Options.QuoteNames := True;
    TableName := 'WSequence';
    stKey := '"Sequence ID"';
    IndexFieldNames := stKey;
    SetOrderBy(stKey);
    Open;
  end;
  With WSeqnAtchLiteTable do
  begin
    Close;
    Connection := WC6SourceLite;
    Options.StrictUpdate := False;
    Options.QuoteNames := True;
    TableName := 'WSeqnAtch';
    stKey := '"Sequence ID"; Attachment';
    IndexFieldNames := stKey;
    MasterSource := SequenceDS;
//    MasterFields := 'Sequence ID';
//    DetailFields := 'Sequence ID';
    MasterFields := '"Sequence ID"';
    DetailFields := '"Sequence ID"';
    Open;
  end;

[MaximG]

We have reproduced the bug according to your description. We are investigating the behavior of LiteDAC when using quoted fields name and we will inform you about the results in the near future.

[Bob Boyd]

Thanks for the reply and confirmation of the bug. Creating the master-detail links for the form grids is crucial for our application. I just reached the milestone of importing the Absolute database records into the SQLite database using the LiteDAC table component but I need to verify the record details using the index links. I am going to attempt to verify the MasterFields and DetailFields can be linked after I restructure the tables to remove the space in the index field names however that field renaming solution for all tables would be a big setback for this project.

[Bob Boyd]

Has there been any progress on this issue? It has been a week now and it has delayed the conversion of numerous forms in our application. This is definitely a show stopper for using the LiteDAC components. Its hard to believe that a SQL database with spaces in index field names has never been used before I tried to convert this project. Am I the only person using the TLiteTable component?

[MaximG]

We will study the issue and inform you about the results soon

[Bob Boyd]

Soon? Last week it was the 'near future', would you please provide an estimate of when there may be a fix. I have to report back to the client and we have to make a decision about continuing development with this component. I have 2 months invested in this SQL conversion already and need to demonstrate a working UI by the end of the year. I reached the milestone two weeks ago of importing records from the AbsDB into the SQLite DB and hit this blocker. Right now the only forms I can display are with tables that are not linked, the main form has to display the Attachment and Archives records for 5 different test types linked to an Equipment ID using the master - detail link. If this is not going to be fixed quickly, I may have to reattempt using the Rx built in FireDAC components.

[MaximG]

Thank you for your information. We fixed the bug related to using quotes in fields names. Fixing will be included into the next LiteDAC build. We are planning to release this build early next week.

[Bob Boyd]

Fantastic news!

[Bob Boyd]

I installed V2.7.27 today and it has solved the problem so I now have the master-detail links working for the grid displays. Thank you for this fix that was crucial for our application!

[MaximG]

We were glad to help you. Please don't hesitate to contact us with questions concerning LiteDAC usage.