Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

On Thu, Jul 01, 2010 at 03:44:52PM +0100, Simon Slavin scratched on the wall: > > There is no such datatype as 'INT' in SQLite. SQLite doesn't have defined datatypes, so I suppose you could say this is correct. But if you want to say that SQLite has no 'INT' datatype, it is just as

Re: [sqlite] Bug with commandline option -csv and -separator

On Thu, Jul 01, 2010 at 12:22:14PM +0200, Buschhardt, Thomas scratched on the wall: > Error: sqlite3 -separator ";" -csv ... > > The separator will ignored. > > Workaround: sqlite3 -csv -separator ";" ... For what it is worth, this is the exact same inside the shell: $ ./sqlite3 SQLite

Re: [sqlite] [sqlite-dev] working with an existing (look-up) SQLite database in Eclipse

This type of questions should go to sqlite-us...@sqlite.org. Forwarding you there. Pavel On Thu, Jul 1, 2010 at 6:52 PM, wrote: > I am pretty new to Android but not new to programming. > > I want to do something that I thought was fairly simple, but can't seem to > find any

Re: [sqlite] problem with auto boot

On 1 Jul 2010, at 11:56am, Daniel Jung wrote: > My problem: I wrote a simple program in c-sharp. This program does > refers to a sqlite database. The program is in my auto boot so it shall > run by starting by pc. But every time the is an exception that the > database could not be opened. I

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

Thanks Tim for taking the time to point this out. On 1 July 2010 13:41, Tim Romano wrote: > If cross-implementation portability is a stated design goal, Adobe's > departure from the "authoritative" behavior is indeed a bug. If > cross-implementation portability is

[sqlite] problem with auto boot

Hi, no idea if it's the right way or place but I have a question about the sqlite database. I did not found any solution in other forums or by using google. My problem: I wrote a simple program in c-sharp. This program does refers to a sqlite database. The program is in my auto boot so it

[sqlite] Bug with commandline option -csv and -separator

Error: sqlite3 -separator ";" -csv ... The separator will ignored. Workaround: sqlite3 -csv -separator ";" ... Occours on WinXP, SQLite version 3.6.23.1 -- Mit freundlichen Grüßen, Thomas Buschhardt Software-Entwickler Bereich IT Tel +49 3745 769 -301 Fax +49 3745 769 -334 eMail:

Re: [sqlite] Proposed new sqlite3_open_v3() in terface - offt

"Andy Gibbs" wrote on 1.7.2010 21:12:57: >Miha Vrhovnik wrote on 1/7/2010: >> >Content analysis details: (10.3 points, 7.0 required) >> > >> > pts rule name description >> > -- >> >-- >> > 2.4

Re: [sqlite] Proposed new sqlite3_open_v3() interface - offt

Miha Vrhovnik wrote on 1/7/2010:> >Content analysis details: (10.3 points, 7.0 required)> >> > pts rule name description> > -- --> > 2.4 DNS_FROM_OPENWHOIS RBL: Envelope sender listed in

Re: [sqlite] ARM Cross compilation problem

Matheus Ledesma wrote: > With "-ldl" after "-static" argument I receive the following error: > > balanca_simula_peso_io_paralela.c:632: warning: 'mseg1' may be used > uninitialized in this function > >

Re: [sqlite] ARM Cross compilation problem

With "-ldl" after "-static" argument I receive the following error: balanca_simula_peso_io_paralela.c:632: warning: 'mseg1' may be used uninitialized in this function /home/generic/CodeSourcery/Sourcery_G++_Lite/bin/../arm-none-linux-gnueabi/libc/lib/libsqlite3.a(sqlite3.o): In function

Re: [sqlite] ARM Cross compilation problem

Matheus Ledesma wrote: > "arm-none-linux-gnueabi-gcc -o balanca > balanca_simula_peso_io_paralela.c -Wall -W -O2 > -Wl,-R/home/generic/CodeSourcery/Sourcery_G++_Lite/lib -lsqlite3 > -lpthread -static" Try adding '-ldl' to your args. Eric -- Eric A. Smith Where a calculator on the ENIAC is

[sqlite] ARM Cross compilation problem

Dear friends, I was sucessfuly able to cross compile the source sqlite-amalgamation-3.6.23.1 and it's working in the target. The problem happens when I try to compile my program using the sqlite3 libraries. I get the following error messages:

Re: [sqlite] PRIMARY KEY - not unique?

On Wed, Jun 30, 2010 at 5:37 PM, Steve Hurst wrote: > Hi all, not sure if this is a bug or user error - any insight appreciated! > > I have a schema that defines a two column primary key on a table - the docs > indicate this will create a unique composite key.

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

