Anyone seen this?

Scriptcase 9 General
#1

I got this after adding a new field inside my app

Screenshot 2025-04-03 at 9.50.20 PM
Screenshot 2025-04-03 at 9.50.20 PM1014×580 44.5 KB

#3

I just got it,

I update the version a second time, and it’s now working

#4

I have a Scriptcase application that uses global variables in the SQL WHERE clause to filter records. The SQL looks like this:

sql

CopyEdit

SELECT ... FROM detaliiConsult 
WHERE nrFisa = '[parfisa]' AND idconsultatii = '[paridconsultatii]'

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.

#5

@psyhocabinet,

The problem you are reporting above does not seem to be related to the one initially reported.

Please, if possible, open another topic to report your problem to keep things organized, because when we identify that it is a problem we report the case attaching the forum topic, so that when the case is fixed, it will be easier for us to provide feedback here.

Best regards!