topic Re: syntax error in Application Development and Automation Discussions

syntax error

Former Member — Wed, 09 Jul 2008 09:09:11 GMT

I got syntax error in following routine

PERFORM LOAD_EXCEL_FILE  TABLES RECORD
                          USING  FILE
                            CHANGING GV_TEXT.

************************************************************************
*       Form  LOAD_EXCEL_FILE
************************************************************************
FORM LOAD_EXCEL_FILE TABLES   P_UPLOAD
                     USING    P_FILENAME  LIKE RLGRAP-FILENAME
                     CHANGING GV_TEXT TYPE NATXT.

  DATA : IF_INTERN TYPE  KCDE_CELLS OCCURS 0 WITH HEADER LINE.
  DATA : VF_INDEX TYPE I.
  DATA : VF_START_COL TYPE I VALUE '1',
         VF_START_ROW TYPE I VALUE '1',
         VF_END_COL   TYPE I VALUE '256',
         VF_END_ROW   TYPE I VALUE '65536'.

  FIELD-SYMBOLS : <FS>.
  CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT'
    EXPORTING
      FILENAME                = P_FILENAME
      I_BEGIN_COL             = VF_START_COL
      I_BEGIN_ROW             = VF_START_ROW
      I_END_COL               = VF_END_COL
      I_END_ROW               = VF_END_ROW
    TABLES
      INTERN                  = IF_INTERN
    EXCEPTIONS
      INCONSISTENT_PARAMETERS = 1
      UPLOAD_OLE              = 2
      OTHERS                  = 3.
  IF SY-SUBRC <> 0.
    GV_TEXT = 'Excel file upload error.'.
    EXIT.
  ENDIF.

  IF IF_INTERN[] IS INITIAL.
    GV_TEXT = 'No Data Uploaded'.
  ELSE.
    SORT IF_INTERN BY ROW COL.
    LOOP AT IF_INTERN.
      IF SY-TABIX >= 0.          "Starts AT ROW 0, COL 0.
        MOVE : IF_INTERN-COL TO VF_INDEX.
        ASSIGN COMPONENT VF_INDEX OF STRUCTURE P_UPLOAD TO <FS>.
        MOVE : IF_INTERN-VALUE TO <FS>.
        AT END OF ROW.
          APPEND P_UPLOAD.
          CLEAR P_UPLOAD.
        ENDAT.
      ENDIF.
    ENDLOOP.
  ENDIF.

ENDFORM.                    " LOAD_EXCEL_FILE

Syntax errorr is

In PERFORM or CALL FUNCTION "LOAD_EXCEL_FILE", the actual parameter "FILE" is incompatible with the formal parameter "P_FILENAME"

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:11:01 GMT

Check how FILE is declared ..

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:11:38 GMT

Hi,

Check datatype of File.

it should be same in both form and perform.

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:11:55 GMT

Simple: check how you've defined your parameter FILE. It should be defined as TYPE RLGRAP-FILENAME...

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:12:11 GMT

Do this

data file type RLGRAP-FILENAME.

PERFORM LOAD_EXCEL_FILE TABLES RECORD

USING FILE

CHANGING GV_TEXT.

************************************************************************

Form LOAD_EXCEL_FILE

************************************************************************

FORM LOAD_EXCEL_FILE TABLES P_UPLOAD

USING P_FILENAME TYPE RLGRAP-FILENAME

CHANGING GV_TEXT TYPE NATXT.

Regards

Aditya

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:14:13 GMT

Hi,

The reaason for this may the actual and formal parameters are matching. Define the Variable FILE in PERFORM statement to be of same type as that defined in FORM statement.

I mean to say in your program declare like following:

DATA: FILE TYPE RLGRAP-FILENAME.

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:14:29 GMT

i declared like

PARAMETERS: file(30) TYPE c
                      DEFAULT '/export/remote/data.txt'
                      LOWER CASE
                      OBLIGATORY,

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:19:44 GMT

Hello

Try:

'C:\export\remote\data.txt'

Re: syntax error

Former Member — Wed, 09 Jul 2008 09:21:06 GMT

Hi,

PARAMETERS: file(30) TYPE c

DEFAULT '/export/remote/data.txt'

LOWER CASE

OBLIGATORY,

The filename which you have given in the above statement is not having the correct path. Give the correct path in the above statement. There is no directory of it.

For example :

' D:\sapdb\data\wrk\ID1\dbahist'