If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pass Through Query - not returning rows
I've written some SQL, which when run on SQL Server 2005 returns rows.
Plugged this SQL into an Access 2003 pass through query, but when run it reports an error saying pass through query with return records set to true did not return any records. I've got other pass through queries in this Access database that work fine. The SQL in this query is more complicated and creates a temp table - could this be causing the problem? |
#2
|
|||
|
|||
Pass Through Query - not returning rows
hi Gary,
On 08.03.2010 10:38, Gary Watson wrote: The SQL in this query is more complicated and creates a temp table - could this be causing the problem? Yes, indeed. My crystal ball says that you're missing the mandatory NOCOUNT for multiple result sets, test it against any database, I used tempdb: SET NOCOUNT ON; DECLARE @user TABLE ( username SYSNAME ) ; INSERT INTO @user ( username ) VALUES ( SUSER_SNAME() ) ; SELECT * FROM @user ; mfG -- stefan -- |
Thread Tools | |
Display Modes | |
|
|