rgansevles wrote:The number of values is not limited to 200, with many in-values Servoy will generate a different query but will still work.
The exception you see does not occur on the latest Servoy.
Rob
joe26 wrote:I've used sub queries successfully in the past.
var q = databaseManager.createSelect(xxx)
q.result.add(q.column.name_column)
var r = databaseManager.createSelect(xxx)
q.result.add(q.column.other_column)
q.where.add(q.column.name_column.isin(q)
At least that's from memory... q should only return one row.
ionelioras wrote:So this behavior was present in previous versions of Servoy, like 7.4.9?
Return to Programming with Servoy
Users browsing this forum: Bing [Bot] and 12 guests