A bug? a grid caching sql since the new SC version

Scriptcase 9 Bugs
#1

After the upgrade to the newest version of SC,
i notice one grid application is cashing the sql . the first time i open the grid it works ok,
but when i open with other parameters it keeps on showing data for the previous sql / the first one i opened.
is something changed? can i turn of sql cashing? just cannot find any options.
my another grid application works fine. i cannot figure out the difference.

#2

i have the same problem , i have raported for abaut a week by now but no answer yet. i have big problem with the ap[licatiaon taht i develop right now , my deadline are delayied so it is annoiyng.
When I first opened the application, Scriptcase correctly prompted me to input the values for the global variables [parfisa] and [paridconsultatii].

However, after the first run, the application stopped asking for these variables. Now it opens directly, without prompting for any input, and executes the SQL using empty string values, like this:

sql

CopyEdit

SELECT ... FROM detaliiConsult WHERE nrFisa = '' AND idconsultatii = ''

The result is that no data is shown, even though the variables are properly configured in the “Global Variables” section:

  • Type: IN
  • Scope: GET and POST (SESSION is unchecked)
  • “Optional” is not selected

I tried:

  • Clearing the browser and Scriptcase cache
  • Recompiling the app
  • Resetting the global variables using sc_reset_global() in onScriptInit

Still, the application does not prompt for those variables anymore, and the empty values remain.

I believe this issue started after the most recent Scriptcase update, which may have changed how global variables are handled.

#3

You are right. It is a bug. Even if the gloabl variable is not marked as optional there is not prompt asking for the variable value. Only the first time but then the value is cached.

1 Like
#4

i confirm the same. did you already submitted the bug to support ?

1 Like
#5

In my case the parameters were correctly passed to the grid/ i echo them on initiate even, but the sql where was using some cache. I could not make the grid work and recreated the broken grid application. After that it worked as expected.

#6

Answer about possible issue with global variables in query application given in topic below