TMSFmxLiveGrid Issue rendering records

Sir,

 We are using TMSFMXLiveGrid Version 2.3.4.1 under RADStudio 11.3 Patch 1.
 Grid is bound to DB Table using LiveBindingsand and we render the data using TMyQuery and 
  TMyDatasource. 
 When the form is opened under IOS 64bit, SDK Version 16.4, the grid does not display any data.
 Sometimes displays data under wrong columns. 
 Sometimes displays only 1 or 2 columns.
 Displays only 1 row.
 Issue with formatted and Calculated Columns too.
  It does not display when scroll horizontally / Vertically too.
  But there is no issue with the same grid under Android SDK Version 25.2.5.

  There was no such issue under the previous versions. (RADStudio 11.2)
   Kindly check the issue and update at the earliest as it is critical for the release.

Regards

Please send a small sample demonstrating the issue.

Sir

ios

Android

The above are the attached gif files showing both IOS and Android versions respectively depicting the rendering issue under the grid based on the Department Selection under Stock and Date under ZReport.
Under Android, there is no issue with the rendering, where as under IOS it shows blank / few records while scrolling. You could find the total records it is supposed to show under the footer or could refer to the Android for actual records.

The grid is bound to the DB Table using LiveBindings. As mentioned earlier there was no issue under earlier versions.

Regards.

Did you use BeginUpdate / EndUpdate or any other kind of update mechanism? Are you able to reproduce this in a new project?

Sir
I do not use any kind of Update mechanism. It happens under New Project when we refresh the query (Requery) to render the records.

Regards

Please try BeginUpdate/EndUpdate to update the grid

Sir

 I tried with Begin and Update for updating the grid and see to find the same issue even under the new project.

I tried with BeginUpdate and EndUpdate for updating the grid and see to find the same issue even under the new project.

Sir,

We are using TMSFMXLiveGrid Version 2.3.4.1 under RADStudio 11.3 Patch 1.
Grid is bound to DB Table using LiveBindingsand and we render the data using TMyQuery and
TMyDatasource.
We do not use any update mechanism to render the data under the grid.

When the form is opened under IOS 64bit, SDK Version 16.4, the grid does not display any data.

Sometimes displays data under wrong columns.
Sometimes displays only 1 or 2 columns.
Displays only 1 row.
Issue with formatted and Calculated Columns too.
It does not display when scroll horizontally / Vertically too.
But there is no issue with the same grid under Android SDK Version 25.2.5.

There was no such issue under the previous versions. (RADStudio 11.2)

We have mentioned the above under Support forum and also sent them gif files to demonstrate the same.

We have been waiting for you to fix this issue as all our applications use this TTMSLiveGrid in almost all the forms.

Also we are not able to upload to the store due to SDK issue.(To use the latest SDK) Hence we cannot upload the changes from old version though we have no issue under that.

Kindly check the issue and update at the earliest as it is critical for the release.

Regards

We'll investigate this here as soon as possible.

Sir

 We are waiting for some solution for this issue. 
 Also we are not able to upload to the store due to SDK issue.(To use the latest SDK) Hence we c 
 cannot upload the changes from old version though we have no issue under that.

 Kindly look into it and update us at the earliest as it is very critical for release

Regards

Please understand that this takes time. We need to setup the environment, try to recreate the same circumstances and then try to pinpoint the issue, if we are able to reproduce this. We have meanwhile tested this here and couldn't reproduce the issue.

Please send us a small reproducible sample and steps to reproduce the issue.

Sir

This is a simple Live Binding to TMSFMXLiveGrid using TMyQuery and
TMyDatasource.and a requery to rerender to the grid. 

 In order to reproduce the issue go thru the following steps
  1. Drop a TTMSFMXLiveGrid, TMyQuery (QSelect) and TMyDatasource on the form.

  2. Place a Button call to refresh the Query.

  3. Bind the Grid using LiveBindings to the Datasource.

  4. On Refresh Button click give the following
    with QSelect do
    begin
    Close;
    SQL.Clear;
    SQL.Add('select * from Books');
    Open;
    end;

    where Books is the Table Name. (Bound to the Grid).
    Run the app.
    Click on Button to show the data and Scroll
    Click on Button to Refresh again

You will be able to produce the issue.

You can view the issue in the following sample app.
2023-06-26_10-52-55

Note: It is easily reproducible on Requery.

Regards.

Hi,

We have further investigated this here and are not able to reproduce this. Please send us a full reproducible sample, with a database to reproduce.

Sir

I have email already, here is a copy of

I am herewith attaching the Sample.zip source file. You could compile under RAD 11.3 Patch 1 and check for the issue.

MacOS Ventura Version 13.4.1
Xcode Version 14.3.1 (14E300c).

We have given the connection directly under TMyConnection component (CnnToShopping).

Kindly check and let us know if you need any other info with regard to this.

Sample.zip (57.4 KB)

Sir

 Kindly let us know if you are able to recreate it.  We are unable to release our application due to this issue. If you need any assistance let us know. Awaiting reply asap. 

Regards

We cannot compile the application. TMyConnection is unknown. Please try to recreate it with a TClientDataSet, default and/or TMS Components only.

Sir
We have sent you the Database connection details through mail. You can go through the details and connect to our database to check the issue.

You could install trial version of MyDAC in order to check the issue at your end.

We are using TMSFMXLiveGrid Version 2.3.4.1 under RADStudio 11.3 Patch 1.

This issue does not occur under Older versions and also under same above version of Android.

Regards

We have tested your sample and could not reproduce an issue here in RAD Studio 11.3 in iOS. the records are loading as expected. We tried multiple times to click the refresh button but could not see an issue displaying data. We suspect that this is a one off issue related to a combination of components, iOS Version & RAD Studio version. What you could do to try and pinpoint the exact reason is rebuild the application in a new project, and start by dropping the grid directly on the main form instead of embedding it inside Layouts.

Sir

 We still have the same issue even without the layouts simply dropping the grid directly. 

 I am attaching the sample project for your reference.

DBSample.zip (28.3 KB)

We tested it on TMSFMXLiveGrid Version 2.3.4.1 under RADStudio 11.3 Patch 1 IOS .(Works fine under Android)

It works fine under SDK 15.3, RAD 11.2. (Works fine under Android and IOS)

Please check the above sample only on RADStudio 11.3 Patch 1. SDK 16.4

You could check the above sample under Android and IOS latest versions.

Regards