Hi ol! I have a stored procedure that accepts 3 parameters. When I test it in the SQL Query Analyzer using the syntax...
execute _1001 '09/01/2004', '09/30/2004, '''341-111-01'''
... I get the correct results. But when I use the following syntax in VB...
rs=cn.Execute("_1001 '09/01/2004', '09/30/2004, '''341-111-01'''")
... I get the error message...
Run-time exception thrown : System.Runtime.InteropServices.COMException - [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '341'.
Any idea on this? By the way, I am using VB.NET and ADO 2.5 not ADO.NET. My store procedure looks something like this:
CREATE PROCEDURE _1001
@DateFrom DateTime,
@DateTo DateTime,
@AcctList varchar(100)
AS
DECLARE @Sql nvarchar(4000)
SET @Sql = 'SELECT DocNo, TrnDate, AccountID, Supplier ' +
'FROM TRNPOH ' +
'WHERE AccountID IN (' + @AcctList + ')'
EXECUTE(@Sql)
GO
Thanx! in advance!!!
Shit happens!!!