Global Variables in SQL

[thmsjlmnt3953]

Hi,

I have a number of global variables set when a user logs into my application which i want to use in an SQL string to record these in a table however im not sure how i go about it i know simply inserting the defined names in the SQL wont work.

Is there a way to define these in global functions instead?

 

[pbaldy]

You can create a public function that returns the value of the variable and use that in SQL.