Smart Client adds "TOP" for SQL Server Queries
Posted: Sun Nov 29, 2020 4:04 pmServoy version 7.4.3 -releaseNumber 2036
While our Repository is still SQL Anywhere 17, our Data is now on SQL Server
For some reason, Servoy adds "TOP x" to every Query e.g. "SELECT TOP 2 names where ID < 5", which is odd. Why ?
The desired Query is ""SELECT names where ID < 5"", run using databaseManager.getDataSetByQuery( 'db', string, null, -1 );
The results are displayed as HTML in a pop up Smart Client Form
This does not happen with SQL Anywhere
It occurs for both Views and Tables
I see it in the Servoy Admin 'Performance Data' page, which shows the actual queries as sent to the backend database
Is this a SQL Server quirk ? an obscure Servoy setting somewhere ? is -1 not all rows ?
greg
While our Repository is still SQL Anywhere 17, our Data is now on SQL Server
For some reason, Servoy adds "TOP x" to every Query e.g. "SELECT TOP 2 names where ID < 5", which is odd. Why ?
The desired Query is ""SELECT names where ID < 5"", run using databaseManager.getDataSetByQuery( 'db', string, null, -1 );
The results are displayed as HTML in a pop up Smart Client Form
This does not happen with SQL Anywhere
It occurs for both Views and Tables
I see it in the Servoy Admin 'Performance Data' page, which shows the actual queries as sent to the backend database
Is this a SQL Server quirk ? an obscure Servoy setting somewhere ? is -1 not all rows ?
greg