Hello all.
I have an ODBC question.
I have a frame that starts first with a dialog box that the user will type in their network ID.
What I want to do is capture that network ID and then use it in a SQL query to grab data from a database and from that SQL query populate the counter.
The SQL query I have so far is:
"SELECT * FROM Data_Table WHERE Agent_ID LIKE '%(Dialog box answer)%'"
How would I accomplish this?
Is it getting the result from the dialog box that you're stuck on? I'm not certain of the details of how to use it, but there should be a "Get text from element (something)" condition/event/expression of the dialog box that you can put into that query.
Ok I worded this bad.
I did figure out how to get the value from the dialog box.
What I am doing is setting alterable string a to the value in the dialog box.
Alterable String A( "DialogBox" )
Then I am taking Alterable String A into a SQL query to get the value in the database.
"SELECT * FROM Data_Table WHERE Agent_ID LIKE '%Alterable String A%'"
What I am stuck on, is how do I set the counter equal to the value I am getting from the SQL query?
Anyone able to answer the above?
Doesn't the network id change to something random every time the user logs in? Surely you'd go with a login name/password and validate the user first before checking the database on this information?
Not really, what I am doing is going to a database that stores production stats. What I am doing is creating a game, that their initial number of tries equals a production stat (like number of sales they had made the day previously).
I am currently in a "proof of concept" that I can set the counter to the stat stored in a database (so I am using an Access database that I created).
The reason I am asking for the user's LAN ID is that I could not figure out how to grab their network ID when they start the game.
If there is a way, then I would just grab their network ID and then link that to an entry in a database that has their production stats that I need to grab.
"SELECT * FROM Data_Table WHERE Agent_ID LIKE '"+Alterable String A( "DialogBox" )+"'"
Like that maybe?
Jean Villy Edberg
More like:
"SELECT * FROM Data_Table WHERE Agent_ID LIKE '%"+Alterable String A( "DialogBox" )+"%'"
Or maybe they are talking about running the Get Row action and corresponding Can get data? event and setting the counter to the result of the ODBC's Get Number in Column function.
.:::.Joshtek.:::.
I saw that function for Get Number in Column but how would I get the
"SELECT * FROM Data_Table WHERE Agent_ID LIKE '%"+Alterable String A( "DialogBox" )+"%'"
to return a row instead of a value, and how would I link that to counter?
Return a row instead of a value?
Do you know any other programming languages?
.:::.Joshtek.:::.
Posting Permissions
Reply With Quote