The Following 3 Users Say Thank You to Markkyboy For This Useful Post: | ||
![]() |
2017-10-13
, 10:25
|
|
Posts: 6,436 |
Thanked: 12,701 times |
Joined on Nov 2011
@ Ängelholm, Sweden
|
#2
|
![]() |
2017-10-13
, 12:31
|
Community Council |
Posts: 4,920 |
Thanked: 12,867 times |
Joined on May 2012
@ Southerrn Finland
|
#3
|
The Following 5 Users Say Thank You to juiceme For This Useful Post: | ||
![]() |
2017-10-13
, 14:12
|
|
Posts: 433 |
Thanked: 727 times |
Joined on Oct 2012
@ Costa Blanca, Espaņa
|
#4
|
The Following User Says Thank You to Markkyboy For This Useful Post: | ||
![]() |
2017-10-13
, 14:18
|
Posts: 1,414 |
Thanked: 7,547 times |
Joined on Aug 2016
@ Estonia
|
#5
|
Simple answer - I don't - but when I add the new data it is all clumped at the bottom of the list in the Stations search window.
As per comment from coderus, I have read the documentation for sqlite3, there isn't much to read, the commands seem quite simple, but I've ended up with the same result as last time - the new stations are NOT listed alphabetically and are at the end of the list and so, when the app is used, the user is presented initially with all stations listed in alphabetical order, that is until the user scrolls to the bottom and finds a handful of stations in no particular order at all.
The Following 7 Users Say Thank You to rinigus For This Useful Post: | ||
![]() |
2017-10-13
, 17:03
|
|
Posts: 433 |
Thanked: 727 times |
Joined on Oct 2012
@ Costa Blanca, Espaņa
|
#6
|
The Following User Says Thank You to Markkyboy For This Useful Post: | ||
![]() |
2017-10-13
, 17:08
|
Posts: 177 |
Thanked: 427 times |
Joined on Sep 2017
|
#7
|
The Following User Says Thank You to suicidal_orange For This Useful Post: | ||
![]() |
2017-10-13
, 17:19
|
|
Posts: 433 |
Thanked: 727 times |
Joined on Oct 2012
@ Costa Blanca, Espaņa
|
#8
|
The Following User Says Thank You to Markkyboy For This Useful Post: | ||
![]() |
2017-10-13
, 17:39
|
|
Posts: 433 |
Thanked: 727 times |
Joined on Oct 2012
@ Costa Blanca, Espaņa
|
#10
|
The Following User Says Thank You to Markkyboy For This Useful Post: | ||
My question;
I have an SQLite file containing 2,500+ lines of code, each line is a train station on the UK rail network. The SQLIte file was compiled 2 years ago, since then, 18 NEW stations have been added.
I have tried many different methods to update my SQLite file and it always ends one of 3 undesirable outcomes;
1). No changes at all;
2). new stations are appended to the list but dumped at the bottom; not in alphabetical order;
3). the file is empty!!......
With the 18 new stations dumped at the bottom of the file, I coudln't find a way to simply rearrange the order and when I did find a way, it doesn't translate when the file is used; i.e the new stations are still physically clumped together at the bottom of the user list!......grrrrr.
The methods used were; a standalone Windows program called DB Browser for SQLite and then I tried SQLite commands in terminal (i.e. - 'sqlite> .open stationsDB.sqlite' ), but I cannot get the deisred result - all listed alphabetically as are the other 2500+ existing stations.
I think it is fair to say, I don't know what to do next, any help appreciated
Regards,
..oO(Don't just sit there standing around, pick up a shovel and sweep up!)Oo..