Path: utzoo!mnetor!uunet!lll-winken!lll-tis!ames!pasteur!ucbvax!decwrl!labrea!rutgers!topaz.rutgers.edu!paone From: paone@topaz.rutgers.edu (Phil Paone) Newsgroups: comp.databases Subject: Informix SQL Questions Message-ID: Date: 22 Apr 88 11:49:04 GMT Organization: Rutgers Univ., New Brunswick, N.J. Lines: 22 Keywords: Updating active set in memoery Hi, I am having a problem with informix 2.10. Following a query and any update or delete operation, doing a FETCH NEXT followed by a FETCH prior retrieves the data from the unaltered active set. The only statement that seems to suggest that it might work is the CURRENT OF option, but that only works without a scroll cursor which, in turn means no FETCH options other then next. Does anyone have any suggestions? I also am having problems using the sqlerrd[2] which is supposed to return the number of rows processed. Following the select, this number is ALWAYS 0. In testing, this seemed to work only if the SELECT involved a single table. Any input on either of these would be appreciated. Thanks, Phil Paone -- Phil Paone paone@topaz.rutgers.edu ihnp4!moss!oac!ppaone "Admiral...There be whales here"