Would anyone have a clue as to how I could end up with /usr/lib/libsqlite3.so.0
as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ?
cc -DTHREADSAFE=0 -c sqlite3.c
cc -DHAVE_READLINE=1 -o sqlite3 sqlite3.o shell.c -ldl -lreadline -ltermcap
-I/usr/include/readline
ar cru libsqlite3.a sqlite3.o
On Sunday 07 June 2009 10:51:05 Jay A. Kreibich wrote:
> > > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary
> > > > but also with a libsqlite3.a static lib. Could anyone suggest how I
> > > > could alter this Makefile to support these requirements please?
> >
> > Is there a p
On Sat, Jun 6, 2009 at 9:30 PM, John Machin wrote:
> Expected behaviour for various raw file contents:
>
> 1234 => one row, ok (with luck)
> 1234\n => one row, ok
> 1234\n\n => first row ok, 2nd is empty, expect error message
> 1234\n5678 => two rows, ok (with luck)
> 1234\n5678\n => two rows, ok
On 7/06/2009 11:38 AM, P Kishor wrote:
> On Sat, Jun 6, 2009 at 8:28 PM, Kelly Jones
> wrote:
>> On 6/6/09, P Kishor wrote:
>>> On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones
>>> wrote:
I have a text file onenum.txt with just "1234\n" in it, and a db w/
this schema:
sqlite> .sche
On 6/6/09, P Kishor wrote:
> On Sat, Jun 6, 2009 at 8:28 PM, Kelly Jones
> wrote:
>> On 6/6/09, P Kishor wrote:
>>> On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones
>>> wrote:
I have a text file onenum.txt with just "1234\n" in it, and a db w/
this schema:
sqlite> .schema
CREA
On 7/06/2009 11:28 AM, Kelly Jones wrote:
> On 6/6/09, P Kishor wrote:
>> On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones
>> wrote:
>>> I have a text file onenum.txt with just "1234\n" in it, and a db w/
>>> this schema:
>>>
>>> sqlite> .schema
>>> CREATE TABLE test (foo INTEGER PRIMARY KEY);
>>>
>>>
On Sat, Jun 6, 2009 at 8:28 PM, Kelly Jones wrote:
> On 6/6/09, P Kishor wrote:
>> On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones
>> wrote:
>>> I have a text file onenum.txt with just "1234\n" in it, and a db w/
>>> this schema:
>>>
>>> sqlite> .schema
>>> CREATE TABLE test (foo INTEGER PRIMARY KEY);
On 6/6/09, P Kishor wrote:
> On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones
> wrote:
>> I have a text file onenum.txt with just "1234\n" in it, and a db w/
>> this schema:
>>
>> sqlite> .schema
>> CREATE TABLE test (foo INTEGER PRIMARY KEY);
>>
>> When I import, it fails as follows:
>>
>> sqlite> .im
On Sun, Jun 07, 2009 at 09:26:03AM +1000, Mark Constable scratched on the wall:
> On Sunday 07 June 2009 00:15:21 Jay A. Kreibich wrote:
> > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary
> > > but also with a libsqlite3.a static lib. Could anyone suggest how I
> > > could al
On Sunday 07 June 2009 00:15:21 Jay A. Kreibich wrote:
> > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary
> > but also with a libsqlite3.a static lib. Could anyone suggest how I
> > could alter this Makefile to support these requirements please?
>
> Assuming you're using the
SNIP
>> processed by a complied virtual machine. Threads switch at the
>> machine code level, so a thread could switch between the processing
>> of the 'g' and the 'i' of the first 'begin'.
>>
>
> SQLite actually maintains a mutex per connection. Every API call
> acquires this mutext and kee
It looks as if one of your test fields is not formatted as a valid
nteger or is pperhaps a duplicate.
Try initially loading your data into a table with a column specified as
a real number and not defined as the primary key. If it succeeds use
the table to search for duplicates and non-integer
Hello
If anyone find it interesting, please use.
http://dicionario-aberto.net/sqlite-db.png
Also, be free to put it on sqlite.org or something.
Cheers
Alberto
--
Alberto Simões
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
P Kishor wrote:
> 2009/6/4 "Andrés G. Aragoneses" :
>> Igor Tandetnik wrote:
>>> "Andrés G. Aragoneses"
>>> wrote:
My query, which I want to make it return the first row:
SELECT * FROM SomeTable WHERE Path+FileName LIKE '%user/File%'
>>> SELECT * FROM SomeTable WHERE Path || FileNam
On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones wrote:
> I have a text file onenum.txt with just "1234\n" in it, and a db w/
> this schema:
>
> sqlite> .schema
> CREATE TABLE test (foo INTEGER PRIMARY KEY);
>
> When I import, it fails as follows:
>
> sqlite> .import onenum.txt test
> Error: datatype mi
I have a text file onenum.txt with just "1234\n" in it, and a db w/
this schema:
sqlite> .schema
CREATE TABLE test (foo INTEGER PRIMARY KEY);
When I import, it fails as follows:
sqlite> .import onenum.txt test
Error: datatype mismatch
Is sqlite3 treating "1234" as a string or something? Short o
On Sat, Jun 06, 2009 at 04:31:30PM +1000, Mark Constable scratched on the wall:
> Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary
> but also with a libsqlite3.a static lib. Could anyone suggest how I
> could alter this Makefile to support these requirements please?
Assuming y
2009/6/5 Ann Shipley :
> I am trying to install Google Adwords Editor and when it attempts to open I
> receive a message "AdWords Editor has stopped working. A problem has caused
> it to stop working correctly. Windows will notify if there is a solution."
> Then a window opens stating "Solve a pr
I am trying to install Google Adwords Editor and when it attempts to open I
receive a message "AdWords Editor has stopped working. A problem has caused
it to stop working correctly. Windows will notify if there is a solution."
Then a window opens stating "Solve a problem with SQLite3" and when I
19 matches
Mail list logo