Art S. Kagel
FYI friends: There's a bug in the Cheetah2 (IDS 11.50xC1) SPL Dynamic SQL feature.

Have a function in which you build an SQL SELECT statement based on the arguments to the function or table contents pointed to by the args in a string and PREPARE, DECLARE CURSOR, OPEN, FETCH...., CLOSE, FREE CURSOR, FREE STMT

Now if you call the same function again in the same session with different args so that the SELECT statement is different, it still executes the first statement within that session until you either disconnect and reconnect or recompile the SPL using UPDATE STATISTICS.

PMR # 80127, 7TD
Bug # idsdb00159990

FWIW. Haven't found a workaround for this one either. Otherwise this new feature is very nice. 8-{

Art S. Kagel
Oninit


С уважением,
Виктор