topic Re: catch SAPSQL_INVALID_FIELDNAME error in Application Development and Automation Discussions

catch SAPSQL_INVALID_FIELDNAME error

Former Member — Thu, 10 Apr 2008 12:45:41 GMT

Hi,

Is it possible to cacht SAPSQL_INVALID_FIELDNAME error ?

When Im trying :

CATCH SYSTEM-EXCEPTIONS SAPSQL_INVALID_FIELDNAME = 1.

[...]

ENDCATCH.

I got an error that there is no such exception 😕

thx for help

Re: catch SAPSQL_INVALID_FIELDNAME error

Jelena_Perfiljeva — Fri, 11 Apr 2008 16:55:57 GMT

It is not possible to catch this exception. The program will have to be modified to prevent the occurrence of this exception.

Re: catch SAPSQL_INVALID_FIELDNAME error

Former Member — Tue, 15 Apr 2008 07:25:22 GMT

I cant doit in that way - I need to allow enter 'WHERE' caluse of SQL query by a user, so after that I need to determine if that query including where part is correct... cathing exception seem to be the easiest way.. 😕

Re: catch SAPSQL_INVALID_FIELDNAME error

Jelena_Perfiljeva — Tue, 15 Apr 2008 14:46:47 GMT

If you are in the release 6.10 or higher, try using TRY... CATCH technique and catch the exceptions of CX_SY_SQL_ERROR class. Here is an example from ABAP Help:

PARAMETERS: column TYPE c LENGTH 8, 
            value  TYPE c LENGTH 30. 

DATA spfli_wa TYPE spfli. 

DATA cond_syntax TYPE string. 

CONCATENATE column '= value' 
            INTO cond_syntax SEPARATED BY space. 

TRY. 
    SELECT SINGLE * 
           FROM spfli 
           INTO spfli_wa 
           WHERE (cond_syntax). 
  CATCH cx_sy_dynamic_osql_error. 
    MESSAGE `Wrong WHERE condition!` TYPE 'I'. 
ENDTRY.

Re: catch SAPSQL_INVALID_FIELDNAME error

Former Member — Wed, 16 Apr 2008 04:34:06 GMT

Hi ,,

According to your code it is not possible to catch the exception.

Regards,

Muneesh Gitta.