4gl problem-jmuss

4gl problem of not seeing "updated" data when doing a next and previous fetch after doing an update. What you are fetching has already been retrieved from the database when you prepared and carried out cursor activities. The "old" data is still in the memory locations you fetched it into so fetching will bring it back unless you "update" your memory as well as your database. Depending on the application, you might want to reexecute the cursor activity to refresh your memory information or provide some other means of alerting the user that an update has indeed occurred whether you go through the cursor gyration again or not. Good luck -- Con Woodall Colorado St. U.; Veterinary Teaching Hospital; Ft. Collins CO 80523; 303-491-1244 FAX 303-491-4414 cwoodall@vth1.vth.colostate.edu Opinions not nec. employer's, but mine might be right. Then again... --