On 11 Nov 2016, at 12:42, Simon Slavin wrote:
No. When you use a quote you update the 'last used on' date for that
table row.
I think that's actually a "yes".
IIUC, OP wishes to pick at random from the items which haven't yet
been
used in the current cycle. By simply using the 'last used on' date,
the first
item in each cycle is guaranteed to be the same, and the second, and
so on.
To do what I think he wants, he'll need an additional selection
criterion or two.
Best regards,
Niall O'Reilly
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
