QBSelect isin limit

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

QBSelect isin limit

Postby ionelioras » Thu Jun 14, 2018 3:53 pm

In servoy 7.4.9 I see that the array given for isin in a QBSelect is limited at 200 values. When the length of the array is bigger, an error occurs: QueryFunction cannot be cast.
User avatar
ionelioras
 
Posts: 31
Joined: Mon Jun 01, 2009 9:49 am
Location: Timisoara, Romania

Re: QBSelect isin limit

Postby joe26 » Wed Jun 20, 2018 12:09 am

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.
joe26
 
Posts: 77
Joined: Wed Jun 19, 2013 10:30 pm


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 4 guests