Hi Pavel,
Many thanks for your comments.I will try put together some better code and
if I have any issues I will ask again...
Thanks again
Lynton
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel Ivanov
Sent: Tuesd
"It's rather pointless to use a LIKE operator with no wildcards."
Except that it performs a case-insensitive comparison, so a quick-and-dirty
way to accomplish that.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Tand
Some elementary issue in my code, works fine now.
Tks
-Sreekumar
2011/9/6 Sreekumar TP
> I get the following error when I use % or _
>
> error @ 101, 1,1,unrecognized token: "'м"
>
>
>
> On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik wrote:
>
>> On 9/6/2011 11:41 AM, Sreekumar TP wrote:
>>
>>> I
I get the following error when I use % or _
error @ 101, 1,1,unrecognized token: "'м"
On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik wrote:
> On 9/6/2011 11:41 AM, Sreekumar TP wrote:
>
>> If I modify the statement to return all strings which match 'м' , No
>> strings
>> are fetched.
>>
>> zS
On 9/6/2011 11:41 AM, Sreekumar TP wrote:
If I modify the statement to return all strings which match 'м' , No strings
are fetched.
zSQL = sqlite3_snprintf(1024,temp2,"SELECT * FROM l1 WHERE data LIKE 'м'
;");
You probably want LIKE 'м%'. It's rather pointless to use a LIKE
operator with n
Hi,
I am using ICU library to collate and pattern match strings in Russian
language. I use C api to intialise the icu library .
sqlite3IcuInit(db);
zSQL = sqlite3_snprintf(1024,temp1,"SELECT icu_load_collation('ru_RU',
'RUSSIAN');");
sqlite3_prepare_v2(db,(const char *)zSQL,-1,&CollationStmt, NUL
> Well, in the first code example, yes you need to free your peekText pointer.
> Since you passed SQLITE_STATIC for the destructor parameter to
> sqlite3_bind_text, you should free it before you exit the function and not
> before. If you use SQLITE_TRANSIENT, you can free it immediately after the
Well, in the first code example, yes you need to free your peekText pointer.
Since you passed SQLITE_STATIC for the destructor parameter to
sqlite3_bind_text, you should free it before you exit the function and not
before. If you use SQLITE_TRANSIENT, you can free it immediately after the
bind cal
On Tue, 6 Sep 2011 03:17:23 -0400, Frank Chang
wrote:
> Kees Nuyt, I studied your producer-consumer
> multithreading further with respect to our proposed
> application. If the speed of MySQL reads is much faster
> than the the Speed of SQLite writes, then in the
> producer-consumer model , t
https://discussions.apple.com/message/15712311#15712311
--
Marco Bambini
http://www.sqlabs.com
On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote:
> Dear Technical Support:
>
> Please help me remove this error message:
>
> The procedure entry point sqlite3_wal_checkpoint could not be locat
Hi there,
I am a huge fan of SQLIte and have recently done some code that I am
debugging with TotalView and MemoryScape (http://www.roguewave.com) -
VERY VERY nice debugger, I have used GDB as well alot but Totalview is
simply awesome
NOTE: C coding is NOT my day job ;-)
I am using Me
Hi there,
I am a huge fan of SQLIte and have recently done some code that I am
debugging with TotalView and MemoryScape (http://www.roguewave.com) -
VERY VERY nice debugger, I have used GDB as well alot but Totalview is
simply awesome
NOTE: C coding is NOT my day job ;-)
I am using Mem
Dear Technical Support:
Please help me remove this error message:
The procedure entry point sqlite3_wal_checkpoint could not be located in the
dynamic link library SQlite3.dll
Please kindly send instructions on how to resolve this problem.
Thank you,
Lani Gonzales
_
Hi there,
I am a huge fan of SQLIte and have recently done some code that I am
debugging with TotalView and MemoryScape (http://www.roguewave.com) -
VERY VERY nice debugger, I have used GDB as well alot but Totalview is
simply awesome
NOTE: C coding is NOT my day job ;-)
I am using Mem
Hi there,
Thanks for your comments, and I am passing NULL now to the busy handler..;-)
I also say on the SQLite site that the pragma " default_cache_size " should
not be used anymore
(http://www.sqlite.org/pragma.html#pragma_default_cache_size )
("Do not use this pragma! This pragma is dep
On Tue, Sep 6, 2011 at 2:28 PM, Grice, Lynton (L) wrote:
> May I ask what you suggest with the way I am using the
> sqlite3_busy_handler? What is the "normal approach"? I have tried to look at
> examples etc
>
Hi!
i don't use the busy handler, so i can't say, but i do know that it is NEVER
valid
Hi Stephan,
Many thanks for your response, much appreciated...
May I ask what you suggest with the way I am using the sqlite3_busy_handler?
What is the "normal approach"? I have tried to look at examples etc
p = sqlite3_malloc(256);
sqlite3_busy_handler(handle, &eventLoggerBusyHandler, p);
sqli
While i can't answer the question about the leaks, i can say...
On Tue, Sep 6, 2011 at 10:49 AM, Grice, Lynton (L)
wrote:
> int queue_peekByTID(const char *tid, message *msg){
> What is wrong with my code above? Must I FREE the char*? Why would
> something say it was a "leak"?
>
This technically
2011/9/6 Alexey Pechnikov :
> 2011/9/6 jerome moliere :
>> Could you give me more details about corruption cases ?
>> Is there a list of contexts where we can get corrupted tables ?
>
> http://www.sqlite.org/howtocorrupt.html
Just one word : perfect
sorry for not having found it by myself
jerom
2011/9/6 jerome moliere :
> Could you give me more details about corruption cases ?
> Is there a list of contexts where we can get corrupted tables ?
http://www.sqlite.org/howtocorrupt.html
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
Hi there,
I am a huge fan of SQLite and have recently done some code that I am debugging
with TotalView and MemoryScape (http://www.roguewave.com) - VERY VERY nice
debugger, I have used GDB as well alot but Totalview is simply awesome
NOTE: C coding is NOT my day job ;-) So please bear with
>> Indicies can be very
>>> slow... may be the FTS4 table will be much faster for your queries.
>>
>> can you give more details about this concept ? what is the FTS4 table
>> ? I am sorry don't know what is is !!!
>
> See
> http://www.sqlite.org/fts3.html
> The full-text index is very fast and scal
2011/9/6 jerome moliere :
> Did you set corresponding pragmas
>> page_size, cache_size, journal_mode?
> page_size yes
> cache_size no because we are using a higher level cache (in Java)
> journal_mode is in the list of the pragmas to be tested through the
> benchmark setting this parameter to
Hi once again I will answer to these questions (most of them)
J.MOLIERE - Mentor/J
auteur Eyrolles
2011/9/6 Alexey Pechnikov :
> Jerome, can you show your database structure and queries?
no definetely not I can't for legal reasons..sorry
> Which FS is used?
the only one available on Windows M
Jerome, can you show your database structure and queries?
Which FS is used? Did you set corresponding pragmas
page_size, cache_size, journal_mode? Indicies can be very
slow... may be the FTS4 table will be much faster for your queries.
Do you use a prepared queries?.. Which type of storage are you
Hi Alexey,
I thought I answered to those questions but once again :
* my application runs on an embedded device (Honeywell 9900) , it's a
very complex application (too much I think)
and we are facing performance problems while inserting datas (about
500 objects to be inserted inducing about 2000 qu
Kees Nuyt, I studied your producer-consumer multithreading further with respect
to our proposed application. If the speed of MySQL reads is much faster than
the the Speed of SQLite writes, then in the producer-consumer model , the
consumer will spend a lot of time waiting for the SQLite write t
27 matches
Mail list logo