Re: rowid's changing - sperform use of rowids

Art S. Kagel wrote: > I do not remember, have not used sperform in ages, but perhaps the > problem is that sperform is really doing a delete and add rather than > an inplace update! Have you tried an explicit SQL UPDATE statements in > > Art S. Kagel sperform stores rowids (and the primary key, I think) in a temporary file to maintain its concept of a current list. When you press Next or Prev and the row no longer exists (or has moved?) you get the message "Someone else has deleted a row in your current list". I think sperform does a real UPDATE, although I haven't fiddled about with it for some time. It respects column-wise update privileges (clever, that - try doing it in 4GL...). -- Peter Lancashire Mail: Peter.Lancashire.PL1@bayer.co.uk Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 All opinions are my own and not those of Bayer plc.