topic Re: execute in Application Development and Automation Discussions

execute

Former Member — Thu, 26 Jul 2007 05:56:20 GMT

1) SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

2) SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

how above queries will execute.?

Re: execute

Former Member — Thu, 26 Jul 2007 06:02:12 GMT

1) will select one row of first record.

2)same as above,will select one record and exit

Regards,

Reema

Re: execute

seshatalpasai_madala — Thu, 26 Jul 2007 06:07:02 GMT

Hi,

Both will have the same effect.<b> Only difference is in the second case there is one more statement 'EXIT' for the program to excute, where as in the first case its not the case.</b>

Check with this program.

DATA: SBOOk_WA TYPE SBOOK.

SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

write: sbook_wa-carrid.

clear: sbook_wa.

SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

write: sbook_wa-carrid.

Regards,

Sesh

Re: execute

Former Member — Thu, 26 Jul 2007 06:07:40 GMT

i wanna know how execution takes place?

Re: execute

seshatalpasai_madala — Thu, 26 Jul 2007 06:08:30 GMT

Hi,

Both will have the same effect. Only difference is in the second case there is one more statement 'EXIT' for the program to excute, where as in the first case its not the case.

Check with this program.

DATA: SBOOk_WA TYPE SBOOK.

SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

write: sbook_wa-carrid.

clear: sbook_wa.

SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

write: sbook_wa-carrid.

Regards,

Sesh

Re: execute

Former Member — Thu, 26 Jul 2007 06:17:09 GMT

when the database is queried in both case.

1)the performance is better as it queries for one record by explicitly saying upto one row

2)It queries randomly and exits the loop.

Re: execute

Former Member — Thu, 26 Jul 2007 12:17:08 GMT

1) SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT

loop at SBOOK INTO SBOOK_WA WHERE CARRID = 'LH'. .

write: SBOOK_WA-CARRID

endloop.

above exp condition ok write carried.