Thread
:
Editing/Appending SQLite files
View Single Post
Markkyboy
2017-10-13 , 20:35
Posts: 433 | Thanked: 727 times | Joined on Oct 2012 @ Costa Blanca, Espaņa
#
16
Originally Posted by
uvatbc
Markyyboy, how exactly are you trying to retrieve data?
Have you tried the following SQL statement:
Due to my browser throwing a wobbly/multiple posts/etc, there is an overlap, your command suggestion is exactly what I came up with, while it sorts it on screen, the list is still not sorted in the device - I am doing this by SSH, straight into the DB (this also requires that the temp DB created by the app found in '.config/harbour-nationalrail/' must be removed beforehand).
Presumably you have a Sailfish device, head to Jolla Store and download NationalRail app. By doing this, you will have the 'stationsDB.sqlite' file found in '/usr/share/harbour-nationalrail/data' folder
The sqlite list is out of date, there are more than 18 new stations to add to the list.....or I am now thinking the file should be made from scratch and incorporate a way to make updating easier in future releases.
__________________
..oO(Don't just sit there standing around, pick up a shovel and sweep up!)Oo..
Quote & Reply
|
The Following User Says Thank You to Markkyboy For This Useful Post:
juiceme
Markkyboy
View Public Profile
Send a private message to Markkyboy
Find all posts by Markkyboy