Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
-
Bob Boyd
- Posts: 16
- Joined: Thu 28 Jul 2016 19:26
Post
by Bob Boyd » Wed 02 Nov 2016 17:02
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
- Devart Team
- Posts: 1822
- Joined: Mon 06 Jul 2015 11:34
Post
by MaximG » Fri 04 Nov 2016 09:39
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
- Posts: 16
- Joined: Thu 28 Jul 2016 19:26
Post
by Bob Boyd » Fri 04 Nov 2016 15:03
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
- Posts: 16
- Joined: Thu 28 Jul 2016 19:26
Post
by Bob Boyd » Fri 11 Nov 2016 05:55
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
- Devart Team
- Posts: 1822
- Joined: Mon 06 Jul 2015 11:34
Post
by MaximG » Fri 11 Nov 2016 07:37
We will study the issue and inform you about the results soon
-
Bob Boyd
- Posts: 16
- Joined: Thu 28 Jul 2016 19:26
Post
by Bob Boyd » Fri 11 Nov 2016 15:36
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
- Devart Team
- Posts: 1822
- Joined: Mon 06 Jul 2015 11:34
Post
by MaximG » Wed 16 Nov 2016 10:07
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
- Posts: 16
- Joined: Thu 28 Jul 2016 19:26
Post
by Bob Boyd » Tue 22 Nov 2016 17:15
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
- Devart Team
- Posts: 1822
- Joined: Mon 06 Jul 2015 11:34
Post
by MaximG » Wed 23 Nov 2016 11:51
We were glad to help you. Please don't hesitate to contact us with questions concerning LiteDAC usage.