Does anyone know why this fails when used as query in the databaseManager.getDataSetByQuery-method? :
- Code: Select all
if not object_id('article') is null SELECT TOP 1 article_code FROM article else select top 1 article_code from article
(I know this check on object_id returns the same result but this is only as a test and even this fails. Also tried with NOT IS NULL instead of NOT ..... IS NULL)
This query results in one row with one column when executed as Sql statement in any Sql-client program which is correct.
When executed in Servoy, I just get a JavaException.DataException with no additional info.
The table article and field article_code exist and a getDataSetByQuery with this succeeds :
- Code: Select all
SELECT TOP 1 article_code FROM article
Thx