Need help again.
I've a query that searches for a specific record. I need to make this query available for some collegues at work who don't understand SQL, so I wouldn't like to have them editing the query to insert the new number for every search they have to do.
Is there something like a popup text box that calls for the new number and then substitutes it in the query sintaxe?
this would be very helpfull. Thanks
Unfortuantely, there is not.
And if your collegues could endanger your query, think about what they could do to your database...
Put the query in a stored procedure, and show them how to execute the stored procedure.
No comments:
Post a Comment