> I have never used this syntax, but I would also add the question " what > happens in a multi user environment"? If it always looks at just the last > row, then it would not always be the intended user's inserted row, but > perhaps another process's. > > I once heard that it was usually best to avoid using the record position/row > count in a table when possible if adhering to SQL structure. Buy hey, I > still use the COUNT = LAST in a few applications!
COUNT = INSERT is different from COUNT = LAST and is intended to be multi-user safe. R:Base is maintaining a pointer to the last row entered by that session of R:Base -- it will work regardless of whether other people add subsequent rows (although I don't know what happens if another session deletes the most recent row you added). -- Larry
