Re: [sqlite] SQLite as a Windows kernel tool

2005-10-28 Thread Eric Bohlman
Ken & Deb Allen wrote: I had a quick look at some of the code, but I am not certain whether all, or even most, of these warnings can be safely ignored or not. I tried modifying the code to add explicit casts to eliminate all of the warnings, which worked, but I do not know whether or not the

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-28 Thread Steve Palmer
Thanks! That helps tremendously. As regards merging the changes, I've been in touch with drh over this and I understand he is already looking into this patch. So in the interest of not duplicating effort, I'm not going to make any attempt to submit a merge of these changes back into the mos

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-28 Thread Aaron Burghardt
The Makefile has this line: include $(MAKEFILEPATH)/CoreOS/ReleaseControl/GNUSource.make so you will need the Darwin project CoreOSMakefiles-30. Working backwards, GNUSource.make includes Common.make, which defines OBJROOT to be /tmp/$(ProjectName)/Build. With this, I found the built

Re: [sqlite] Re: Number of rows in a query result

2005-10-28 Thread Puneet Kishor
On Oct 28, 2005, at 7:20 PM, SRS wrote: Edward Wilson wrote: The idea of issuing two selects is, well, a hack, and knowing how many records one has in a result-set is a powerful feature Are you needing a progress bar for the search (ie the query?) Or some action based on the result set?

Re: [sqlite] SQLite as a Windows kernel tool

2005-10-28 Thread Joel Lucsy
The default for VC7 projects is to check for 64bit portability issues. This is an option in the settings for the project. If you know your system is strictly 32bit, then turn it off and I bet quite a number of warnings would disappear. -- Joel Lucsy "The dinosaurs became extinct because they didn'

[sqlite] SQLite as a Windows kernel tool

2005-10-28 Thread Ken & Deb Allen
I have been toying with the idea of checking whether or not I can use SQLite in a Windows device driver as its database. I am working on an existing product that is implemented as a series of Windows device drivers, filter drivers and even a file system driver. The file system driver manage

Re: [sqlite] Re: Number of rows in a query result

2005-10-28 Thread SRS
Edward Wilson wrote: The idea of issuing two selects is, well, a hack, and knowing how many records one has in a result-set is a powerful feature Are you needing a progress bar for the search (ie the query?) Or some action based on the result set? If the later, get the result set as you

Re: [sqlite] Re: Re: Number of rows in a query result

2005-10-28 Thread John Stanton
Igor puts it very clearly. No DBMS knows how many rows are in a selection until the selection has been performed. Therefore you cannot do a progress bar since the selection is complete before you have the necessary information to build the bar. The answer is to use some other form of progres

[sqlite] Re: Re: Number of rows in a query result

2005-10-28 Thread Igor Tandetnik
Edward Wilson wrote: This is really an important feature to have, I am surprised it's not already there. I too have had the same question but have just never asked. Well, if the golden standard is mysql_num_rows, consider the following bit in the documentation: The use of mysql_num_rows()

Re: [sqlite] basic question about sqlite

2005-10-28 Thread John Stanton
It would be safe and efficient provided that you did not have a massive load with many processes expecting simultaneous access. Just be careful that your applications can gracefully handle the occasional lock state and use transactions carefully. Don't design in queries which have a long exec

Re: [sqlite] built-in functrion suggestion: size of blob

2005-10-28 Thread Joe Wilson
--- Nuno Lucas <[EMAIL PROTECTED]> wrote: > On 10/25/05, Joe Wilson <[EMAIL PROTECTED]> wrote: > > The built-in Sqlite length() function works just fine on blobs: > > > > sqlite> select length(X'00'); > > 5 > > > > Why do you think it doesn't? > > I remember a few months ago noticin

[sqlite] Impossible to open or create database phpsla.sqlite

2005-10-28 Thread Peter Reinhardt
Hi, i am a user on following machine: -- Machine hardware: sun4u OS version: 5.8 Processor type: sparc Hardware: SUNW,Sun-Fire-880 The following components are installed on your system: Sun Studio 10

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Bert Verhees
I agree, never use PInvoke, if possible to avoid There is a performqncepenalty, and maybe you loose platform-independency (think of Mono) Bert > I think you are looking for this http://adodotnetsqlite.sourceforge.net/ > > I wrote my own driver in C++ (boy, that was a lot of work) then discovered

Re: [sqlite] basic question about sqlite

2005-10-28 Thread Jay Sprenkle
On 10/28/05, Dave Dyer <[EMAIL PROTECTED]> wrote: > > If I designed a sqlite database to be used by a bunch of independent > applications, for example a bunch of CGI scripts each of which > opened the database, did some processing, and exited, would > that be (a) safe (b) effecient ? As long as yo

[sqlite] basic question about sqlite

2005-10-28 Thread Dave Dyer
If I designed a sqlite database to be used by a bunch of independent applications, for example a bunch of CGI scripts each of which opened the database, did some processing, and exited, would that be (a) safe (b) effecient ?

