topic Re: Table Buffering in Application Development and Automation Discussions

Table Buffering

Former Member — Wed, 02 May 2007 04:37:40 GMT

"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 — Wed, 02 May 2007 04:40:51 GMT

You can bypass the table buffer using the addition:

BYPASSING BUFFER in the SELECT statement

Regards

Wenceslaus

Former Member — Wed, 02 May 2007 04:42:39 GMT

hi,

try like this

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

BUFFER.

if helpful reward

ravi

Former Member — Wed, 02 May 2007 04:48:40 GMT

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 — Wed, 02 May 2007 04:56:10 GMT

Hi sriram,

There are three ways to overcome this particular problem.....

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

2. Simply uncheck the check box in the technical settings if you have authorization.....

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

Hope this is very helpful for you.

Reward all helpful answers.

Regards,

V.Raghavender.