Re: [sqlite] Selecting NEXT / PREVIOUS recurring item in a column

Hi Richard. Thanks for the suggestion. It makes lots of sense but unfortunately I am unable to test it.. Completely out of the blue yesterday I got this error message and OpenSuse is no longer starting on VirtualBox (Mac). Really weird because I didn't make any changes... In the previous days it

[sqlite] TEXT shows as (WIDEMEMO) in DBGrid

Hi, I am using Delphi 10.1 and I am trying to learn how to handle FireDAC with SQLite as a database. Beeing used to ADO and Access I find the learning curve a bit steep! My simple project: I have build a simple SQLite database with only 2 fields: a primary key integer and a text field, like this:

Re: [sqlite] Selecting NEXT / PREVIOUS recurring item in a column

On 8/6/17 4:03 PM, Edmondo Borasio 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"? Let's

Re: [sqlite] Selecting NEXT / PREVIOUS recurring item in a column

Hi Simon, Yes, you are correct. The program should get me to the previous one which is 2 or the next one which is 6. It know it because I have previously manually selected that particular one. Regards, Edmondo ___ sqlite-users mailing list

Re: [sqlite] Selecting NEXT / PREVIOUS recurring item in a column

On 6 Aug 2017, at 9:03pm, Edmondo Borasio 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

[sqlite] Selecting NEXT / PREVIOUS recurring item in a column

*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"? Let's assume that I currently I am at progr_no=5. I

Re: [sqlite] SQLITE PHP syntax issues - INSERT INTO db

Edmondo Borasio wrote: > //If I input the $NewID manually as a string (for example '6', *it works > fine* and updates the db correctly) > *$query1="INSERT INTO > Table"."(ID,name,surname)"."VALUES('6','newName','newSurname');"; * > > //However if I try to use the $NewID variable from above *it

Re: [sqlite] sequencer

On Sun, Aug 6, 2017 at 6:34 PM, Sylvain Pointeau wrote: > Dear all, > > you can now find the code on github with a BSD3 license, as well as a > release providing the dll for windows > > forgot to add the link :-) https://github.com/spointeau/libsequence > I

Re: [sqlite] sequencer

Dear all, you can now find the code on github with a BSD3 license, as well as a release providing the dll for windows I provided a cmake file, only tested for mingw (I don't have other compiler), I hope other will contribute to support other compilers. Again thanks for all your support. Best