必须声明标量变量“@ FILEPATH”。 [英] Must declare the scalar variable "@FILEPATH".

问题描述

大家好，



我正在执行存储过程。

  exec  [K2_CHECKENTRYINFILELOG]  @ FILENAME  = '  harshal'，
  @ FILEPATH  = '  g：'，
  @ FILETYPE  =  1 ，
  @ FILEDATE  = '  22 -07-1990'，
  @ CIRCLEID  =  1 ，
  @ TOTALROWS  =  0 ，
  @ SUCCESSCOUNT  =  0 ，
  @ FAILURECOUNT  =  0 ，
  @ PROCESSED  =  1 ，
  @ ERROR  = ' 新记录'，
 < span class =code-sdkkeyword> @ VENDORID  =  0 ，
  @ CREATEDBY  =  1 ，
  @ CREATEDON  =  '  14-07-2014'，
  @ DELETED  =  0  
   -    @ FILELOGID bigINT  
 
  IF   NOT   EXISTS （
  select  count（CIRCLEID）来自 K2FILELOG 其中 FILEPATH =  @ FILEPATH  和 
 [FILENAME] =  @ FILENAME  和 
 FILETYPE =  @ FILETYPE  和 
 FILEDATE =  @ FILEDATE  和 
 CIRCLEID =  @ CIRCLEID  和 
 TOTALROWS =  @TOTALROWS  和 
 SUCCESSCOUNT =  @ SUCCESSCOUNT  和 
 FAILURECOUNT =  @ FAILURECOUNT  和 
 PROCESSED =  @已处理 和 
 ERROR =  @ ERROR  和 
 VENDORID =  @ VENDORID  和 
 CREATEDBY =  @ CREATEDBY  和 
 CREATEDON =  @ CREATEDON  和 
 DELETED =  @ DELETED ）

我收到错误

必须声明标量变量@FILEPATH。

请指导我。

干杯

harshal

解决方案

错误消息告诉你声明你的变量。

 < span class =code-comment> / *  声明您的变量... * /  
  DECLARE   @ FILENAME   VARCHAR （ 128 ）
  DECLARE   @ FILEPATH   VARCHAR （ 4 ）
  DECLARE   @FILETYPE   INT  
 ... 
 ... 
 ... 
  DECLARE   @ DELETED   BIT  
 
  / *   POPULATE VARIABLES ... * /  
  SELECT  
  @ FILENAME  = '  harshal'， 
  @ FILEPATH  = '  g：'，
  @ FILETYPE  =  1 ，
 ... 
 ... 
 ... 
  @ DELETED  =  0  
 
  / *  执行你的PROC ... * /  
  exec  [K2_CHECKENTRYINFILELOG]  @ FILENAME ， @ FILEPATH ，文件TYPE， @ FILEDATE ， @ CIRCLEID ， @ TOTALROWS ， @ SUCCESSCOUNT ， @ FAILURECOUNT ， @ PROCESSED ， @ ERROR ， @ VENDORID ， @ CREATEDBY ， @ CREATEDON ， @ DELETED ; 
 
  / *  继续使用您的变量* /  
  IF   NOT   EXISTS （
  select  count（CIRCLEID）来自 K2FILELOG 其中 FILEPATH =  @ FILEPATH  和 
 [FILENAME] =  @ FILENAME  和 
 FILETYPE =  @ FILETYPE  和 
 FILEDATE =  @ FILEDATE  和 
 CIRCLEID =  @ CIRCLEID  和 
 TOTALROWS =  @ TOTALROWS  < span class =code-keyword>和 
 SUCCESSCOUNT =  @ SUCCESSCOUNT  和 
 FAILURECOUNT =  @ FAILURECOUNT  和 
 PROCESSED =  @ PROCESSED  和 
 ERROR =  @ ERROR  和 
 VENDORID =  @ VENDORID  和 
 CREATEDBY =  @ CREATEDBY  和 
 CREATEDON =  @ CREATEDON  和 
 DELETED =  @ DELETED ）

Hi Everybody,

I am executing the Stored Procedure .

exec [K2_CHECKENTRYINFILELOG] @FILENAME ='harshal',
@FILEPATH ='g:',
@FILETYPE = 1,
@FILEDATE = '22-07-1990',
@CIRCLEID = 1,
@TOTALROWS  = 0,
@SUCCESSCOUNT = 0,
@FAILURECOUNT = 0,
@PROCESSED = 1,
@ERROR = 'New Record',
@VENDORID  = 0,
@CREATEDBY = 1,
@CREATEDON = '14-07-2014',
@DELETED = 0
--@FILELOGID bigINT

IF NOT EXISTS (
select count(CIRCLEID) from K2FILELOG where FILEPATH = @FILEPATH and
                                              [FILENAME] = @FILENAME and
                                              FILETYPE = @FILETYPE and
                                              FILEDATE = @FILEDATE and
                                              CIRCLEID = @CIRCLEID and
                                              TOTALROWS = @TOTALROWS and
                                              SUCCESSCOUNT = @SUCCESSCOUNT and
                                              FAILURECOUNT = @FAILURECOUNT and
                                              PROCESSED = @PROCESSED and
                                              ERROR = @ERROR and
                                              VENDORID = @VENDORID and
                                              CREATEDBY = @CREATEDBY and
                                              CREATEDON = @CREATEDON and
                                              DELETED = @DELETED)

I am getting the Error

Must declare the scalar variable "@FILEPATH".

Kindly Guide Me.
Cheers
harshal

解决方案

The error messsage is telling you to declare your variables.

/*DECLARE YOUR VARIABLES ... */
DECLARE @FILENAME VARCHAR(128)
DECLARE @FILEPATH VARCHAR(4)
DECLARE @FILETYPE INT
...
...
...
DECLARE @DELETED BIT

/*POPULATE VARIABLES ... */
SELECT 
    @FILENAME ='harshal',
    @FILEPATH ='g:',
    @FILETYPE = 1,
    ...
    ...
    ...
    @DELETED = 0

/*EXEC YOUR PROC ... */
exec [K2_CHECKENTRYINFILELOG] @FILENAME,@FILEPATH,FILETYPE,@FILEDATE,@CIRCLEID,@TOTALROWS,@SUCCESSCOUNT,@FAILURECOUNT,@PROCESSED,@ERROR,@VENDORID,@CREATEDBY,@CREATEDON,@DELETED;

/*CONTINUE USING YOUR VARIABLES*/
IF NOT EXISTS (
select count(CIRCLEID) from K2FILELOG where FILEPATH = @FILEPATH and
                                              [FILENAME] = @FILENAME and
                                              FILETYPE = @FILETYPE and
                                              FILEDATE = @FILEDATE and
                                              CIRCLEID = @CIRCLEID and
                                              TOTALROWS = @TOTALROWS and
                                              SUCCESSCOUNT = @SUCCESSCOUNT and
                                              FAILURECOUNT = @FAILURECOUNT and
                                              PROCESSED = @PROCESSED and
                                              ERROR = @ERROR and
                                              VENDORID = @VENDORID and
                                              CREATEDBY = @CREATEDBY and
                                              CREATEDON = @CREATEDON and
                                              DELETED = @DELETED)

这篇关于必须声明标量变量“@ FILEPATH”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！