>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?

That it runs the SP as it was before. The alter procedure didn't work.

>

>ALTER PROCEDURE [dbo].[CreateSubFile]
>    @TestSection	nchar(1),
>    @TestSub	nchar(1)
>	

Looks like this

>ASBEGIN

... is your problem.


>  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
>