Table Buffering

[Former Member]

"A table is buffered. By select statement i dont want to get the data from table buffer. i want to get the data from database. how? "

Thanks in advance,

Sriram

[Former Member]

You can bypass the table buffer using the addition:

BYPASSING BUFFER in the SELECT statement

Regards

Wenceslaus

[Former Member]

You can bypass the table buffer using the addition:

BYPASSING BUFFER in the SELECT statement

Regards

Wenceslaus

[Former Member]

hi,

try like this

select <filed1> <filed2> from <db table > into corresponding fields of <itab> BYPASSING

BUFFER.

if helpful reward

ravi

[Former Member]

Hi Sriram,

When you want to by pass the buffer and get the updated data from the Database, Use the

SELECT *************** BYPASSING BUFFER.

The BYPASSING BUFFER is the keyword used to get the updated data directly from the DataBase without accessing the table buffer.

Reward all the helpful answers.

Regards

[Former Member]

Hi sriram,

<b>

There are three ways to overcome this particular problem.....</b>

1. In SELECT query write BY PASSING BUFFER.......or

2. Simply uncheck the check box in the technical settings <b>if you have authorization.....</b>

3.Write NATIVE SQL query.....as you know that it directly hits the underlying DATABASE.

<b>

Hope this is very helpful for you.</b>

<b>

Reward all helpful answers.</b>

Regards,

V.Raghavender.