topic Re: Entries from database table in Application Development and Automation Discussions

Entries from database table

Former Member — Tue, 19 Jun 2007 01:47:54 GMT

Hi all,

I need to fetch the first record from a data base table. I don't have any primary keys. Infact without using any primary keys i just need to select the first records from the table.

I have used select single and select up to 1 rows (I should not use order by primary), some times it gives me the correct result and sometimes not.

Can you tell me any other way to do it.

Thanks.

Mungala.

Re: Entries from database table

Former Member — Tue, 19 Jun 2007 01:51:14 GMT

Hi Praveena,

Can you try

SELECT * from DBtable....

<b>if sy-subrc = 0.

exit.

endif.

ENDSELECT.</b>

Reward points if useful.

Regards,

Atish

Re: Entries from database table

Former Member — Tue, 19 Jun 2007 01:59:41 GMT

DATA WA_SFLIGHT like SFLIGHT occurs 0 with header line.

SELECT * FROM SFLIGHT INTO table WA_SFLIGHT up to 1 rows

ORDER BY planetype DESCENDING.

Re: Entries from database table

Former Member — Tue, 19 Jun 2007 02:20:47 GMT

Hello Praveena,

Try this method.

Select * from dbtable into wa_tab.

if sy-subrc = 0.

exit.

endif.

endselect.

Rgds,

Naren