MySql variables (global or session)

Scriptcase 7 Discussion
, ,
#1

Hello !
Is there a way to set a mysql variabile , like lc_time_names, before the execution of a query on a form or grid ?

You could usually set this variable in a “GLOBAL” way at MySQL startup or in a “SESSION” way before executing any query.
How could it be in ScriptCase environment ?

Most of us have not the opportunity to change this variable because of hosting operators deny…

Thank you for answer

Raimondo

#2

As long as it only requires sql you can. I.e. in forms you can use the onvalidate event to do so. In grids you have some kind of pre-query to be used.

#3

How would I set a variable (say zero) for a variable over a set of records?

Similar to sum ( xyz), but want to set the variable