ok, here's the thing. I execute the SP in SSMS and it runs with no error. Doesn't produce a file, either.



>>Hello all
>>
>>In the following SP, I'm getting an "Error near ',' " error - which is just about as descriptive as "black cat at night"
>>@TestSub = '21'
>>@TestSection = 'L'
>>
>>The command from Fox is
>>
>>ms1 = SQLExec(Thisform.r_conn, m.sqlcmd + m.param1)
>>
>>Where
>>m.sqlcmd = "Execute CreateSubFile" and
>>m.param1 = "?Thisform.r_TestSection, ?Thisform.r_Testfile"
>>
>>If I execute the SP - it runs just fine. What am I not seeing?
>>
>>

>>ALTER PROCEDURE [dbo].[CreateSubFile]
>>    @TestSection	nchar(1),
>>    @TestSub	nchar(1)
>>	
>>ASBEGIN
>>  declare @iError int, @iRowCnt int
>>  -- SET NOCOUNT ON added to prevent extra result sets from
>>  -- interfering with SELECT statements.
>>  SET NOCOUNT ON;
>>  select SubID = 0, Category, CorrectResp, Stem, RespA, RespB, RespC, RespD, OrigItmID
>>        into #SubFile from CATMaster 
>>        where 1 = 0
>>	
>>  if @TestSection = 'L'
>>      Insert into #Subfile select SubID = MasterID, Category, CorrectResp, Stem, 
>>        RespA, RespB, RespC, RespD, OrigItmID
>>        from CATMaster 
>>        where MasterID in (Select CatID from CATStats where subbank = @TestSub)
>>        and Category in ('40','41')
>>  else
>>      insert into #Subfile select SubID = MasterID, Category, CorrectResp, Stem, RespA, RespB, RespC, RespD, OrigItmID
>>        from CATMaster 
>>        where MasterID in (Select CatID from CATStats where subbank = @TestSub)
>>        and Category >= '50'
>>    
>>  select @iError = @@error, @iRowCnt = @@rowcount
>>    
>>  if @iError > 0
>>      begin
>>        raiserror('Error on Insert into Invoice -  %d',16,1, @iError) 
>>         --Set @MsgErr = 'Error on Insert into Mastere -  %d'
>>      end
>>END
>>

>
>Try to execute the same SP with SSMS with the same parameters passed, that way you will see on wich line you get this error.