Re: [sqlite] Re: Number of rows in a query result

2005-10-28 Thread Edward Wilson
Sqlite-Kernel-Hackers: This is really an important feature to have, I am surprised it's not already there. I too have had the same question but have just never asked. btw, is this by any chance on the feature road-map? The idea of issuing two selects is, well, a hack, and knowing how many reco

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Edward Wilson
I think you are looking for this http://adodotnetsqlite.sourceforge.net/ I wrote my own driver in C++ (boy, that was a lot of work) then discovered the above. - ed --- Wilfried Mestdagh <[EMAIL PROTECTED]> wrote: > Hi Darren, > > > Is there a version which will work for dotnot? > > If not th

RE: [sqlite] Re: Number of rows in a query result

2005-10-28 Thread Eric Pankoke
If by handheld you mean PocketPCs, then: http://sqlite-wince.sourceforge.net/. The database file itself stays the same. If you want Palm support, you'll be a lot harder pressed to find anything. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-28 Thread Steve Palmer
Has anybody tried building that though? If you download the files from http://www.sqlite.org/cvstrac/tktview?tn=1240 and run make from the root of the expanded folder then it will go through the process of configuring and building, but I can't find the output files anywhere. A search under

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Gregory Letellier
thx for your response !! Robert Simpson a écrit : - Original Message - From: "Gregory Letellier" <[EMAIL PROTECTED]> i'm trying tu use sqli3 with vb. net he create the db but not the table.. what is the mistake ? i've this code Imports System.Runtime.InteropServices Public Class

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Robert Simpson
- Original Message - From: "Gregory Letellier" <[EMAIL PROTECTED]> i'm trying tu use sqli3 with vb. net he create the db but not the table.. what is the mistake ? i've this code Imports System.Runtime.InteropServices Public Class Form1 _ Public Structure sqlite_callback

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Robert Simpson
- Original Message - From: "Darren Lodge" <[EMAIL PROTECTED]> Hi there, Is there a version which will work for dotnot? The WIKI page is the best place to look ... There are probably half a dozen providers for SQLite. Two ADO.NET providers (for ADO.NET 1.1 and ADO.NET 2.0) and sev

RE: [sqlite] Dotnet C# support

2005-10-28 Thread Reid Thompson
Original Message From: Darren Lodge [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 4:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Dotnet C# support > Hi there, > > Is there a version which will work for dotnot? > > Darren Lodge > Software Engineer > CAP > > 0113 222 205

RE: [sqlite] Dotnet C# support

2005-10-28 Thread Reid Thompson
Original Message From: Darren Lodge [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 4:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Dotnet C# support > Hi there, > > Is there a version which will work for dotnot? > > Darren Lodge > Software Engineer > CAP > > 0113 222 205

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Clay Dowling
Darren Lodge said: > Hi there, > > Is there a version which will work for dotnot? I've had good luck with some of the ADO.NET providers. They work pretty much like other ADO.NET providers. It's been a year or more so I can't say exactly how long ago it was, but I was reasonably happy with the r

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Justin Greenwood
I've used the C# .net provider for SQLite quite a bit. You can use SQL3 with these providers, you just have to add something to the connection string to tell the driver which version you're using and also the text encoding (UTF8Encoding=true;Version=3;). To create a new database, you just have

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Gregory Letellier
i'm trying tu use sqli3 with vb. net he create the db but not the table.. what is the mistake ? i've this code Imports System.Runtime.InteropServices Public Class Form1 _ Public Structure sqlite_callback Public Void As Long Public I1 As Long Public s1 As

RE: [sqlite] Dotnet C# support

2005-10-28 Thread Darren Lodge
Thankyou! Darren Lodge Software Engineer CAP 0113 222 2058 (direct) 0113 222 2000 (switchboard) 0113 222 2001 (fax) -Original Message- From: Peter Berkenbosch [mailto:[EMAIL PROTECTED] Sent: 28 October 2005 09:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Dotnet C# support --

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Peter Berkenbosch
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sigh.. http://www.google.com/search?hl=nl&q=SQLite+C%23&btnG=Google+zoeken&meta= Darren Lodge wrote: > Hi there, > > Is there a version which will work for dotnot? > > Darren Lodge > Software Engineer > CAP > > 0113 222 2058 (direct) > 0113 22

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Wilfried Mestdagh
Hi Darren, > Is there a version which will work for dotnot? If not then you can use every win32 dll in C# using P/Invoke --- Rgds, Wilfried http://www.mestdagh.biz

[sqlite] Dotnet C# support

2005-10-28 Thread Darren Lodge
Hi there, Is there a version which will work for dotnot? Darren Lodge Software Engineer CAP 0113 222 2058 (direct) 0113 222 2000 (switchboard) 0113 222 2001 (fax)