Error Table '#TEMP_5710665835' not found with addTableFilter

Classic Servoy
1

Hi,

I set table filters in Servoy with the function «databaseManager.addTableFilterParam()». Now I got errors in some forms:

Fehler in Beziehung
 > com.servoy.j2db.dataprocessing.DataException: SQL Anywhere Error -141: Table '#TEMP_5710665835' not found

I assume this error is connected to calculations! But what does this error mean and how can i get around this error?

Regards, Stef

2

Stefan,

This error may happen when you use databaseManager.getSQL(foundset) and use that sql again.
See viewtopic.php?f=8&t=13009

Rob

3

OK,

I will look into it tomorrow morning! But it is only happen if I set the table filter, without the table filter all works fine an this error never occures.

Regards, Stef

4

The error definitly isn’t caused by the databaseManager.getSQL() function in our case because we never use this function in the hole solution!

I did not debuged the error but I will try it this afternoon! I still think is caused by some calculation.

Regards, Stef