[sqlite] [ANN] 1st pre-alpha release of the SQLite OLE/DB provider

2004-09-10 Thread Nuno Lucas
can be found at the directory). Let me know what it doesn't work in your case, so I know what I need to implement next (and any bugs, off course ;) You can contact me at: [EMAIL PROTECTED] or [EMAIL PROTECTED] Best regards, ~Nuno Lucas // // Run this in a command prompt using a line like t

Re: [sqlite] Single INSERT is very slow

2004-09-05 Thread Nuno Lucas
x27;s impossible to Access/ADO to have commited your data to disk in that time. Please read about the "PRAGMA SYNCHRONOUS" command [1] and you will probably find similar results then. Regards, ~Nuno Lucas [1] http://www.sqlite.org/lang.html#pragma_synchronous

Re: [sqlite] Is version 3 seriously broken?

2004-09-03 Thread Nuno Lucas
hould be done by someone that understands what it wants to do. > Are you going to merge 3.0.6? Already done and committed, stay tuned for the release... Regards, ~Nuno Lucas

Re: [sqlite] Is version 3 seriously broken?

2004-09-01 Thread Nuno Lucas
ing I have no way of checking the stack use of them (could they be creating rowsets in the stack, for example?). Anyway, with the 3.0.5 port, I could now insert 5 rows without problems. Maybe you could check if my merge is different from yours and if it works now. Regards, ~Nuno Lucas Ja

Re: [sqlite] Is version 3 seriously broken?

