MySql variables (global or session)

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


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.

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