Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pass Through in Query Designer
You can change the query dynamically by using query def before opening it. I'm assuming that Basedata.mmes_number is your textbox that holds the value you want to pass to the stored procedure. Dim db As DAO.Database Dim qry As DAO.QueryDef Set db = CurrentDb Set qry =...- kpeasley
- Post #3
- Forum: Microsoft: Access Forms
-
converting result of dynamic sql to int
I've tried both of these things (cast and another variable) and I get the same error. Syntax error converting the nvarchar value 'Select appid from appsecurity.dbo.secapp where d095 = 1' to a column of data type int. Can I use an output variable with in a stored procedure somehow?- kpeasley
- Post #3
- Forum: Microsoft SQL Server: Programming
-
converting result of dynamic sql to int
I am trying to insert the result of a dynamic SQL query into a table. I need to convert the result to int but my code is trying to convert the dynamic SQL string to int (i.e. error converting 'select appid...') instead of the value returned by the query. declare @fieldnm nvarchar(5), @value...- kpeasley
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
