Select in update mode..

[Former Member]

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 ??

[RaymondGiuseppi]

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)

[Former Member]

Thanks Raymond Giuseppi ..

[Former Member]

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

[Former Member]

Done. Sorry for the incnvenience.