Re: [sqlite] sqlite3ErrStr giving linker error

2004-10-06 Thread Eric Bohlman
Steve Frierdich wrote: The sqlite3ErrStr function is giving me a linker error when compiled. All the other sqlite version 3_0_7 functions used compile correctly. Sqlite is compiled in to a static library, and that library is used in a Win32 application compiled in visual studio. The exact

Re: [sqlite] sqlite3_trace args?

2004-10-06 Thread kervin
Clear's things up. Thanks! - Kervin Quoting Christian Smith <[EMAIL PROTECTED]>: > On Wed, 6 Oct 2004 [EMAIL PROTECTED] wrote: > > > > >Thanks, > > > >Question, why does transactions report the error whilst CREATE > >on its own returns success but secretly fails? > > Because the actual

[sqlite] Definition of temporary trigger

2004-10-06 Thread Eric Scouten
The documentation (http://www.sqlite.org/lang.html) isn't clear on this topic, so I want to check my assumption: Any trigger created by the statement CREATE TEMPORARY TRIGGER ... is visible only to the process that created it and is deleted upon termination of that process' connection to the

Re: [sqlite] sqlite3_trace args?

2004-10-06 Thread Christian Smith
On Wed, 6 Oct 2004 [EMAIL PROTECTED] wrote: > >Thanks, > >Question, why does transactions report the error whilst CREATE >on its own returns success but secretly fails? Because the actual CREATE succeeded. The COMMIT couldn't happen because of the ongoing VM from the non-finalized VM, hence the

Re: [sqlite] sqlite3_trace args?

2004-10-06 Thread kervin
Thanks, Eventually I did get into the source. I was just hoping there was more authorative documenation out there, other than my interpretation of what the source may be doing. Transactions solved the problem, thanks. Funny, it didn't help till I put the transaction BEGIN, CREATE, and COMMIT

[sqlite] sqlite3ErrStr giving linker error

2004-10-06 Thread Steve Frierdich
The sqlite3ErrStr function is giving me a linker error when compiled. All the other sqlite version 3_0_7 functions used compile correctly. Sqlite is compiled in to a static library, and that library is used in a Win32 application compiled in visual studio. The exact linker error that is shown

Re: [sqlite] version-info same for sqlite2 and sqlite3

2004-10-06 Thread Doug Currie
> Both sqlite2 and sqlite3 use --version-info "8:6:8" when creating > libsqlite.la & libsqlite3.la. I would think the version # needs to be > changed? Is "9:0:0" the right value? http://sources.redhat.com/autobook/autobook/autobook_91.html e

[sqlite] version-info same for sqlite2 and sqlite3

2004-10-06 Thread b.bum
Out of curiosity... Both sqlite2 and sqlite3 use --version-info "8:6:8" when creating libsqlite.la & libsqlite3.la. I would think the version # needs to be changed? b.bum

Re: [sqlite] CSV mode not correctly quoting output

2004-10-06 Thread D. Richard Hipp
b.bum wrote: Anyone know how to file a bug such that the formating isn't smushed into a single line? Read the "Formatting Hints" at the bottom of the bug entry page. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] CSV mode not correctly quoting output

2004-10-06 Thread Ron Aaron
On Wed, October 6, 2004 10:15, b.bum said: > I'll file a bug on this. Anyone know how to file a bug such that the > formating isn't smushed into a single line? I already logged a bug (#911) along with a fix -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853

[sqlite] CSV mode not correctly quoting output

2004-10-06 Thread b.bum
I'll file a bug on this. Anyone know how to file a bug such that the formating isn't smushed into a single line? Output from CSV mode is not properly quoted. An example (from sqlite3): sqlite> .mode csv sqlite> .header on sqlite> create table "Foo" ( foo, bar ); sqlite> insert

Re: [sqlite] Sorry - (was: RE: [sqlite] www.sqlite.com has disappeared)

2004-10-06 Thread Philip Hofstetter
Hi, Moore, Brad wrote: I must say that you all have been very gracious. On some lists I would have been flamed into oblivion for a foul-up like that. I appreciate the courtesy in the face of my bungling. I usually just let my MUA actually do send the confirmation. If everyone on the list does

RE: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Ishwar . Jasuja
Return Receipt Your RE: [sqlite] www.sqlite.com has disappeared document :

[sqlite] Outter join question of sqlite

2004-10-06 Thread Carfield Yim
Does sqlite support outter syntax which similar to oracle, or sybase, which don't need to change the FROM clause? Like tableA.columnA *= tableB.columnB or tableA.columnA = tableB.columnB ((+) ??

RE: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread sankara . narayanan
Return Receipt Your RE: [sqlite] www.sqlite.com has disappeared document :

RE: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Moore, Brad
The domain was just renewed on Sept 30, 2004 according to the official registrar records. Maybe Anothony is having server problems or something like that. Brad Moore -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 7:54 AM To: [EMAIL

Re: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread D. Richard Hipp
Ken Cooper wrote: I've had favorites linked to www.sqlite.com for some time now, working like a charm. Sqlite.com is controlled by Anothony P. Andrews in St. Gallen, Switzerland. (+41.41712224838) I have offered on several occasions to buy that domain name from him, but he has so far refused.

Re: [sqlite] sqlite3_trace args?

2004-10-06 Thread Christian Smith
On Tue, 5 Oct 2004 [EMAIL PROTECTED] wrote: > > >Hello, > >I am trying debugging my application ( Sqlite reports no errors >after a CREATE query, but the table does not exist ). Have you done this in a transaction? Check you haven't issued a BEGIN statement, and/or COMMIT the current

[sqlite] workaround for FULL OUTER JOIN?

2004-10-06 Thread Andreas Schuldei
Hi! i am building a testsuite for my user administration application for debian-edu. the database i implement stores the information that is first read in from some example ldap dumps (LDIFs) and then provides this (and inforamtion which is added later on) to the test scripts. this is my

Re: [sqlite] free memory from sqlite3_column_blob?

2004-10-06 Thread Cory Nelson
Not supposed to be freed, sqlite manages that in the statement. On Wed, 6 Oct 2004 02:12:12 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello again, > > How do I free memory returned from sqlite3_column_blob()? > > sqlite3_free() segfaults on that memory, and I don't see > anything

RE: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Ken Cooper
I've had favorites linked to www.sqlite.com for some time now, working like a charm. I'll update them, thanks. -Original Message- From: Eric Pankoke [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 05, 2004 11:42 PM To: [EMAIL PROTECTED] Subject: RE: [sqlite] www.sqlite.com has

RE: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Eric Pankoke
The address is www.sqlite.org. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Ken Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 1:38 AM To: [EMAIL PROTECTED] Subject: [sqlite] www.sqlite.com has disappeared

Re: [sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Tito Ciuro
On Oct 6, 2004, at 08:38, Ken Cooper wrote: Anyone else experiencing this? Do you mean http://www.sqlite.org? -- Tito

[sqlite] www.sqlite.com has disappeared

2004-10-06 Thread Ken Cooper
Anyone else experiencing this?

[sqlite] free memory from sqlite3_column_blob?

2004-10-06 Thread kervin
Hello again, How do I free memory returned from sqlite3_column_blob()? sqlite3_free() segfaults on that memory, and I don't see anything in the documentation about this. Thanks, Kervin