Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Tue, 04 Jul 2006 19:13:56 -0500 Von: John Stanton <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users Hi John I think, I understand what you will to say > Sqlite is a single file shared between users just like a

[sqlite] Querying a value with an ampersand

I have a company name as follows: Chemistry & chemicals I have plenty of those in my database which come with ampersands, now when i do a query i get nothing. How best can i write the query using a string with an ampersand as part of it. I am developing in a PHP/SQlite environment.

[sqlite] Syntax Errors with various strings?

Hi, When I have strings with "-", "!", "\" or similar characters I get a syntax error.. Now, I thought this would happen with a few of this chars so I made 2 routines in my program, one that converts each of this chars into a flag string, which then, by the other routine can be reverted to the

Re: [sqlite] Syntax Errors with various strings? & ...Ampersand

The solution I have adopted to both of these issues is to: 1. ensure all strings are enclosed by matching quotation marks, and 2. use the question mark substitution form of prepared statement with subsequent bind of parameters. This can only be done from a programming language and not the

Re: [sqlite] Syntax Errors with various strings?

Have you tried using the quote() function? >From http://www.sqlite.org/lang_expr.html quote(X)This routine returns a string which is the value of its argument suitable for inclusion into another SQL statement. Strings are surrounded by single-quotes with escapes on interior quotes as

Re: [sqlite] Multiple Users

> In order to this, the next question ;-) Is a physcial Locking to the > DB allways necessary, if more the one User (writer) connect to a DB > and a Table? That means, is it insufficient, if I handle only a > logical Locking in the Application instead of physcial Locking? As I understand it

Re: [sqlite] Multiple Users

Why not use optimistic locking (timestamp based pseudo locking)? It's ussually sufficient. Olaf - Original Message - From: "Nikki Locke" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 05, 2006 1:05 PM Subject: Re: [sqlite] Multiple Users > > In order to this,

Re: [sqlite] Querying a value with an ampersand

On 7/5/06, Roger <[EMAIL PROTECTED]> wrote: I have a company name as follows: Chemistry & chemicals I have plenty of those in my database which come with ampersands, now when i do a query i get nothing. How best can i write the query using a string with an ampersand as part of it. select *

Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Wed, 5 Jul 2006 13:19:30 +0200 Von: "Olaf Beckman Lapré" <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users Hi Olaf > Why not use optimistic locking (timestamp based pseudo locking)? It's > ussually sufficient. Thats

Re: [sqlite] Multiple Users

[EMAIL PROTECTED] wrote: but... I want try to ask again... ;-) SQLite handles the File-Lockings as a physical Locking during the writings to File and Disk. (Is it so?) I do my own logical Locking during the Edit of a Record and then reflect to the Busy-State if the changes will be saved to

Re: [sqlite] Syntax Errors with various strings?

Gussimulator wrote: Hi, When I have strings with "-", "!", "\" or similar characters I get a syntax error.. Now, I thought this would happen with a few of this chars so I made 2 routines in my program, one that converts each of this chars into a flag string, which then, by the other routine

Re: Re: [sqlite] Multiple Users

Hi Nikki Many thanks for your answer. Its really helpful. First time it seems to me, that I understand the problem. In the past it happens, that the message in some Postings sometimes lives behind a Fog :-))) Thinks dont will be get clearly. Its sometimes not so easy, to put it on the same

Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Wed, 05 Jul 2006 07:32:47 -0600 Von: Dennis Cote <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users > Anne, > > Yes, ... A simple "Yes" :-))) >...your description is correct Hi Dennis Many thanks to you too.

Re: [sqlite] Multiple Users

First, sad about the football, but someone has to win. My point that since Sqlite is embedded its only locking method is the fcntl type file lock. Any other level of locking has to be supplied by your application. It cannot perform row and table locks like a DB server. The extreme

[sqlite] sqlite3_free()