> There is no such datatype as 'INT' in SQLite.  No part of SQLite should be > declaring /any/ column as having an affinity of 'INT'. Yet another holly war and another fake problem... :( Why SQLite shouldn't declare column as INT? Who is confused by that this time? Yes, I know that there's no

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

On 1 Jul 2010, at 2:49pm, Pavel Ivanov wrote: >> This is obviously wrong. The SELECT command from TABLE t could never have >> returned any INT values (because SQLite has no INT datatype). So why was >> TABLE t_copy created with an INT column ? > > Because three letters INT are enough to

Re: [sqlite] Proposed new sqlite3_open_v3() in terface - offt

"Andy Gibbs" wrote on 1.7.2010 15:05:01: >Content analysis details: (10.3 points, 7.0 required) > > pts rule name description > -- -- > 2.4 DNS_FROM_OPENWHOIS RBL: Envelope sender

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

Here is what I wrote to Jay earlier this morning but meant to send to the entire list. I am still in the habit of hitting Reply in Google Mail when I should be hitting a different button that also says Reply. Jay, I agree with 99.44% of what you say. If in the future ALTER TABLE would allow a

Re: [sqlite] Escaping binary data

On 1 July 2010 13:05, Andrew Wood wrote: > I apologise if this is in the documentation but I cant seem to follow it. > > Is there a function in the C/C++ API which will escape an array of > binary data. For example in MySQL there is the following function: > >

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

> This is obviously wrong.  The SELECT command from TABLE t could never have > returned any INT values (because SQLite has no INT datatype).  So why was > TABLE t_copy created with an INT column ? Because three letters INT are enough to assign INTEGER affinity to the column. > From

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

On 1 Jul 2010, at 2:21pm, Pavel Ivanov wrote: >> CREATE TABLE X as SELECT... >> syntax ought not to produce a table with an INT primary key if the prototype >> had INTEGER. The problem is not with primary keys, it's with the types of the columns in the table. The command is not CREATE TABLE

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

> No, I am not asking SQLite to "emulate an error" in Adobe's code. Rather I > am suggesting this: if SQLite is going to distinguish in any way between INT > and INTEGER on primary key definitions, the CREATE TABLE X as SELECT... > syntax ought not to produce a table with an INT primary key if the

Re: [sqlite] Proposed new sqlite3_open_v3() interface

On Monday, May 03, 2010 4:47 PM, D. Richard Hipp wrote: Subject: Proposed new sqlite3_open_v3() interface > Community feedback is requested for the following proposed new SQLite > C API: > >int sqlite3_open_v3(const char*, sqlite3**, int, const char*); > > The new database connection

Re: [sqlite] SQLite 3.7.0 coming soon....

I would be pleased to try that version, however I'm not sure if you already support the SEE extension ? At least I can't find it yet on the SEE Software Configuration System. Marcus Grimm D. Richard Hipp wrote: > We are in the final phases of development for SQLite version 3.7.0. > The key

Re: [sqlite] Escaping binary data

Andrew Wood schrieb: > I apologise if this is in the documentation but I cant seem to follow it. > > Is there a function in the C/C++ API which will escape an array of > binary data. For example in MySQL there is the following function: > > mysql_real_escape_string(,out,in,length); > > What Id

[sqlite] Escaping binary data

I apologise if this is in the documentation but I cant seem to follow it. Is there a function in the C/C++ API which will escape an array of binary data. For example in MySQL there is the following function: mysql_real_escape_string(,out,in,length); What Id like to do is take a char array in

Re: [sqlite] create table {table-name} as select.... table definition is imperfectly cloned

If cross-implementation portability is a stated design goal, Adobe's departure from the "authoritative" behavior is indeed a bug. If cross-implementation portability is not "officially" supported but is simply something that users might expect and attempt, then Adobe's departure from the

[sqlite] Fwd: Re: Yet another SQLite wrapper for C++

hi,   sorry for my late response, i was very busy the last few days (my wife was in hospital and i had to care about the kids, pets and house and still had to work :-)   i updated the sql.h.bz2 [http://greschenz.dyndns.org/downloads/sql.h.bz2] on my server and fixed that topic. you can now use

Re: [sqlite] SQLite 3.7.0 coming soon....

On Wednesday, June 30, 2010 7:21 PM, D. Richard Hipp wrote: > We are in the final phases of development for SQLite version 3.7.0. > The key enhancement over version 3.6.23.1 is support for the use of > write-ahead logs for transaction control. See > http://www.sqlite.org/draft/wal.html > for

Re: [sqlite] PRIMARY KEY - not unique?

ah, sorry ... Am 01.07.2010 09:49, schrieb Jan: > Which row (node_id, attribute) is not unique? > > Jan > > Am 30.06.2010 23:37, schrieb Steve Hurst: >> Hi all, not sure if this is a bug or user error - any insight appreciated! >> >> I have a schema that defines a two column primary key on a

Re: [sqlite] PRIMARY KEY - not unique?

Which row (node_id, attribute) is not unique? Jan Am 30.06.2010 23:37, schrieb Steve Hurst: > Hi all, not sure if this is a bug or user error - any insight appreciated! > > I have a schema that defines a two column primary key on a table - the docs > indicate this will create a unique composite