Re: [sqlite] Retrieving data

2006-09-13 Thread thomas . l
Am 14.09.2006 um 02:11 Uhr haben Sie geschrieben: > I'm using sqlite in VC++ 2005. > When I started this I knew nothing about sqlite or indeed SQL at all so its > been tough going trying to work out how this all works. I started so too ;-) > I tried: > sqlite3_exec(AccDataBase,"SELECT

Re: RE: [sqlite] Retrieving data

2006-09-14 Thread thomas . l
Hi Richard >> You don't need a Callback-Function in any case. Try it >> without > I'm confused. > How does the SELECT command return any data? In what > form would it give you this data back? There doesn't seem to > be a pointer to pass by reference and no out variables. The Prepare-Command

Re: [sqlite] Concurrency with writer and read-only processes

2006-09-16 Thread Thomas . L
On Fri, 15 Sep 2006 17:29:13 -0400, you wrote: Hi Liam >I have a database that has one writer which runs once a day, and >potentially many readers running whenever someone wants some >information. I am trying to understand concurrency in sqlite3 so that I do a daily Job too in my programm. It

Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query

2006-09-17 Thread Thomas . L
On Sun, 17 Sep 2006 13:03:23 +0530, you wrote: >Thank you very much for your suggestion. >I found very few samples in the siteBut hardly only one example is there >which explains abt handling BLOB data. >There is no documentation which explains about these samples .. >So for me all

Re: [sqlite] Multiuser on LAN, how good/bad is it ?

2006-09-17 Thread thomas . l
Hi Martin Martin Alfredsson wrote: > Though I can interpret the the second statement as "on a single machine" > I'd like to hear about what your experience is with using it as multiuser > on a lan. > Does it crash due to network problem, does it work better with WinXP > than Win9x/2k/linux etc.

Re: [sqlite] sqlite_blob

2006-09-18 Thread thomas . l
Hello sandhya wrote: > Hi, > Is there any way of reading Blob data for the given no.of bytes? > I mean is there any lseek kind of function call in sqlite to handle > reading BLOB data. http://www.sqlite.org/capi3ref.html says: "If the result is a BLOB then the sqlite3_column_bytes() routine

Re: Re[4]: [sqlite] reg:blob data reading

2006-09-18 Thread Thomas . L
On Mon, 18 Sep 2006 10:20:36 -0400, you wrote: >There's no right or wrong way. There is viewpoint from June 2006 with title: "To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem?" at

Re: [sqlite] Optimistic concurrency control

2006-09-19 Thread Thomas . L
Hello On Tue, 19 Sep 2006 11:24:02 -0700 (PDT), you wrote: >Maybe I didn't make the question clear. I'm not talking about locking and >multiple writers. I'm talking about optimistic concurrency control in a >disconnected environment. > >IF anyone has changed the data since you last read

Re: [sqlite] Difficulty with sqlite3.3.6 under VisualStudio.net

2006-09-19 Thread thomas . l
Hi Dixon Dixon Hutchinson wrote: > I am getting lots of errors of the sort: > > 'size_t' to 'int', possible loss of data > > I could just turn off the warnings, but that seems kind of wreckless. > The output from the compile is attached. Try this (But this is not really necessary.): #pragma

Re: [sqlite] How to maintain EXCLUSIVE access to database continuously ?

2006-09-24 Thread Thomas . L
On Sun, 24 Sep 2006 04:41:55 -0700 (PDT), you wrote: >User (Client App) connects to middle-tier application-server and then user >may access any one company in normal or exclusive mode. Only >application-server communicates with database. If user wants exclusive >access, Application-Server needs

Re: [sqlite] Using SQLite on networked drive

2006-09-25 Thread Thomas . L
On Mon, 25 Sep 2006 11:22:41 -0700 (PDT), you wrote: Hello >I have read articles and understood that it is not safe to access SQLite >database file on network drive. (on all windows). > >But what about Windows 2000 (Server) ??? i.e. If SQLite (3.3.4 or 3.3.6) >database file resides on disk

Re: [sqlite] The term "flat-file" as applied to sqlite

2006-09-26 Thread Thomas . L
On Mon, 25 Sep 2006 16:06:44 -0400, you wrote: Hello >I've noticed that more than one contributor to this list has referred to >sqlite as a "flat file database." I had always thought of a flat file as a >file composed of single table of records, with records defined either by >fixed-width

Re: [sqlite] The term "flat-file" as applied to sqlite

2006-09-26 Thread Thomas . L
On Tue, 26 Sep 2006 11:20:09 -0700, you wrote: >Well, and English is a language used by humans to convey their >understandings to other humans :-). You can do technical >hairsplitting all you want, but the fact is that the term "flat file" >has a long history of being used to refer to text files

Re: AW: [sqlite] Memory mapped db

2006-09-28 Thread Thomas . L
On Thu, 28 Sep 2006 15:45:54 +0200, you wrote: Hi Michael >-Ursprüngliche Nachricht- >Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] >Gesendet: Donnerstag, 28. September 2006 15:37 >An: sqlite-users@sqlite.org >Betreff: Re: [sqlite] Memory mapped db >That's not really the same. I would