Re: [sqlite] Sqlite3.exe command line tool - winXP

Well I've tried the following sqlite3 dbfile I get put to the command line. typed in the following and below is the results. sqlite> .show echo: off explain: on headers: on mode: explain nullvalue: "" output: stdout separator: "|" width: 4 13 4 4 4 13 2 13 sqlite> .schema

Re: [sqlite] Putting images into SQLite.

On Dec 6, 2009, at 6:17 PM, Jean-Christophe Deschamps wrote: > I was simply replying to the OP's actual question: > From what I read, it is necessary to have a programmatic interface to put images into a database. True? > > So, no, it isn't _necessary_ (but recommended). What is

[sqlite] char,ascii function in sqlite

hi , im using sqlite3 in debain i want to check the first character should not be an special character. [by before insert trigger] how to do it? i thought of using ascii function but i didnt find in sqlite. Greensparker -- View this message in context:

[sqlite] sqlite3_exec() returns SQLITE_OK but Database shows different result

Hi, I am accessing the same database from two different processes. From one of the process , I am able to create tables in runtime but when I am trying to create a table from another process in runtime on the same DB I am not able to create so. The strange part is that I find sqlite3_exec() is

Re: [sqlite] sqlite3_exec() returns SQLITE_OK but Database shows different result

Hi, I am accessing the same database from two different processes. From one of the process , I am able to create tables in runtime but when I am trying to create a table from another process in runtime on the same DB I am not able to create so. The strange part is that I find sqlite3_exec() is

Re: [sqlite] Better example of fk mismatch problem

On Dec 7, 2009, at 5:20 AM, Paul Shaffer wrote: > Thanks. Typo is only in my post edit, not in the actual software. > Your edit > is correct. Question still stands. The "parent key" of a foreign key relationship must be the primary key of its table, or else have a UNIQUE constraint on it. The

[sqlite] How do I properly import numbers from CSV?

On Sun, Dec 06, 2009 at 08:15:46PM -0600, Jay A. Kreibich wrote > On Sun, Dec 06, 2009 at 07:54:45PM -0500, Walter Dnes scratched on the wall: > > > The last few rows of the query output are... > > > > 2009| 9| 21 > > 2009| 9| 22 > > 2009| 9| 23 > > 2009| 9| 24 > > 2009| 9| 25 > >

Re: [sqlite] Putting images into SQLite.

Hello Ted, Sunday, December 6, 2009, 8:35:34 PM, you wrote: >>From what I read, it is necessary to have a programmatic interface to TRJ> put images into a database. True? TRJ> --- TRJ> TRJ> 3.14159265358979323846264338327950 Let

Re: [sqlite] Putting images into SQLite.

>You are correct. You proved that it is possible. > >part 2: What are the usual and convenient ways of inserting images >into a sqlite db? answer: Programmatically. I certainly don't dispute this, and I added to this effect: > It may not be the prefered way in most application, but it's >

Re: [sqlite] Not matching numbers in where clause

On Sun, Dec 06, 2009 at 07:54:45PM -0500, Walter Dnes scratched on the wall: > The last few rows of the query output are... > > 2009| 9| 21 > 2009| 9| 22 > 2009| 9| 23 > 2009| 9| 24 > 2009| 9| 25 > 2009| 9| 26 > 2009| 9| 27 > 2009| 9| 28 > 2009| 9| 29 > 2009| 9| 30 > >

Re: [sqlite] Putting images into SQLite.

On Sun, Dec 6, 2009 at 8:07 PM, Jean-Christophe Deschamps wrote: > >> > From what I read, it is necessary to have a programmatic interface to >> > put images into a database.  True? >> >>yes, but I am not sure what other kind of interface there could be? >>You can't imagine

Re: [sqlite] Putting images into SQLite.

On 7 Dec 2009, at 2:09am, Ted Rolle, Jr. wrote: > Stephan Wehner wrote: > > Base64? Then just add it with an .import statement? > I thought about that with MIME encoding. On a Mac I've used a script piping the result of the 'hexdump' into commands for the sqlite3

Re: [sqlite] Putting images into SQLite.

On Sun, 6 Dec 2009 17:57:06 -0800 Stephan Wehner wrote: Base64? Then just add it with an .import statement? I thought about that with MIME encoding. Ted --- 3.14159265358979323846264338327950 Let the

Re: [sqlite] Putting images into SQLite.

> > From what I read, it is necessary to have a programmatic interface to > > put images into a database. True? > >yes, but I am not sure what other kind of interface there could be? >You can't imagine putting an image into a sqlite db through the >command line shell application. Of course, you

Re: [sqlite] Putting images into SQLite.

On Sun, Dec 6, 2009 at 7:35 PM, Ted Rolle, Jr. wrote: > From what I read, it is necessary to have a programmatic interface to > put images into a database.  True? > .. yes, but I am not sure what other kind of interface there could be? You can't imagine putting an image into a

[sqlite] Putting images into SQLite.

>From what I read, it is necessary to have a programmatic interface to put images into a database. True? --- 3.14159265358979323846264338327950 Let the spirit of pi spread 2884197169399375105820974944592307 all around the world!

Re: [sqlite] Not matching numbers in where clause

I'm certainly not a SQlite guru, but >sqlite> select * from sqlite_master where name = 'dly04'; >table|dly04|dly04|1042384|CREATE TABLE dly04(i_stnid integer, >national_identifier varchar2(7), > local_year integer, local_month integer, local_day integer, etc, etc > > I then imported data

[sqlite] Not matching numbers in where clause

As part of "pandemic planning" at work, I'm trying to duplicate some Oracle functionality at home. I'm running into a problem with the "WHERE" clause that totally baffles me. The problem surfaced in a TCL program, but I can duplicate it from the sqlite3 command prompt, so I'll use that in this

Re: [sqlite] Sqlite3.exe command line tool - winXP

what tables do you have? sqlite> schema; from my mobile 434.851.1612 On Dec 5, 2009, at 11:31 PM, "dave lilley" wrote: > > I have been trying to (without much joy) get a list of rows from a > table > within an sqlite3 DB. > > I've been starting from the CMD prompt sqite3 >

Re: [sqlite] Better example of fk mismatch problem

Thanks. Typo is only in my post edit, not in the actual software. Your edit is correct. Question still stands. > On Sun, 06 Dec 2009 00:05:28 -0700, Paul Shaffer > wrote: > >> I found where I was getting a 'foreign key mismatch' error, but I don't >> know why. There are

Re: [sqlite] Better example of fk mismatch problem

On Sun, 06 Dec 2009 00:05:28 -0700, Paul Shaffer wrote: >I found where I was getting a 'foreign key mismatch' error, but I don't >know why. There are 2 versions of the last table below. They look like they >are about the same to me, but one causes the error. The error

Re: [sqlite] SQL selecting in two related tables?

Your requirement is not quite clear to me: " I want the number of issues in a subscrpition for each magazine". The magazine whose id is n086 has two subscriptions in your example. Is it possible for a given magazine to have subscriptions with a different number of issues? E.g. a one-year

Re: [sqlite] Multiples natural left joins problem

2009/12/6 Yuzem : > > Is this a bug in new versions that will be fixed or it is the new behavior? In 3.6.20, so long as you include the alias, you will get your expected results: SELECT movies.id, title, files, icon_modified, icon_width FROM ( movies NATURAL LEFT JOIN files)

Re: [sqlite] Multiples natural left joins problem

Is this a bug in new versions that will be fixed or it is the new behavior? -- View this message in context: http://old.nabble.com/Multiples-natural-left-joins-problem-tp26627140p2730.html Sent from the SQLite mailing list archive at Nabble.com.