Andy Murtagh
New Member
Hi folks,
I am currently writing a script in which I define several variables locally in the script, and set their values there also. In the case of some the values are ones that I may want to update moderately frequently, hopefully without having to un-pack and re-pack my PBO each time.
Is there a way that I can pull data from a table in the sql and use it to set my variable? For example, if I had:
a defined variable: _variable
a database name: bliss_1234
a table name: variable_value
inside that table, two columns: index (int, key, autoincrement), importantinfo
What I would want to do is make _variable equal to a value of importantinfo from the table bliss_1234.variable_value for a certain index#.
Does anyone know if this is the kind of thing which is possible in a script? Sorry, reasonably new to this whole thing and the forum search and google have failed me on this occasion (mostly I'm sure down to not knowing the right keywords to be searching for!).
Many thanks!
Q.
I am currently writing a script in which I define several variables locally in the script, and set their values there also. In the case of some the values are ones that I may want to update moderately frequently, hopefully without having to un-pack and re-pack my PBO each time.
Is there a way that I can pull data from a table in the sql and use it to set my variable? For example, if I had:
a defined variable: _variable
a database name: bliss_1234
a table name: variable_value
inside that table, two columns: index (int, key, autoincrement), importantinfo
What I would want to do is make _variable equal to a value of importantinfo from the table bliss_1234.variable_value for a certain index#.
Does anyone know if this is the kind of thing which is possible in a script? Sorry, reasonably new to this whole thing and the forum search and google have failed me on this occasion (mostly I'm sure down to not knowing the right keywords to be searching for!).
Many thanks!
Q.