<< 2)Does this use an index? 3)The speed to retrieve the value will need to be very fast and this will be running on a network. >>
CAUTION: This is speculation on my part, but it's the way I've always understood WHERE COUNT = INSERT to work. I believe that a pointer to the most recent INSERTed row is actually stored in R:Base's memory at the time of insert. So when you retrieve the row, you're going directly to the correct address in the datafile, which would be even faster than using an index. And yes, R:Base can remember the last inserted row for each table separately. -- Larry
