Hello all,
I've searched the list archive and didn't find any mention of this.
Google has lots of hits, but every board posting with a resolution was
left as 'resolved' with little explanation. :(
I have clean install of Debian Etch with lighttpd, php5-cgi,
php-sqlite3, xml_core, sqlite3,
Hi,
I am having problems with SQLite v3.5.7 on AIX v5.2.
I downloaded the amalgamation tarball. It looks like
it builds fine, but I get an error when I try to
create a table.
Here's what I'm doing/getting:
AIX$ ./sqlite3 test.db
SQLite version 3.5.7
Enter ".help" for instructions
sqlite>
te but I notice there is no way to mark a column as
>> containing dates... What is the standard way to do operations with dates,
>> please, and to store dates? Should I try the format 20080405 and do my
>> own
>> calculations using my language's standard library? (I'm using Python
Keith Stemmer schrieb:
> Yes, I can add a custom collation which works for ASCII chars LOL.
>
Plain wrong
> If you don't understand the problem, just don't reply.
>
>
Plain unreasonable
carefulle read ( and understand) this
http://sqlite.org/c3ref/create_collation.html
and this
I mentioned, right?
Thank you.
Dennis Cote-2 wrote:
>
> sqlfan wrote:
>> I'm very new to sqlite but I notice there is no way to mark a column as
>> containing dates... What is the standard way to do operations with dates,
>> please, and to store dates? Should I try the
Yes, I can add a custom collation which works for ASCII chars LOL.
If you don't understand the problem, just don't reply.
By the way, you can read on the SQLite website that the developer describes
my problem as a BUG which is nice to read. At least he doesn't call it a
feature.
Keith.
> >
>What did you download from
>http://www.sqlite.org/download.html ?
>sqlite-3.5.7.so.gz, or
>sqlite-amalgamation-3.5.7.tar.gz?
I've installed sqlite-3.5.7 precompiled package on my slackware system. Below
there is results of searches:
bash-3.1# find / -name sqlite3.c
bash-3.1#
bash-3.1#
They are one and the same. Look up collations.
On Sat, Apr 5, 2008 at 2:55 PM, Keith Stemmer
<[EMAIL PROTECTED]> wrote:
> That was not was I was talking about. I was not talking about Sort Order but
> about Searches.
> Keith
>
>
>
> On Sat, Apr 5, 2008 at 11:42 PM, Cory Nelson <[EMAIL
Sort order is highly dependent on locale. You can add custom
collations to do this.
On Sat, Apr 5, 2008 at 10:41 AM, Keith Stemmer
<[EMAIL PROTECTED]> wrote:
> Hello!
>
> I found SQLite quite amazing, but I think there is one showstopper for me.
> It seems that searches for Unicode strings are
dark0s dark0s wrote:
> sqlite3.c is not present in the system
>
> I type
>
> gcc CreaDB.c sqlite3.c -o CreaDB
>
> but after I don't find CreaDB also in my system.
>
You mentioned earlier that you are new to SQLite, but it seems you are
new to C programming as well. The following assumes
I type also:
bash-3.1# find / -name sqlite3.c
bash-3.1#
sqlite3.c is not present in my system, and after
bash-3.1# gcc CreaDB.c sqlite3.c -o CreaDb
gcc: sqlite3.c: No such file or directory
CreaDB.c: In function 'main':
CreaDB.c:21: warning: incompatible implicit declaration of built-in
bash-3.1# gcc CreaDB.c sqlite3.c -o CreaDb
gcc: sqlite3.c: No such file or directory
CreaDB.c: In function 'main':
CreaDB.c:21: warning: incompatible implicit declaration of built-in function
'strlen'
CreaDB.c:5: warning: return type of 'main' is not 'int'
CreaDB.c:41:3: warning: no newline at
On Sat, 5 Apr 2008 18:16:47 +0200 (CEST)
dark0s dark0s <[EMAIL PROTECTED]> wrote:
> Hi all, I am newbye in sqlite programming.
> I written a little C program to begin with sqlite, and I posted it below:
>
> #include
> #include
> #include
>
> void main() {
>
> int rc, i;
> sqlite3* db;
>
sqlite3.c is not present in the system
I type
gcc CreaDB.c sqlite3.c -o CreaDB
but after I don't find CreaDB also in my system.
savio
-
Inviato da Yahoo! Mail.
La casella di posta intelligente.
___
Ok, excuse my ignorance, how can I to connect dinamic library with gcc
Thanks,
savio
-
Inviato da Yahoo! Mail.
La casella di posta intelligente.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello!
I found SQLite quite amazing, but I think there is one showstopper for me.
It seems that searches for Unicode strings are case sensitive and there is
no (easy) way around that.
Could you please confirm or deny this?
Your explanation...
(A bug: SQLite only understands upper/lower case for
dark0s dark0s wrote:
> I written a little C program to begin with sqlite, and I posted it below:
>
> CreaDB.c:(.text+0x1f): undefined reference to `sqlite3_open'
> What is the problem?
>
>
You need to link to the sqlite3 library, or add the sqlite3.c
amalgamation source file to your compile
sqlfan wrote:
> I'm very new to sqlite but I notice there is no way to mark a column as
> containing dates... What is the standard way to do operations with dates,
> please, and to store dates? Should I try the format 20080405 and do my own
> calculations using my language's stan
tiggyboo wrote:
> I created and populated a table via sqlite3 on a Mac OSX machine, and have no
> problem working with it from the sqlite3 prompt. However, when I try to
> access the sole table (named cftable) in this database via a very simple
> Adobe AIR application I'm working on, I get this
D. Richard Hipp a écrit :
>> Thank you for your answer D. Richard,
>>
>> So I continue the translation and I will see fossil for future.
>> Can you take a ticket for this evolution ?
>>
>>
>
>
> We can work with you to import your translation whenever
> you are ready.
>
>
> D. Richard Hipp
>
>
> Thank you for your answer D. Richard,
>
> So I continue the translation and I will see fossil for future.
> Can you take a ticket for this evolution ?
>
We can work with you to import your translation whenever
you are ready.
D. Richard Hipp
[EMAIL PROTECTED]
D. Richard Hipp a écrit :
> On Apr 5, 2008, at 10:28 AM, Yves Maingoy wrote:
>
>> Hello All and Drh,
>>
>> I am a french user of SQLite and I started to translate it's
>> documentation.
>>
>> I use the tclsh scripts on Windows (with WinTcltk) and I produce
>> html pages from *.in sources
Hi all, I am newbye in sqlite programming.
I written a little C program to begin with sqlite, and I posted it below:
#include
#include
#include
void main() {
int rc, i;
sqlite3* db;
sqlite3_stmt* stmt;
char* sql;
const char* tail;
rc = sqlite3_open("prova.db", );
if (rc) {
I'm very new to sqlite but I notice there is no way to mark a column as
containing dates... What is the standard way to do operations with dates,
please, and to store dates? Should I try the format 20080405 and do my own
calculations using my language's standard library? (I'm using Python
On Apr 5, 2008, at 10:28 AM, Yves Maingoy wrote:
> Hello All and Drh,
>
> I am a french user of SQLite and I started to translate it's
> documentation.
>
> I use the tclsh scripts on Windows (with WinTcltk) and I produce
> html pages from *.in sources files found at
Hello All and Drh,
I am a french user of SQLite and I started to translate it's documentation.
I use the tclsh scripts on Windows (with WinTcltk) and I produce html pages
from *.in sources files found at http://www.sqlite.org/docsrc
The documentation is 20% translated at this time and I
Hi,
If this is a production system? Then I'd do the following:
1. Make a backup.
2. Run Vacuum manually.
I would automate this as part of a periodic maintenance schedule,
(weekly/bi-weekly etc..)
This is given then number of bugs and issues with DB corruption when
I created and populated a table via sqlite3 on a Mac OSX machine, and have no
problem working with it from the sqlite3 prompt. However, when I try to
access the sole table (named cftable) in this database via a very simple
Adobe AIR application I'm working on, I get this error:
Error #3115:
In general I believe that is a good idea give to the developer the maximun
control of what happen under the hood.
Greetings
Adolfo
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]
Sent: Friday, April 4, 2008 08:15 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] ticket 3007
Any
Dennis Wrote:
>If you want to update the AlbumName field, you must do that with an
>update statement running on the Album table, not the Music table, since
>that is where the AlbumName field is stored. You haven't said what you
>want to update the AlbumName or ArtistName to. You probably have
30 matches
Mail list logo