2004-08-31 Thread Nuno Lucas
rected), so you can check it works now. Regards, ~Nuno Lucas /* BUG: the right header to include is "sqlite3.h". "sqliteint.h" is an internal header and can't be used safelly */ /*/ #include #include #include #include bool TestExecuter( sqlite3 *db_hn

Re: [sqlite] OLE/DB provider for SQLite?

2004-08-31 Thread Nuno Lucas
think only when the project is done I will have a final decision. Regards, ~Nuno Lucas

Re: [sqlite] OLE/DB provider for SQLite?

2004-08-31 Thread Nuno Lucas
air, I would be pleased to ear any alternatives you might have to make it better. Best regards, ~Nuno Lucas

Re: [sqlite] OLE/DB provider for SQLite?

2004-08-28 Thread Nuno Lucas
etc.) if there is no interest (as it will not be free). One possible step would be porting it for Windows CE, giving more choice for those that don't use C as a Windows CE language. As this may be a little off topic for this ML, those that could be interested just reply me directly to [EMAIL PROTECTED] Regards, ~Nuno Lucas

Re: [sqlite] OLE/DB provider for SQLite?

2004-08-25 Thread Nuno Lucas
nfr, dando pulos de alegria, escreveu : There is a nice OLE provider project from xml file at http://www.viksoe.dk/code/xmloledb.htm Maybe you can use that as a starting point. Regards Noël Unfortunally it is only binary freeware (a DLL), no source code. But thanks, anyway. ~Nuno Lucas

[sqlite] OLE/DB provider for SQLite?

2004-08-24 Thread Nuno Lucas
here can I get information on how to implement one? (to see if it's easy or not) Any help would be appreciated, thanks. ~Nuno Lucas

Re: [sqlite] SQLite 3 for Pocket PC

2004-08-11 Thread Nuno Lucas
unresolved issues with Unicode database open (use pure ascii paths). I am hopping this will be addressed in 3.0.5. Regards, ~Nuno Lucas

Re: [sqlite] in memory databases

2004-07-29 Thread Nuno Lucas
question is very simple How can I load the totality of a file database in memory? 1) open a ":memory:" database; 2) "ATTACH" your disk database; 3) copy your file database tables to your memory database; 4) "DETACH" your disk database. Regards, ~Nuno Lucas

Re: [sqlite] Versions 2.8.15 and 3.0.3 available

2004-07-27 Thread Nuno Lucas
in my first v3 query code. I will report later if I can't do it. Regards, ~Nuno Lucas

Re: [sqlite] Versions 2.8.15 and 3.0.3 available

2004-07-26 Thread Nuno Lucas
t (exactly because I understood that from the docs) but found it didn't work for empty tables. Regards, ~Nuno Lucas

Re: [sqlite] Versions 2.8.15 and 3.0.3 available

2004-07-26 Thread Nuno Lucas
column names list to display in a grid, even when the result is empty. I think it is better to the user to see them, even if no results are present. Regards, ~Nuno Lucas

[sqlite] OT: Reply-To Munging Considered Useful

2004-07-23 Thread Nuno Lucas
m.com/pw/reply-to-harmful.html). Just food for the brain ;) Regards, ~Nuno Lucas

Re: [sqlite] Dealing with 2 versions of SQLite

2004-07-22 Thread Nuno Lucas
ing a new database, only after the first write the file will be written to (until then, the file will be 0 bytes). I think of this as a design decision. Not one I agree fully, but it's understandable. Regards, ~Nuno Lucas

[sqlite] OT: mailing list nomail option?

2004-07-21 Thread Nuno Lucas
t a filter to delete all messages from the list? I remember someone talking about this, but I couldn't find the post... I also noticed I can't use gmane to send the message (I must send as regular mail to [EMAIL PROTECTED]). Anyone knows why? Regards, ~Nuno Lucas

Re: [sqlite] Bug or it makes sense?

2004-06-25 Thread Nuno Lucas
e line). When they are separate, sqlite considers it is your responsibility to check the error returned, as the rollback has occurred already. That case also baffled me the first time I noticed it. Regards, ~Nuno Lucas -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (

Re: [sqlite] sqlite 3.0.0 - segmentation fault in make test

2004-06-19 Thread Nuno Lucas
2-5.3 attach2-5.5 make: *** [test] Error 1 [EMAIL PROTECTED] $ uname -a Linux tux 2.4.25_pre7-gss-r5 #5 SMP Tue Jun 8 22:48:33 GMT 2004 i686 Pentium II (Klamath) GenuineIntel GNU/Linux - My system: - gcc-3.3.3 - glibc-2.3.3.20040420 - tcl/tk-8.4.6

Re: [sqlite] sqlite 3.0.0 - segmentation fault in make test

2004-06-19 Thread Nuno Lucas
uot;re-ebuild" I noticed I forgot to rebuild tcl dependent packages. That's what I'm doing now. I'll tell you if this fix the issue. Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] sqlite 3.0.0 - segmentation fault in "make test"

2004-06-19 Thread Nuno Lucas
I tried to redirect the test output to a file, but with the segmentation fault the file doesn't get created. I'm sure there is a way to do this but I'm no linux expert ;) Regards, ~Nuno Lucas -- () asc

Re: [sqlite] Version 3.0.0 compiler warnings

2004-06-19 Thread Nuno Lucas
ebuilds go stable, so I don't think it is much of a problem. Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Version 3.0.0 compiler warnings

2004-06-19 Thread Nuno Lucas
ok, I am using tcl-8.3.4 so that explains it. Regards, ~Nuno Lucas === On 2004-06-19, Daniel K wrote === >To fix this you need a TCL upgrade. Any 8.4.* will >work. >Dan. > - To unsubscribe, e-mail: [EMAIL PR

Re: [sqlite] Version 2.8.14

2004-06-19 Thread Nuno Lucas
=== On 2004-06-19, Frank Baumgart wrote === >Nuno Lucas wrote: >> >> os.c, line 836 --- >> zDir = (char*)sqlite_temp_directory; >> --- > >"const char *zDir;" looks more appropriate to me. > >Frank >

Re: [sqlite] Version 3.0.0 compiler warnings

2004-06-19 Thread Nuno Lucas
x1.o(.text+0xfab): In function `btree_insert': ./sqlite-cvs/src/test3.c:775: undefined reference to `Tcl_GetWideIntFromObj' collect2: ld returned 1 exit status make: *** [testfixture] Error 1 --- I assume that is normal in this a

[sqlite] Version 2.8.14

2004-06-19 Thread Nuno Lucas
Casting it, fixes the warning (I believe it is a safe thing to do it in this context). os.c, line 836 --- zDir = (char*)sqlite_temp_directory; --- Regards, ~Nuno Lucas -- () ascii ribbo

Re: [sqlite] SQLite performance with mid-size databases

2004-06-17 Thread Nuno Lucas
ted one. > >Benjamin > Just wanted to second that. Because SQLite is a great product, sometimes people don't realize it's not a general purpose database (just an EXCELENT embebed database engine). My thanks to all commited in th

[sqlite] Fw: Returned eMail: User Unknown

2004-06-16 Thread Nuno Lucas
Could the maintainer please configure the list manager to not send us this kind of messages? It is a litle boring we should have to know what old users e-mail was on the list that are invalid now. Regards, ~Nuno Lucas P.S.- I think my english is a litle bad on this phrase but I couldn't

Re: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Nuno Lucas
much and only related to the local process/thread. Another use is for "server" applications, to be notified of changes in the database from local clients (so he could invalidate his cache, etc.). Regards, ~Nuno Lucas P.S. - I'm very weak on SQL, but I think it isn'

Re: RE: [sqlite] whats the character limit of a single sql in sqlite?

2004-06-14 Thread Nuno Lucas
I'm also curious, now that someone asked. If there is no limit, it is easy to just «mmap» a text file and let sqlite handle it (offcourse a few checks would be necessary). Not that it's a much wanted feature, just a «cool» thing to do with sqlite ;) Regards, ~Nuno Lucas === On

Re: Re: [sqlite] Trying to build tclsqlite.dll AND the tclsqlite.c file

2004-05-30 Thread Nuno Lucas
ectory. If you invoke "bcc32 nmake" it will try to compile the "nmake.cpp" file, and offcourse doesn't find it. What you did in unix terms was "gcc make -f xyz" (doesn't make much sense, does it?) I don't know nothing about TCL, but I have worked with

Re: [sqlite] Trying to build tclsqlite.dll

2004-05-28 Thread Nuno Lucas
..." instead of "bcc32 nmake -f ..." !? ^ Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Re: [sqlite] A proposal for SQLite version 3.0

2004-04-09 Thread Nuno Lucas
your work, so what you decide is enough for me. Regards, ~Nuno Lucas P.S.- Everytime I post something I receive two copies of the message I posted and a warning message for every recipient in the list that isn't available anymore. Co

Re: [sqlite] A proposal for SQLite version 3.0

2004-04-09 Thread Nuno Lucas
program is a better program). On today PCs this is rarely an issue, but with some embebed systems its too slow. I don't know exactly why it takes so much time, but if a file format change is needed to add a row counter to the tables and/or views, why n

Re: [sqlite] sqlite with borland c builder

2004-04-01 Thread Nuno Lucas
ts. I don't work with a borland compiler anymore. Regards, ~Nuno Lucas === On 2004-04-02, Roy Black wrote === >Hello, > >I would like to develop some applications with sqlite. I am using Borland C >builder 6 for these purposes. I was trying to compile/install sqlite for >Bor

Re: [sqlite] sqlite with borland c builder

2004-04-01 Thread Nuno Lucas
ts. I don't work with a borland compiler anymore. Regards, ~Nuno Lucas === On 2004-04-02, Roy Black wrote === >Hello, > >I would like to develop some applications with sqlite. I am using Borland C >builder 6 for these purposes. I was trying to compile/install sqlite for >Bor

Re: Re: [sqlite] SQLite for Win32 TCHAR

2004-03-19 Thread Nuno Lucas
=== On 2004-03-19, Will Leshner wrote === >On Mar 19, 2004, at 7:18 AM, Nuno Lucas wrote: > >> What I believe is in separation of the os.c file for the diferent >> platforms supported. >> A os_unix.c, os_win.c, os_mac.c (and maybe os.c for common code) >> separati

Re: [sqlite] SQLite for Win32 TCHAR

2004-03-19 Thread Nuno Lucas
o). In this case, a .h/.c pair of files would do the trick, maybe titled wsqlite.h/.c. Another pair tsqlite.h/.c would expose the Win32 generic types interface. Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [sqlite] SQLite for Win32 TCHAR

2004-03-19 Thread Nuno Lucas
r is down at the moment (Richard ?). If this helps, here is the error (http://www.sqlite.org/cvstrac/timeline): ----- Query failed Database query failed: REPLACE INTO access_load(ipaddr,load,lastaccess) VALUES('213.205.69.139',1,1079709118) Re

Re: [sqlite] Errors on release mode during link

2004-03-17 Thread Nuno Lucas
build). Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite for Win32 TCHAR

2004-03-16 Thread Nuno Lucas
e a patch, if that is desired. Regards, ~Nuno Lucas === On 2004-03-17, Nuno Lucas wrote === >Just a litle correction > >=== On 2004-03-17, Andrew Francis wrote === >... >> >>Regardless, I'd start by looking at the sqlite ports to Windows CE / >>PocketPC. Fr

Re: Re: [sqlite] SQLite for Win32 TCHAR

2004-03-16 Thread Nuno Lucas
stombs functions of the C runtime, or MultiByteToWideChar/WideCharToMultiByte in the Win32 API. Best regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Compiler errors

2004-01-07 Thread Nuno Lucas
rebuild the DLL. Regards, ~Nuno Lucas === On 2004-01-06, Hennie Peters wrote === .. > >I tried to add the file os.c to the project. Even then this error occurs. > >groet, >Hennie - To unsubscribe, e-mail: [EMAIL PROTECT

Re: [sqlite] Case-Sensitive Queries

2003-12-10 Thread Nuno Lucas
(I'm always in doubt as not being a native english speaker). Regards, ~Nuno Lucas === On 2003-12-08, Raymond Irving wrote === >Hi Everyone, > >I think is expedient that we look into this >case-sensitive issues. I think that queries should not >be case-sensitive, but if that&#x

RE: [sqlite] sqlite with eVC++

2003-11-22 Thread Nuno Lucas
. What needs to be done is to put the cvs in sync with the current sqlite cvs. Regards, ~Nuno Lucas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] temporary files

2003-10-19 Thread Nuno Lucas
I don't have Mac knowledge, but the automatic deletion of temp files is done on the sqliteOsClose() function, at "os.c". Just a clue... Regards, ~Nuno Lucas === On 2003-10-19, Will Leshner wrote === >I've noticed that, on Mac OS X at least, I'm getting a lot of tem

<    1   2   3