Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 28 Aug 2017, at 2:50pm, Csányi Pál wrote: > If I open the Probe.db to edit in Midnight Comander, then I find there > one line only, which begin like: > SQLite format 3^@^P^@^A^A^@@ ^@^@^@^B^@^@^@^C^@^@^@^ ... etc... > > So it is definitely a database file and not a

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 8/28/17, Csányi Pál wrote: > > When one finished entering SQL commands and used the ".quit" command > to exit the shell tool, then there will be not a text, but a database > file which can then be used on various devices, like smart phones, > etc. > correct -- D.

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

Hello Simon, 2017-08-28 15:28 GMT+02:00 Simon Slavin : > > On 28 Aug 2017, at 8:13am, Csányi Pál wrote: > >> I attach in this mail the Probe.db file to ask you to see it, whether >> is it really the database, or just a text file? > > This mailing list

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 28 Aug 2017, at 8:13am, Csányi Pál wrote: > I attach in this mail the Probe.db file to ask you to see it, whether > is it really the database, or just a text file? This mailing list ignores attachments. To see if it’s a database just try to open or type the file. If

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

2017-08-28 8:40 GMT+02:00 Simon Slavin : > > > On 28 Aug 2017, at 7:37am, J Decker wrote: > >> is redirection so hard? >> >> sqlite3 database.db < database.commands > > OP is learning and testing. If redirection doesn’t work, they don’t know > what’s

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 28 Aug 2017, at 7:37am, J Decker wrote: > is redirection so hard? > > sqlite3 database.db < database.commands OP is learning and testing. If redirection doesn’t work, they don’t know what’s wrong. The error messages in interactive mode are far clearer. Once they have

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

is redirection so hard? sqlite3 database.db < database.commands On Sun, Aug 27, 2017 at 10:31 PM, Simon Slavin wrote: > > > On 28 Aug 2017, at 6:25am, Csányi Pál wrote: > > > Probe.db is a list of SQL commands, stored as a text file, and not a > >

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 28 Aug 2017, at 6:25am, Csányi Pál wrote: > Probe.db is a list of SQL commands, stored as a text file, and not a > SQLite database. Then please do not use a name for this file ending in ".db". It is not a database. It is a list of commands. I suggest a name ending

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

Hello Simon, 2017-08-28 7:14 GMT+02:00 Simon Slavin : > > > On 28 Aug 2017, at 5:50am, Csányi Pál wrote: > >> When I am at sqlite> prompt, I enter SQL commands to create tables for >> the database Probe.db which is a file on my disk. >> >> In the

Re: [sqlite] Converting an sqlite database into format that an Android app can uses?

On 28 Aug 2017, at 5:50am, Csányi Pál wrote: > When I am at sqlite> prompt, I enter SQL commands to create tables for > the database Probe.db which is a file on my disk. > > In the Probe.db file are those SQL commands which I just entered and > naturally these line at the

[sqlite] Converting an sqlite database into format that an Android app can uses?

Hi, I am using sqlite3 on a command line, in an xterm window on Gentoo linux system. When I am at sqlite> prompt, I enter SQL commands to create tables for the database Probe.db which is a file on my disk. In the Probe.db file are those SQL commands which I just entered and naturally these line