Re: fetch limit vs FrontBase

2015-03-05 Thread Chuck Hill
There is also ERXBatchingDisplayGroup which may or may not suit your needs. Chuck On 2015-03-05, 8:48 AM, "Ramsey Gurley" wrote: ERXSQLHelper has a FrontBaseSQLHelper subclass which implements limitExpressionForSQL(). Assuming that works, you could try EOFetchSpecification spec = ... //your f

Re: fetch limit vs FrontBase

2015-03-05 Thread Ramsey Gurley
ERXSQLHelper has a FrontBaseSQLHelper subclass which implements limitExpressionForSQL(). Assuming that works, you could try EOFetchSpecification spec = … //your fetch spec here EOModel model = EOModelGroup.defaultGroup().entityNamed(spec.entityName()).model(); ERXSQLHelper sqlHelper = ERXSQLHelp

Re: fetch limit vs FrontBase

2015-03-05 Thread Patrick Middleton
Was there about 15 years ago, with WO 5.1 and Sybase. Some JDBC drivers (and ODBC drivers too!) don't support server-side fetch limits, or don't support server-side return rowset buffering, or don't usefully support cancel(). So what has to happen is that the client library (JDBC driver) as

fetch limit vs FrontBase

2015-03-05 Thread OC
Hello there, unless I am missing something, it looks like with FrontBase, EOF/Wonder alas limits fetches application-side, e.g., my code === def fs=... fs.fetchLimit=1 ec.objectsWithFetchSpecification(fs) === with SQL logging switched on yields a result of === 14:00:57.