Re: [sqlite] Multi-threading.

At 03:21 27/07/2005, Mrs. Brisby wrote: On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote: > The theory has been proposed that threads aren't better than separate > processes, or application implemented context switching. Does anyone > have an experiment that will prove the point either way?

Re: [sqlite] ORDER BY question

Right you are. For some reason I was sure that existed. How about defining the column as text and doing "ORDER BY + 0.0". That won't use an index though. If you need an index you'll have to define a collation sequence that sorts numericly. --- [EMAIL PROTECTED] wrote: > I tried that but got:

[sqlite] VB6 question

hello i'm trying to open a database with VB6 without wrapper i'm using sqlite3.dll and it's my code : Option Explicit Private Declare Function sqlite3_open Lib "sqlite3.dll" (ByVal filename As String, ByRef dbHandle As Long) As Long Private Declare Function sqlite3_open16 Lib "sqlite3.dll"

[sqlite] ANN: sqlite3Explorer V 1.7

*. new feature : support for encrypted databases (WITH the licenced version of sqlite) http://www.singular.gr/sqlite/

AW: [sqlite] VB6 question

Hi, unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling convention, but VB only supports the stdcall calling convention. You must recompile sqlite using MS Visual C++ or other compiler and switch the default

Re: AW: [sqlite] VB6 question

Ok Thank's for your help i will trying this !!! [EMAIL PROTECTED] a écrit : Hi, unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling convention, but VB only supports the stdcall calling convention. You must

Re: [sqlite] New Query Question

From: John LeSueur <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] New Query Question Date: Tue, 26 Jul 2005 19:51:54 -0600 MIME-Version: 1.0 Received: from sqlite.org ([67.18.92.124]) by mc11-f29.hotmail.com with Microsoft

Re: [sqlite] ANN: sqlite3Explorer V 1.7

Cariotoglou Mike wrote: *. new feature : support for encrypted databases (WITH the licenced version of sqlite) http://www.singular.gr/sqlite/ Awesome! Thanks! I was hoping that you would add encryption support. :) (We purchased our license a few weeks ago). However, I am unable to

Re: [sqlite] ANN: sqlite3Explorer V 1.7

Dennis Jenkins wrote: Cariotoglou Mike wrote: *. new feature : support for encrypted databases (WITH the licenced version of sqlite) http://www.singular.gr/sqlite/ Awesome! Thanks! I was hoping that you would add encryption support. :) (We purchased our license a few weeks ago).

RE: [sqlite] ANN: sqlite3Explorer V 1.7

