topic Single quote in dynamic where condition in Application Development and Automation Discussions

Single quote in dynamic where condition

Former Member — Wed, 25 May 2005 19:19:40 GMT

BAPI_STUDENT_IDENTIFIC_ADD has a field called IDENTIFICATIONNUMBER. This field is later used in a dynamic where condition and causes a short dump when it contains a single quote. I will change the program that calls the BAPI to check for single quotes, but is there anything else I need to check for to ensure a correct where condition?

Thanks,

Dan

Re: Single quote in dynamic where condition

Former Member — Thu, 26 May 2005 07:14:37 GMT

Hi Dan,

You need to exclude the following characters:

CONTANTS:
  c_single_quote VALUE '''',
  c_double_quote VALUE '"',
  c_asteriks     VALUE '*'.

Regards,

Rob.

Re: Single quote in dynamic where condition

Former Member — Thu, 26 May 2005 09:08:38 GMT

Hi Dan,

The best way to ensure correctness of syntax of a dynamic where condition is:

Run the program in debugging mode, Get the Query that is generated dynamically and write it to some other ABAP program and perform syntax check.

This will help you to remove all the syntax errors.

Regards,

Darshil