topic Re: Select in update mode.. in Application Development and Automation Discussions

Select in update mode..

Former Member — Wed, 06 Sep 2017 06:22:06 GMT

Hi All..

I have found one strange behavior with a select query in update mode. After doing PGI, one output type will trigger and associated smartform will get called via nast protocol. Inside that smartform i am using a select query to fetch data from some table and that select query returning expected values. But at the same time when i check in se16n table entries are not updated(created). So my doubt is, how select query returning values before database update?? I have tried select with bypassing buffer extension then also i can able to get values from select query?? Could anyone please explain what's the logic behind it and is there any extension to fail select query(SY-SUBRC <> 0) if database is not updated ??

Re: Select in update mode..

RaymondGiuseppi — Wed, 06 Sep 2017 06:55:09 GMT

Did you perform some search on database LUW and Isolation Levels (Here you select data modified in your own LUW, when SE16n executes in another one)

Re: Select in update mode..

Former Member — Wed, 06 Sep 2017 07:33:11 GMT

Hi,

Why not provide the results form the query to the function module that is used by the Smartform?

by the way I'm not a 'Gent', gender neutral heading would be appreciated.

Kind regards Simone

Re: Select in update mode..

Former Member — Wed, 06 Sep 2017 14:23:50 GMT

Thanks Raymond Giuseppi ..

Re: Select in update mode..

Former Member — Wed, 06 Sep 2017 14:25:14 GMT

Done. Sorry for the incnvenience.