Re: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread [EMAIL PROTECTED]
I'm using SQlite as source too, and every time I pull the source I rewrite os.c to accomodate it to my UNICODE app, namely I replace all ambiguous file-handling APIs into their ASCII versions. Then I convert filename into ASCII in my app, then pass it to SQLite. But as you know it's far better if

Re: [sqlite] Re: [inbox] Re: [sqlite] double email

2003-11-21 Thread Scott Lamb
Will Leshner wrote: On Nov 21, 2003, at 12:04 PM, Michael Hunley wrote: Actually, it is the practice of replying to all that is causing the double send. I got yours twice. Once for your reply to me and again because I am on the list. The right answer is for the list to see that an address on

RE: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread Rob Fowler
Thanks for the insight, Arthur. I guess since you're using Sqlite as a DLL, you *could* switch on UNICODE within your own app, although I understand why you don't. I'm using the Sqlite source files within my app directly. I switch on UNICODE so that the rest of my app (outside of Sqlite) can

RE: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread Rob Fowler
Tim, I'm not sure of what all SQLITE_UTF8 affects; however, I can clarify that my proposal doesn't require that SQLITE_UTF8 be used. My only point was that the sqlite functions require 'narrow' chars (UTF-8 or not), so why not always call the narrow 'A' versions of Windows functions? Chris gave

RE: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread Rob Fowler
Thanks, Chris. I mistakenly thought that all Windows platforms supported the 'A' versions of those functions. That's the kind of feedback I was looking for. Perhaps my suggestion still makes sense for desktop versions. I don't know. As I mentioned in my reply to Arthur, when the 'A' functions

RE: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread Tim McDaniel
Maybe there needs to be some clarification here. All the sqlite functions take const char* for string parameters. What I'm not clear on is the intended effect of the SQLITE_UTF8 macro. Which string parameters of which functions are intended to be UTF-8 encoded if the SQLITE_UTF8 macro is

RE: [sqlite] Win32 coders: change os.c?

2003-11-21 Thread Clark, Chris
> -Original Message- > From: Arthur Hsu [mailto:[EMAIL PROTECTED] > Sent: Friday, November 21, 2003 12:24 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Win32 coders: change os.c? > > > Not quite. IMHO, it's better that os.c catches this UNICODE > macro, and then > uses

[sqlite] Question about SQLite best use

2003-11-21 Thread chris
First of all, SQLite is an amazing product. My hat's off to the developer(s) and supporters. I wish I would have found this years earlier. I was told that this list would be the best place to ask my questions, so here goes: I will be using SQLite this for a server full of multiple user

Re: [sqlite] Re: [inbox] Re: [sqlite] double email

2003-11-21 Thread Michael Hunley
At 12:49 PM 11/21/2003 -0600, Scott Lamb wrote: Many people (myself included) prefer it the way this list does it. I'm on a lot of lists which are sorted into subfolders. If you send a message to the list, I might or might not see it. If you "reply all" to a message of mine (or to a "reply all"

RE: [sqlite] sqlite with eVC++

2003-11-21 Thread Clark, Chris
> -Original Message- > From: Eric Pankoke [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 20, 2003 10:06 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] sqlite with eVC++ > > > Is there anyone on this group that uses sqlite with Embedded > Visual C++ for > the PocketPC? If so,

[sqlite] Re: SELECT syntax, use NOT on fields

2003-11-21 Thread Michael Hunley
At 02:04 PM 11/21/2003 +0200, you wrote: Your question fails into same category as "Can I SELECT ... FROM * ; ?" It is not that easy to explain why, but you should never ask such questions. Umm...That sounds a little harsh and totalitarianist. Did you actually mean that people shouldn't ask

[sqlite] Re: [inbox] Re: [sqlite] double email

2003-11-21 Thread Michael Hunley
At 05:35 PM 11/21/2003 +0100, you wrote: Will you stop sending your emails twice, this one, I also got twice I am only getting them once. Are others getting them twice? Bert, are you sure it is not something going on in your email server? Or perhaps a double email address mapping in the list?

Re: [sqlite] double email

2003-11-21 Thread Bert Verhees
> Bert Verhees wrote: >> It would be nice if people would stop sending their emails twice to this >> list, and also would put off their read or deliver notification > > And learn to quote. And not top-post. > > -- Gerhard OK, I will not top-quote Will you stop sending your emails twice, this

Re: [sqlite] double email

2003-11-21 Thread Noel Frankinet
And learn to quote. And not top-post. Up to now, this list was immune of cyber cop. Let us work Noël - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] double email