good to know... > -Original Message- > From: Dennis Jenkins [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 27, 2005 4:26 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: sqlite3Explorer V 1.7 > > Dennis Jenkins wrote: > > > Cariotoglou Mike wrote: > > > >> *. new

[sqlite] sqlite3_compile missing?

Hello, It seems that the functions required for reading data without a callback are mising in SQLite 3? I cant find "sqlite3_compile", or "sqlite3_step". Am I missing something? The documentation on the website describes "sqlite_compile" and "sqlite_step" which were presumably menat to be

[sqlite] Can you use SQL Lite database from multiple processes at the same time?

Hi All, Can we use SQL Lite Database from multiple processes at the same time. Example. I have a database called Customer.db. I want to use it from apache server for web application and also use it from a c program running on the server. Regards Sudhir Hasbe

[sqlite] Sorry, trivail question probably, chr(0) in blob.

I reread the faq hundred times but i don't understand the \000 remark. For INSERT how can i embed BLOB data having single quote and chr(0) bytes? Currently i replace all singlequotes with 2x single quotes and that works fine. The chr(0) byte did not succeed. I'm using the dll and don't do any c

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

in sqlite 3.x you can bind data to prepared statements, no escaping is required. On 7/27/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: > I reread the faq hundred times but i don't understand the \000 remark. > > For INSERT how can i embed BLOB data having single quote and chr(0) bytes? >

Re: [sqlite] Multi-threading.

On Wed, 27 Jul 2005, Paul Smith wrote: >At 03:21 27/07/2005, Mrs. Brisby wrote: >>On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote: >> > The theory has been proposed that threads aren't better than separate >> > processes, or application implemented context switching. Does anyone >> > have

Re: [sqlite] Can you use SQL Lite database from multiple processes at the same time?

Yes On 7/27/05, Sudhir Hasbe <[EMAIL PROTECTED]> wrote: > Hi All, > Can we use SQL Lite Database from multiple processes at the same > time. Example. I have a database called Customer.db. I want to use it from > apache server for web application and also use it from a c program running >

[sqlite] UPDATE - crash when many columns

Hi, I am using SQLite on an embedded software product. I seem to have a problem when I update more than 6 columns within a single record at one time. All columns are in the same table, they are either strings, integers or dates. I am using the SQL command:- UPDATE PATIENTS SET

Re: [sqlite] sqlite3_compile missing?

On 7/27/2005 at 16:24 djm wrote: >Hello, > >It seems that the functions required for reading data without a >callback are mising in SQLite 3? I cant find "sqlite3_compile", >or "sqlite3_step". Am I missing something? > >The documentation on the website describes "sqlite_compile" and

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

I will look that up, read something about binding. But *can* 'escaping' be used as alternative? - Original Message - From: "Cory Nelson" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 27, 2005 5:41 PM Subject: Re: [sqlite] Sorry, trivail question probably,

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

On Wed, 27 Jul 2005, Edwin Knoppert wrote: >I reread the faq hundred times but i don't understand the \000 remark. > >For INSERT how can i embed BLOB data having single quote and chr(0) bytes? >Currently i replace all singlequotes with 2x single quotes and that works fine. >The chr(0) byte did

Re: [sqlite] SQLite 3.2 install on Mac OS X

It looks like libtclsqlite3.dylib either didn't get made or is in the wrong place. You can search your disk to see whether it got made. There's a switch in the Makefile that determines whether it gets made or not. OS X has been discussed several times on this list. You might try searching the

RE: [sqlite] UPDATE - crash when many columns

-Original Message- From: Mark Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 10:53 AM To: sqlite-users@sqlite.org Subject: [sqlite] UPDATE - crash when many columns Hi, I am using SQLite on an embedded software product. I seem to have a problem when I update more than

Re: [sqlite] ALTER TABLE: Confusing documentation

The docs are correct; you just have to read carefully. They say that you can "rename, or add a new column to, an existing table". Regards

Re: [sqlite] ALTER TABLE: Confusing documentation

On 27/07/2005, at 13:04, Kurt Welgehausen wrote: The docs are correct; you just have to read carefully. I have :-) They say that you can "rename, or add a new column to, an existing table". No, it doesn't. It states that you can "rename or add a new column to an existing table."

Re: [sqlite] Multi-threading.

On Tue, Jul 26, 2005 at 10:21:22PM -0400, Mrs. Brisby wrote: > That's incorrect. Threading increases development time and produces less > stable applications. In fairness: it's the skill level of the engineer Mrs. Brisby, that is probably quite correct in at least one particular sense, but since

Re: [sqlite] Multi-threading.

On Tue, 2005-07-26 at 23:20 -0400, Kervin L. Pierre wrote: > We get all those threads related questions because SQLite > is difficult to use with threads and has sparse sometimes > conflicting documentation on the subject. Maybe people think that SQLite should serialize its own internals. Maybe

Re: [sqlite] Multi-threading.

On Wed, 2005-07-27 at 09:08 +0100, Paul Smith wrote: > At 03:21 27/07/2005, Mrs. Brisby wrote: > >On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote: > > > The theory has been proposed that threads aren't better than separate > > > processes, or application implemented context switching. Does

Re: [sqlite] Multi-threading.

On Wed, 2005-07-27 at 13:31 -0400, Andrew Piskorski wrote: > On Tue, Jul 26, 2005 at 10:21:22PM -0400, Mrs. Brisby wrote: > > > That's incorrect. Threading increases development time and produces less > > stable applications. In fairness: it's the skill level of the engineer ... > When people -