Hi,
With a grid that fetches data from an MS SQL server, the following message is displayed when scrolling to the next page:
Unfortunately, there is nothing in the message …
As a test, I have created a grid, the only SQL command in there is SELECT field1, field2, … fieldx FROM tablename.
I do the same, only with a MySQL database everything works as usual.
This seems to me to be a bug when an MS SQL database is used.
Supplement: the problem only occurs in the SC development environment or when the app is started from there.
Dear @RHS,
After carrying out some tests creating a grid from a single MS SQL Server table, the application’s behavior was as expected in pagination, not returning this browser alert.
If possible, send us more details about your environment, your application, so that we can analyze in more detail and simulate the error as much as possible.
Best regards!
Scriptcase 9.10.005
DBMS Driver: MS SQL Server Native SRV PDO
SQL Server 2019 Standard
Windows Server 2019 Standard
The test app is a new grid without customizations with a simple SQL query as mentioned above.
My development environment runs on Windows 10 Pro with Google Chrome.
I looked into this topic again today …
I exported the app with the unknown message and re-imported it into a new project. There the app runs without this message and scrolling works.
I also had problems with the display of umlauts in the app before, but this also works in the new project.
But I wonder what is different now, the app was probably exported and imported but not changed. Where do I start looking in the original project? It contains many apps and the problems always occur when the MS SQL Server is used. Should I really export every app and import it into the new project? Or can I somehow compare the project configuration? Ultimately, that must be the problem …
I have now transferred all the apps to a new project and tested it. I could no longer detect any errors. So far ok.
Then I thought I’d have a look at the generated code of a few apps for differences. Almost all the files of an app from the original project are not identical to the files of the same app from the new project.
As I said, I transferred all apps from one project to a new, empty project (via App Export / Import) and performed a Generate. I actually expected that the generated codes of the two projects would be identical or only show a difference where the problems are.
Scriptcase works a bit strangely, so it’s no wonder that support often can’t find anything, even though the user has problems … I’ve been with SC for a few years, but we prefer to write our new project in C#, EF Framework Core, DevExpress Tools and Vue for the front end.
I have same problem using MsSql database in a grid.