Very strange behaviour

Classic Servoy
1 
var maxReturnedRows = 100000; 
var query = "SELECT callsid FROM calls WHERE mark = 1 ";
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, [], maxReturnedRows);
controller.loadRecords(dataset);
var set = databaseManager.getFoundSetUpdater(foundset);
set.setColumn('mark', null);
set.performUpdate();

Visually, I can see there are at least three records which should be selected but the above query finds none. The same SELECT statement tested in InteractiveSQL also finds none.

Now it gets even stranger. If I click the “Mark” column the column doesn’t sort. Which leads me to suspect there’s a hidden character in addition to the “1” in the target records.

Therefore I revise the query to:

var query = "SELECT callsid FROM calls WHERE mark IS NOT NULL ";

Same results – nothing selected.

Anyone out there have guesses as to what might be going on here?

Version R2 2.2.1rc-build 330
Java version 1.5.0_04-b05 (Windows XP)
running Sybase ASA

2

Hello Morley,

I don’t understand this. The query gives me the expected result!

Probably too simple but when you do this query and run the foundsetupdater you lost all those records where mark was 1…

Cheers,

Marcel