Smart Client adds "TOP" for SQL Server Queries

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Smart Client adds "TOP" for SQL Server Queries

Postby gdurniak » Sun Nov 29, 2020 4:04 pm

Servoy 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
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Smart Client adds "TOP" for SQL Server Queries

Postby gdurniak » Fri Dec 04, 2020 9:53 am

After a Servoy machine restart, addition of "TOP" appears to have stopped

Very strange

greg
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 4 guests

cron