TLiteQuery append causes disappearing rows in TTMSFMXGrid

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
scottlynn
Posts: 4
Joined: Thu 08 Dec 2016 17:46

TLiteQuery append causes disappearing rows in TTMSFMXGrid

Post by scottlynn » Tue 07 Feb 2017 17:18

Greetings,
I have an unusual issue involving a TLiteQuery showing on a TTMSFMXGrid. I have contacted support at TMS Components and tried some tests over there. Wondering if the DevArt side can offer suggestions.

- Firemonkey app with a SQLite database.
- TLiteQuery with a subquery record lookup:

SELECT
(SELECT FullName FROM Users U WHERE U.UserGUID = UC.UserGUID) AS FullName,
*
FROM UserClasses UC
WHERE IsFinished = 0
ORDER BY GradeNumeric, ClassName, FullName

Everything else is working great. My other grid/TMS tables are looking great. But in this case, when I append a record TLiteQuery.Append and open the editor, the TMS grid blanks out some of the rows depending on where the current record pointer is located. So if there are 7 rows in the resulting query, and the 4th one is highlighted and code executes a TLiteQuery.Append, the 4th through 7th rows disappear in the TMS grid while in the append, but then when you post or cancel, the rows reappear just fine. It is visually frustrating and I need to address.

Is there anything on the DevArt side, any properties of the TLiteQuery, that I can use to control or debug this?

Thanks,
Scott Lynn

MaximG
Devart Team
Posts: 1019
Joined: Mon 06 Jul 2015 11:34

Re: TLiteQuery append causes disappearing rows in TTMSFMXGrid

Post by MaximG » Wed 01 Mar 2017 08:54

We checked LiteDAC work when using visual components, including in RAD Studio, according to your description and found no problems. Unfortunately we do not have the possibility to check LiteDAC work with many visual third-part components. Therefore if there are any difficulties when using a third-part component, you need to contact its developers. We can investigate our products problems when using only standard visual components. Try to reproduce the problem without using TTMSFMXGrid . In this case, we will be able to investigate your application code and solve the problem.

Post Reply