topic SQL statement to determine if record exists in Application Development and Automation Discussions

SQL statement to determine if record exists

Former Member — Wed, 07 May 2008 09:40:53 GMT

Hi all,

Does anyone know the SQL-statement to determine if a record in a table exists? I don't want to read any data into the working-storage, I just need the returncode. I think it's something like, "transfer no data...." but I can't find the

exact syntax.

And yes....points for good/helpful answers guaranteed!

Thanks in advance.

Ivo

Re: SQL statement to determine if record exists

former_member188827 — Wed, 07 May 2008 10:21:52 GMT

u cant use transporting no fields addition with db tables.its used with internal tables to chack whether a record exits or not.

u've to use simple select statment like..

Select single......from ..into ... where...

if sy-subrc = 0.

"record exists.

elseif sy-subrc eq 4.

"record doesnt exit.

endif.

Re: SQL statement to determine if record exists

Former Member — Wed, 07 May 2008 10:34:37 GMT

select single * from zark_alv_test where grade = 'G'.

if sy-subrc = 0 .

write : / 'Exists'.

else.

write : / 'Does not Exists'.

endif.

in this SELECT query u are jst checking and not fetching data into workarea this is one of the way and also performance wise advisable to use....

check the SY_SUBRC And then u will know whether the record exists in DB table .....

award points if useful thanks

Re: SQL statement to determine if record exists

Lakshmant1 — Wed, 07 May 2008 10:59:21 GMT

Hi Ivo,

Check FM TABLECOUNT.

Thanks

Lakshman