Servoy generating incorrect SQL statement

Classic Servoy
1

Hi! I am currently working on our solution using Servoy 6.1.

The application throws an exception on line where foundset.search(); called. When I checked the SQL statement through databaseManager.getSQL(foundset), it displays incorrect table reference.

The SQL statement should be displayed as “select ABC.idABC FROM ABC ORDER BY ABC.idABC asc”.
However it is displayed as “select AC.idABC FROM ABC ORDER BY AC.idABC asc”. It removes one letter from the table reference.

Has anybody encountered this? Does Servoy have a fix/workaround for this already?

2

Erik,

Is this the real table name, or is the real table name very long?

Rob

3

The real table name is 31 characters long. It generates the correct FROM clause but not the ORDER BY clause and the SELECT clause.

4

Erik,

This has just been fixed for next release https://support.servoy.com/browse/SVY-2713

Rob

5

Got it Rob. Thanks!