ASA Error -141 on table when crossing 200 records

Classic Servoy
1

I get the following error:

com.servoy.j2db.dataprocessing.DataException: ASA Error -141: Table ‘#TEMP_2300276149’ not found

On any search I conduct on a table that returns more than two hundred records when using the following SQLstatement:

SELECT daily_production_scheduleid FROM daily_production_schedule WHERE daily_production_schedule.staged_date BETWEEN ? AND ? ,[11/22/2010 00:00:00,12/03/2010 23:59:59]

The daily_production_scheduleid row_indent is set to pk, and the sequence type is set to servoy seq.

What have I done to this form/table to cause this to happen?

The only other fact I can think of is that I was having an issue at one point searching on one of three datetime fields (assigned_date) using the controller so I changed that field’s sequence type to, I believe, servoy seq then back to none and now whenever I import the solution to the server it asks me if I want to override the auto enter values on that field: again, assigned_date. I never do.

And in this case I’m only searching on the staged_date date time field.

2

Providence,

I think this is the same issue as discussed in this thread:
http://www.servoy.com/forum/viewtopic.php?f=3&t=15313

Do you usedatabasemanager.getSQL(foundset)?

Rob

3

I do indeed!

What was the eventual solution to the post you linked to?

4

Rob, is there an answer to this riddle or is it a big secret?

5

Providence,

The answer is that the promised case in the referred thread was never created (at least I have not seen it)

Rob

6

Providence,

The way we are now planning to fix this issue in the future (> Servoy 6), is by exposing the query object we use internally and not the query string.
The string has the limitation as mentioned before (in the other thread), the query object does not.

For now, this will still be a limitation.

Rob