Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msmith88
Starting Member
5 Posts |
 Posted - 2008-11-24 : 10:32:39
|
| Sorry guys, I've never learned SQL and I need to write in it apparently. I need to know how to make an input dialog box pop up to receive user input to run a query. Can anyone help me? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 10:35:09
|
| sql server is a db engine. you cant use it to create input box. this need to be done at your front end application. Pass the values from box onto sql as a parameter and retrieve data using sql query. do the ui part at your front end |
 |
|
|
msmith88
Starting Member
5 Posts |
Posted - 2008-11-24 : 12:04:37
|
| My frontend is a MS Access .adp file. Other than that, I have no idea about parameters or how to pass the values from the box. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 12:11:06
|
quote:
Originally posted by msmith88
My frontend is a MS Access .adp file. Other than that, I have no idea about parameters or how to pass the values from the box.
you can create forms in access. create form with input box and use it to pass values to sql server |
|
|
|
msmith88
Starting Member
5 Posts |
Posted - 2008-11-24 : 12:35:24
|
| I've never done anything involving SQL, so I'm lost as to what to do. I know in Access you could type "like [something]" in the criteria field in Query design, but I'm unaware of the SQL equivilent. When I tried that in the Criteria box while attempting to create a Stored Procedure, it didn't do anything. As for making a form place input into a query's search criteria, I have no idea how to do that. I was told to make a DB, I said ok, it got to big, I upsized it, now I have everything working nicely except my queries. |
|
|
|
|
|
|
Input dialog box