A few quick questions... If an error is returned by sqlite3_exec( ) , I believe the error message is written in the (char **errmsg) provided in the 5 parameter of the function call. 1. Is this the same error text that can be obtained by sqlite3_errmsg( ) ? 2. If this is the same

Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Wed, 05 Jul 2006 13:01:12 -0500 Von: John Stanton <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users > First, sad about the football, but someone has to win. Its only football... and so hard it is... the italian

Re: [sqlite] sqlite3_free()

[EMAIL PROTECTED] wrote: > A few quick questions... > > If an error is returned by sqlite3_exec( ) , I believe the error message is > written in the (char **errmsg) provided in the 5 parameter of the function > call. > > 1. Is this the same error text that can be obtained by >

Re: [sqlite] Syntax Errors with various strings? & ...Ampersand

Enclosing the strings with quotation marks did the job. Thanks a lot. - Original Message - From: "C.Peachment" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 05, 2006 6:39 AM Subject: Re: [sqlite] Syntax Errors with various strings? & ...Ampersand The

Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Wed, 05 Jul 2006 19:30:04 +0100 Von: Nikki Locke <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users > We seem to have a misunderstanding over the definition of "optomistic > locking". Yes, maybe... ;-) > To me,

Re: [sqlite] Syntax Errors with various strings?

Thanks Christian, I'll give it a shot later. Just because using quotation marks (did a quick macro that adds them to my string) did the job, doesnt mean its a better solution than this one. - Original Message - From: "Christian Nassau" <[EMAIL PROTECTED]> To:

Re: [sqlite] Syntax Errors with various strings?

Gussimulator wrote: Thanks Christian, I'll give it a shot later. Just because using quotation marks (did a quick macro that adds them to my string) did the job, doesnt mean its a better solution than this one. In particular, if your strings include the ' character, you will need to double

Re: [sqlite] sqlite3_free()

Thanks you for your help! Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems Support 609-485-7225 [EMAIL PROTECTED]

[sqlite] Compressing the DBs?

I've been using SQLite for a very short period of time and so far Its doing a great job for my application (single user, quite a big amount of data though). Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since, we all know.. One of the

Re: [sqlite] Compressing the DBs?

What platform are you using? If you are using NTFS filesystem you can just mark the file for compression and the OS takes care of it transparently. -- View this message in context: http://www.nabble.com/Compressing-the-DBs--tf1897195.html#a5190175 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Syntax Errors with various strings?

Thanks Gerry, My strings are normal filenames with their paths, so as you can see there arent many characters that would ruin my day, however you're right about the ' char. I'll make my own quote(); routine and then I'll compare with the SQLite one by doing a small benchmark, see whats best

Re: [sqlite] Multiple Users

Ann don't cry into your beer, there is always next time! My team also got knocked out by Italy. Your approach makes perfect sense to me. Perhaps you can achieve it be defining a database wrapper which encapsulates the DBMS APIs and provides a standard interface to your applications. You

Re: [sqlite] Compressing the DBs?

At 6:04 PM -0300 7/5/06, Gussimulator wrote: Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since, we all know.. One of the first principles of data compression is getting rid of repetitive data, so... I was wondering if this is

Re: [sqlite] Compressing the DBs?

Hello there, This is what I mean by repetitive data: Tables: E:\DirectX90c\ E:\DirectX90c\Feb2006_MDX1_x86_Archive.cab\ E:\DirectX90c\Feb2006_d3dx9_29_x64.cab\ E:\DirectX90c\Feb2006_xact_x64.cab\ E:\DirectX90c\Feb2006_MDX1_x86.cab\ E:\DirectX90c\Feb2006_xact_x86.cab\ And so on, As you can see,

Re: [sqlite] Compressing the DBs?

Gussimulator wrote: > Hello there, > > This is what I mean by repetitive data: > > Tables: > E:\DirectX90c\ > E:\DirectX90c\Feb2006_MDX1_x86_Archive.cab\ > E:\DirectX90c\Feb2006_d3dx9_29_x64.cab\ > E:\DirectX90c\Feb2006_xact_x64.cab\ > E:\DirectX90c\Feb2006_MDX1_x86.cab\ >