topic Re: Select count * is not working in Application Development and Automation Discussions

Select count * is not working

Former Member — Fri, 15 Feb 2008 08:23:41 GMT

Hi everybody.

I've got a very strange problem, when i'm doing a select count* the result is giving me a value that is not the maximum (but when i check the database table the maximum value is another..)

Could it be that the select command is not executing against the table, rather than the SAP cache??

If this is the case, how can i avoid this?? I mean force the select command to execute against de DB table.

thanks a lot.

Re: Select count * is not working

Former Member — Fri, 15 Feb 2008 08:33:14 GMT

to get max value of a table u can use

Select max( fld )............

Bypassing the SAP buffer with the above additions is a means to increase the performance when accessing buffered database tables. To explicitly bypass the SAP buffer in the SELECT statement, always use the addition BYPASSING BUFFER instead of the implicit behavior of the additions stated above.

Re: Select count * is not working

Former Member — Fri, 15 Feb 2008 08:42:41 GMT

Hi,

Can you paste your code here so that we can guess the problem.

Re: Select count * is not working

Former Member — Fri, 15 Feb 2008 08:48:18 GMT

select max( pernr )

into l_numero

from z22hr_t_001_ci

where pernr gt l_desde and

pernr lt l_hasta.

I will try bypassing buffer. I hope it'll work.