Updating records 1 to n on an SQLite table

[KevinBrown]

Is there some reason you are using SQL for this?

At the end of a work session users need to retain many long lists of vendors, parts, clients purchase order etc. It makes a lot of sense to have such data saved. Previously using earlier software I would have used I/O random access files to store these clipboards.

In general I only need to add one new item at a time ( part , vendor , client etc) and I would like this new item to be near top of list (row 2). Additionally I often want to have items that I added last week near the top of the list, whereas items added 4-5 weeks ago would be well down a 300 item list.