KamalBudhabhatti
asked on
GLOBAL VARIABLES IN SQL 7
We are developing a client server application. There are a number of variables that are global once a usre logs in to the system for example, Login Name, Local Currency, etc. Is there a way to define global variables on the SQL server.
what tool are u using for building the appliation?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are using VB6 clients and SQL 7.0 backend.
I have seen that there are global variables that start with
@@<Variable_Name>
So I was wondering on how do define them in.
If there is no way then obviously gpbuenrostro's tip can be implemented. Which I was aware of.
Still waiting for more sugessions.
Thank you
Kamal.
I have seen that there are global variables that start with
@@<Variable_Name>
So I was wondering on how do define them in.
If there is no way then obviously gpbuenrostro's tip can be implemented. Which I was aware of.
Still waiting for more sugessions.
Thank you
Kamal.
gpbuenrostro's is totally correct. You cannot create/define your own global variables.
ASKER
Since There is no way out, We will have no option but to
have a work around using the tables.
Thank you.
Kamal Budhabhatti.
-----------------------
have a work around using the tables.
Thank you.
Kamal Budhabhatti.
-----------------------
GREETINGS!
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange