How to clear syntax check warning.?

[Former Member]

When I am using 'SELECT SINGLE ..." for selecting the single field from the table, I am getting the warning message when I am going with extended check of the program. Can anybody clear my warning message.?

"

syntax check warning

This warning is only displayed in SLIN in "SELECT SINGLE..." the WHERE condition for the key field "ERDAT" does not test for equality. Therefore, the single record in question may not be unique."

The code for the select single query is

" SELECT SINGLE vkorg

                  FROM vbak

                  INTO lv_vkorg

                  WHERE vkorg IN s_vkorg."

Thank you.

[Former Member]

When I am using 'SELECT SINGLE ..." for selecting the single field from the table, I am getting the warning message when I am going with extended check of the program. Can anybody clear my warning message.?

"

syntax check warning

This warning is only displayed in SLIN in "SELECT SINGLE..." the WHERE condition for the key field "ERDAT" does not test for equality. Therefore, the single record in question may not be unique."

The code for the select single query is

" SELECT SINGLE vkorg

                  FROM vbak

                  INTO lv_vkorg

                  WHERE vkorg IN s_vkorg."

Thank you.

[former_member196490]

Use SELECT UP TO 1 ROW... ENDSELECT instead of SELECT SINGLE if where condition does not contain the key fields. The warning would be removed

[ThomasZloch]

A very clear error message, please do a minimum of research before posting, for example read the F1 help for SELECT (SINGLE), search for available information and previous discussions.

Locked.

Thomas