Re: Refreshing a Cursor

gerlachh@pirmasens-amedd.army.mil ("Mr H. Gerlach") writes: > Hello 4gl folks > <snip> > The problem is in a 4GL application with Add,Update,Previous,Next Capability > that after you updated a row, hit next and then previous again, that you > have the old values still displayed on the screen. I think this problem > is caused by the cursor thats opened. Is there a simple way to somehow > "refresh" the cursor without running another select?? > <snip> There is no "refresh cursor". The problem you describe occurs because a scroll cursor is implemented by building a temporary table. A common way around the problem you describe is to have the scroll cursor fetch only the primary key for the table, then do a fetch of the exact row using a separate cursor (or an in-line SELECT). As long as you're not updating the primary key, this works fine. HTH Irwin