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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create Cursor for stored procedure results?
I am trying to do the following: DECLARE @command varchar (1024) DECLARE login_curs CURSOR FOR exec REMOTE_SERVER.someDB.dbo.generate_sql_statements OPEN login_curs FETCH NEXT FROM login_curs INTO @command WHILE (@@fetch_status <> -1) BEGIN Exec sp_executesql @command FETCH NEXT FROM...- ubivis
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
How to Get Reference to a Control?
I am trying to pass a control to a subroutine. I have specified that a control is to be passed into the method: sub foo(ctrl as control) . . . end sub Then: call foo(some_control_name) However whenever I pass a control into the method it passes the value of the control into the method and not...- ubivis
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