2003-11-21 Thread Gerhard Häring
Bert Verhees wrote: It would be nice if people would stop sending their emails twice to this list, and also would put off their read or deliver notification And learn to quote. And not top-post. -- Gerhard - To unsubscribe,

[sqlite] double email

2003-11-21 Thread Bert Verhees
It would be nice if people would stop sending their emails twice to this list, and also would put off their read or deliver notification thanks Bert Verhees > [EMAIL PROTECTED] wrote: >> Hi all, >> >> I'm trying SQLite with Zope > > You're using PySQLite, right? > >> and it works fine, but when

Re: [sqlite] database is locked

2003-11-21 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: Hi all, I'm trying SQLite with Zope You're using PySQLite, right? and it works fine, but when I use the browser's [Stop] button to interrupt the request it gives me the message: "database is locked" [...] This happens when you have a connection that is within a

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
Please forgive me, but I have been away from the C++ world for a long time, and as a Visual Basic developer I tend to get lazy. What do I need to do to build the .lib file through the ide? Do you have a project that you might be able to send me? I really appreciate all the help. -- Eric

[sqlite] Fullquotes, was: Re: [sqlite] sqlite with eVC++

2003-11-21 Thread Gerhard Häring
Noel, "epankoke" and rest: Would you people please learn to quote when using mailing lists? There's no need to quote everything, just the parts you're referring to in your answer. The signal-to-noise ratio in this group is quite bad :-/ -- Gerhard

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread Noel Frankinet
[EMAIL PROTECTED] wrote: I'm not actually sure how to compile the .lib. I used this command initially: LIB /DEF:sqlite.def /MACHINE:ARM. Is there some other way I should be building a .lib file? > I'm not sure what you mean by a WTL gui application, but the problem I'm having is with

Re: [sqlite] performance on Mac OS 9

2003-11-21 Thread Will Leshner
On Nov 15, 2003, at 8:17 PM, Will Leshner wrote: I've been working on a Mac OS X version of SQLite and things are very quick. But now I'm trying similar code on OS 9 on basically the same hardware and while indexed searches are still very fast, if I do a SELECT with LIKE, performance is really

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not actually sure how to compile the .lib. I used this command initially: LIB /DEF:sqlite.def /MACHINE:ARM. Is there some other way I should be building a .lib file? > > > I'm not sure what you mean by a WTL gui application, but the problem > I'm having is with compilation. I have

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not sure what you mean by a WTL gui application, but the problem I'm having is with compilation. I have included sqlite.h in my project, and I am calling two functions: sqlite_open and sqlite_close. When I compile, I get an "unresolved external" error on each of these functions, even

Re: [sqlite] Building with msvc6 ?

2003-11-21 Thread richard.forrest1
Hi Dan, I have managed to build a single threaded lib Building libsqlite.lib Compiled source code in sqlite_source as before but this time with SINGLE threading, STATIC linking to standard libs and debug switched on (-MLd) Linked these objects into a static lib with the name libsqlite.lib .

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread Noel Frankinet
Eric Pankoke wrote: Is there anyone on this group that uses sqlite with Embedded Visual C++ for the PocketPC? If so, what do I need to do to get a project with sqlite commands to compile? Any help would be greatly appreciated. Thanks. Eric Pankoke Founder Point Of Light Software