Kirby1
Last Activity: Sep 25 '07, 08:13 PM
Joined: Sep 24 '07
Location:
-
So, if I am following correctly, from your edit this is not the problem?? -
Since I am a very beginner in all this can you be a bit more specific. I am not sure what you mean by the following?
Ok, there're a few spots in the query that can yield multiple rows in single variable assignment statements. Let's run this one first:
Code: ( text )
SET @tabletime = (SELECT crdate FROM sysobjects
WHERE name = @table_name)
See if the subquery returns more than one record...Leave a comment:
-
It was working just fine before the system admin moved from the sql 7.0 to sql 2000??Leave a comment:
-
CREATE PROCEDURE dbo.pQryUtility ByFiscalYear
(@dStartDate varchar(128) , @dEndDate varchar(128), @sEFTType varchar(3))
AS
SET NOCOUNT ON
DECLARE @table_name sysname
/* Assign tablename_param value1 [_paramvalue2] ... */
SET @table_name = 'SG'
DECLARE @param0 varchar(128)
SET @param0 = @dStartDate
SET @param0 = REPLACE(@param0 , ' ', '')
SET @param0 = REPLACE(@param0 , '/', '')...Leave a comment:
-
Private Sub CmdCAAPreview_C lick()
On Error GoTo Err_CmdCAAPrevi ew_Click
' Preview report.
Dim strDocName As String
'Check to see that there is a value selected in the combo box of Fiscal year for Utilities
If IsNull(Me.CboCA ARec.Value) Then
MsgBox "You must select a Fiscal Year prior to view a report on CAA."
Me.CboCAARec.Se tFocus
Else...Leave a comment:
-
ODBC-- call failed.
ODBC call failed
--------------------------------------------------------------------------------
We have recently upgraded our SQL Server from 7.0 to 2000. Since then my Access database to generate reports on the data is giving this error when I try to display a report:
ODBC call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the... -
ODBC call failed
We have recently upgraded our SQL Server from 7.0 to 2000. Since then my Access database to generate reports on the data is giving this error when I try to display a report:
ODBC call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !, <,<=, >, >=, or when the subquery is used as an expression. (#512) [Microsoft][ODBC SQL...
No activity results to display
Leave a comment: