General information
Forum:
Microsoft SQL Server
Title:
Creating a Parameter
Hello everyone:
This is my first post to this forum. I usually send all my messages to the FoxPro forum, but my company has transitioned to SQL Server to build an application. It doesn't appear there is near the number of posts to this forum as in the FoxPro forum. I wonder why that is. I was always under the impression that SQL was a major database backend.
Anyway>
I have created a database in SQL Server and connected the database to Visual Interdev, so that I can use the database tools in a more friendly environment. I don't have a lot (hardly any!) code writing experience, so the data tools have been helpful.
My problem is creating parameterized queries/views. I learned how to do it in FoxPro, but haven't been able to make it happen in SQL/Interdev.
Can someone walk me through the best way to create a pview? I tried placing a "?" in the CRITERIA box of the query grid, to declare an un-named parameter. When I run the query, a box pops up that asks me to declare a parameter value.
I am not quite sure what to do with that? When I close the query/view designer to save the view, I get an error message. Something like ADO error, COUNT not correct????? I am not at my development computer, so I can't remember exactly the error message it gave me.
In FoxPro, I could create a statement like:
Select*
From blah, blah, blah;
Where offices.noffice_id = ?lnparentId
I could set the tablename.fieldname = ?variable
that worked just fine!!!!
If anyone has some insight into what I am doing wrong in Interdevs tools to not get a parmater to work, please let me know. I would appreciate any feedback.
Thanks in advance
Jasoan
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only