Hi Claude, try to send a _REFRESH_ to the extended table....

Claude Rhéaume <claude.rheaume@VIDEOTRON.CA> on 29.02.2000 02:12:56

Bitte antworten an claude.rheaume@videotron.ca

An: SAS-L@LISTSERV.UGA.EDU Kopie: (Blindkopie: DeTeCSM HellriegelG/D/ExternalStaff/WLB) Thema: Question With SAS/AF

I have a problem with my screens.

My datas is in 5 files, I can access these with a view (Made by SQL)

My First screen is a Extended Table whose contains one field When i select a row i'm going to a second screen. In this screen i can modify a field (The same than in the first screen. Also i modifed the value in the physical data not in the view, it will be impossible) . At this moment if i'm going to ACCESS in view i see the right value. The update is right. but when i come back in my first screen the value wasn't changed. In the getrow section i use FETCHOBS(file,_Currow_) .... I Assume than SAS have a buffer to optimize the Up and Down scrolling... But how i can force the system to reread the physical file. I already try REWIND SETROW....

When i quit the application and i come back in application the value is right..

Thank you very much I need a respond as soon as possible if you can send me a email at

claude.rheaume@gvdl.com

Mit freundlichen Gruessen

DeTeCSM, Gerhard Hellriegel

WestLB Abteilung: 001-80622 Aderstr. 22 D - 40217 Duesseldorf Tel.: +49211 826 6173 Fax: +49211 826 5393