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

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

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

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?

[sqlite] SQLite as a Windows kernel tool

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

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

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

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

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

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

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

Re: [sqlite] basic question about sqlite

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

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

--- 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

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

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

Re: [sqlite] Dotnet C# support

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

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

[sqlite] basic question about sqlite

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

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

Re: [sqlite] Dotnet C# support

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

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

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

Re: [sqlite] Dotnet C# support

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

Re: [sqlite] Dotnet C# support

- 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

Re: [sqlite] Dotnet C# support

- 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

RE: [sqlite] Dotnet C# support

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

RE: [sqlite] Dotnet C# support

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

Re: [sqlite] Dotnet C# support

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

Re: [sqlite] Dotnet C# support

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

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

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

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

Re: [sqlite] Dotnet C# support

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

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)