On 6 Aug 2017, at 9:03pm, Edmondo Borasio <edmondobora...@gmail.com> wrote:

> *progr_no* *ID*
> 1 grace
> *2* *john*
> 3 alan
> 4 tim
> *5* *john*
> *6* *john*
> 7 sandra
> *8* *john*
> 
> What is the simplest and most efficient way of telling SQLITE to select the
> NEXT or the PREVIOUS *progr_no *for a given recurring ID, let's say "john"?

Trying to understand this.  Are you saying that you start knowing "john" and 
want the program to produce NEXT = 6 ?  How should the program know which 
"john" you’re currently on ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to