[sqlite] Bug: SQLite 3.27.1 does not compile with SQLITE_OMIT_WINDOWFUNC

2019-02-10 Thread Victor Costan
In case it helps anyone else, I plan to use the patch below to bypass the compilation error in Chrome. I'd appreciate a sanity check. I would also be very grateful for a check-in that addresses the compilation issue, so we can remove our patch in a future update. Thank you very much! V

Re: [sqlite] Bug: SQLite shell does not build on Windows with SQLITE_OMIT_COMPLETE

2018-11-16 Thread Victor Costan
Thank you very much, Dan! I was about to come back to report that my fix is incorrect. Your fix does the trick. Thank you! Victor On Fri, Nov 16, 2018 at 6:38 AM Dan Kennedy wrote: > On 11/16/2018 08:41 PM, Victor Costan wrote: > > The amalgamation build ships two defin

[sqlite] Bug: SQLite shell does not build on Windows with SQLITE_OMIT_COMPLETE

2018-11-16 Thread Victor Costan
prefix. This causes our Windows compiler to complain. Can you please add SQLITE_API to the shell.c line that starts with "int sqlite3_complete("? Thank you very much, Victor ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

[sqlite] Bug: ALTER TABLE RENAME (still) calls authorizer functions

2018-10-05 Thread Victor Costan
dif I hope this is useful, Victor ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-08-14 Thread Victor Costan
On Mon, Jul 23, 2018 at 3:57 AM Dan Kennedy wrote: > On 07/22/2018 07:48 PM, Victor Costan wrote: > > In a custom SQLite build, SQLITE_DEFAULT_LOOKASIDE results in compilation > > errors, unless used with SQLITE_OMIT_COMPILEOPTION_DIAGS. > > > > This is because src/cti

[sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-07-22 Thread Victor Costan
E), #endif However, CTIMEOPT_VAL (defined in the same file) is a one-argument macro: #define CTIMEOPT_VAL_(opt) #opt #define CTIMEOPT_VAL(opt) CTIMEOPT_VAL_(opt) I suspect that an easy fix would involve defining a 2-argument macro as CTIMEOPT_VAL(arg1) "," CTIMEOPT_VAL(arg2). I hope this i

[sqlite] Build SQLite.Interop for MAC

2018-07-20 Thread Victor Da Costa
Hello, I'm trying to build the SQLite.Interop on MAC from the source code located on System.Data.SQLite.org. After building the library my application seems to detect it but I get this error on the Password field : System.EntryPointNotFoundException: Unable to find an entry point named "sqlit

[sqlite] A possible double bug?

2016-10-16 Thread Victor Evertsson
ug or intendent behavior? Best regards Victor ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite in vba7.1 and windows 8.1

2016-02-19 Thread Montes Cámara, Victor
Hello, I've been using sqlite in vba6 for some years using RichClient3 framework of Olaf Schmidt (www.datenhaus.de) Now I'm migrating my application to 64 bits using vba7 in Windows 8.1. The problem I'm facing is with the LoadLibrary function to load dynamically the DLL DirectCOM.dll The de

Re: [sqlite] tcl incrblob interface

2011-08-12 Thread Victor Mayevski
That's exactly what it was. Thanks On Wed, Aug 10, 2011 at 11:37 PM, Dan Kennedy wrote: > On 08/10/2011 11:24 PM, Victor Mayevski wrote: >> Hello, >> >> I am trying to learn how to use the "incrblob" command in the Tcl >> interface and I can't

Re: [sqlite] tcl incrblob interface

2011-08-12 Thread Victor Mayevski
Thanks Richard, this is very useful. On Wed, Aug 10, 2011 at 9:46 AM, Richard Hipp wrote: > On Wed, Aug 10, 2011 at 12:24 PM, Victor Mayevski wrote: > >> Hello, >> >> I am trying to learn how to use the "incrblob" command in the Tcl >> interface an

[sqlite] tcl incrblob interface

2011-08-10 Thread Victor Mayevski
Hello, I am trying to learn how to use the "incrblob" command in the Tcl interface and I can't get it to work. I create a one column table "t", insert one empty value into it, than do "db incrblob t a 1", which works fine, I get a file pointer back "incrblob_1". Then I do "puts incrblob_1 "hello w

[sqlite] possible bug "foreign key mismatch" in TCL

2011-07-12 Thread Victor Mayevski
#or update users set name = 'user1', pass = 'pass2' #if I remove one of the foreign keys from users1 table, the error goes away. #The exact same replace and update commands work fine under sqlite3 shell, version 3.7.2-1ubuntu0.1, 32 bit Thanks, Victor __

Re: [sqlite] Process memory space exhausted in 3.7.0

2010-08-12 Thread Victor Morales-Duarte
ON;", NULL, NULL, NULL ); } Is currently running, but it looks like it will take quite a bit of time for it to finish, so I'll have to update you tomorrow. Victor -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Ke

Re: [sqlite] Process memory space exhausted in 3.7.0 - Bayesian Filter detected spam

2010-08-12 Thread Victor Morales-Duarte
;) hits the 2GB max. Commiting without closing the connection did not help. I'll write the code for the corresponding tests and I'll reply again later today. Later! Victor -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On B

Re: [sqlite] Process memory space exhausted in 3.7.0

2010-08-09 Thread Victor Morales-Duarte
you break up the insert into chunks _and_close_the_connection_between_chunks_ then the error does not occur. This is even more bothersome because there is also no documentation saying that there would be a limit on the number of operations that can be performed on a single connection. Should I open a bug for this? Thanks a lo

[sqlite] Process memory space exhausted in 3.7.0

2010-08-05 Thread Victor Morales-Duarte
a reply to this email. Thank you!!! Victor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] triggers revisited

2009-11-03 Thread Victor Mayevski
Ok, I will rephrase my question although it appears that the answer is has been already preconceived. I am writing an abstraction layer to Sqlite where tables, views, triggers etc are presented as XOTcl Classes/Objects. If two different scripts access the database and one of them creates a new tabl

[sqlite] tirgger everywhere and always

2009-11-02 Thread Victor Mayevski
Is it possible to implement triggers that fire up for each independent session? For example, I am using TCL, define a function in TCL, register it with SQLite, create a trigger to call that function every time an update happens to some table. Well, it works just fine for that specific open session.

[sqlite] datatype - serial

2008-09-22 Thread Victor Hugo Oliveira
hi everybody, SQLite 3 doesn't have a 'serial' datatype? If not is there a simple way that i can implement myself (i'm not a very experient programmer)? thanks Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com. http://br.new.mai

[sqlite] 3.5.1, 64 bits, io test

2007-10-11 Thread Victor Secarin
distro's tcl-8.4.13-1.1 Should I try updating from cvs ? Please advise, Victor Secarin --- This e-mail, including any attached files, may contain confidential and privileged inform

[sqlite] bigfile test

2007-08-21 Thread Victor Secarin
t;, which would enable one to use grep or search in an editor. Then the problem above could be a WARNING rather than a counted ERROR. yours truly, Victor Secarin --- This e-mail, including

[sqlite] building 3.4.2 on solaris

2007-08-16 Thread Victor Secarin
oint that way, but I think I better ask. Do I have to find the compiler flag for that and build that way? please advise, and thank you very much, yours truly, Victor Secarin --- This e-mail, in

Re: [sqlite] building 3.4.1

2007-08-10 Thread Victor Secarin
boxes has been changed. On Fedora5 which has tcl8.4.13 this does not happen either. The only useful lesson seems to be (a) use a new tcl and (b) stay away from networks when testing or at least (c) test on a fast computer. just my two bits, yours truly, Victor Secarin Joe Wilson wrote: The

Re: [sqlite] building 3.4.1

2007-08-03 Thread Victor Secarin
4-1.3... Error: database is locked lock4-999.1... Ok Memory leaked: 0 bytes in 0 allocations Thread-specific data deallocated properly 1 errors out of 5 tests Failures on these tests: lock4-1.3 ===== Victor Secarin Joe Wil

Re: [sqlite] building 3.4.1, running tests

2007-08-03 Thread Victor Secarin
Is there a way to run a single test of my choice? Victor Secarin Joe Wilson wrote: Can you post the output for the failed tests? i.e.: footest-13.1... Expected: [10] Got: [0] --- Victor Secarin <[EMAIL PROTECTED]> wrote: Hello, everyone. I just started to look at the softwa

Re: [sqlite] building 3.4.1

2007-08-03 Thread Victor Secarin
very much, Victor Secarin A. Fulltest on Fedora 5 (64 bits) with glibc-2.4-11/gcc-4.1.1: === 3 errors out of 240587 tests Failures on these tests: lock4-1.3 malloc2-1.1.28.5 malloc2.1.5 lock4-1.3... Error: database is locked malloc2-1.1.28.5..

[sqlite] building 3.4.1

2007-08-01 Thread Victor Secarin
-92.7. The libsqlite3 builds but the second, tcl-specific library does not compile; it seems the only error is "Tcl_WideInt undeclared". So then the tests cannot be run. Any guidance gratefully appreciated. Please advise, and thank

[sqlite] Compatibility sqlite 2.8 and 3.x

2006-10-28 Thread victor . camus
true with 2.8.17 available on the sqlite homepage?), the idea would be to create a sqlite database in 2.8 and to access it in Fortran with a sqlite library in 2.8 and a tcl API in 3.0. Does it make sense? Victor - To

Re: [sqlite] Compiling Sqlite with Openwatcom

2006-10-25 Thread victor . camus
s the first step to generate a library that I will use to access > Sqlite > >from Fortran following the instructions given by Danial at > >http://danial.org/sqlite/fortran/(my next step) > > > > > > > Hello Victor, > > I know almost nothing about the Op

[sqlite] Compiling Sqlite with Openwatcom

2006-10-25 Thread victor . camus
. corresponding to the line void (*interrupt)(sqlite3*); This is the first step to generate a library that I will use to access Sqlite from Fortran following the instructions given by Danial at http://danial.org/sqlite/fortran/(my next step) Any help is welcome Victor

Re: [sqlite] Sqlite & Matlab

2006-10-25 Thread victor . camus
t mean it does > not > > really work? > > > > > > > Victor, > > I took a quick look at the code there. It hasn't been updated for a year > or so, but it seems like it should be functional as is. > > It should work OK for small result sets, since it lo

[sqlite] Sqlite & Matlab

2006-10-24 Thread victor . camus
Hi All There seems to be a possible connection between Sqlite and Matlab available at http://sourceforge.net/project/showfiles.php?group_id=139986 However it is not refered to on the sqlite website. Does that mean it does not really work? Thank you in advance for your answer Victor

Re: [sqlite] formating yyyymmdd dates

2005-08-31 Thread victor...
you can store you dates like integers using time(). So you can use strftme without any string operation. []'s Victor Lawrence Chitty <[EMAIL PROTECTED]> escreveu: DuenosEnLaWEB.com.ar wrote: >hi > >I have this format for dates: mmdd >I want this format to be retur

Re: [sqlite] checking the database status

2005-08-26 Thread victor...
you can check if some table of your db exits. The file generated is empty. []'s Victor Dennis Jenkins <[EMAIL PROTECTED]> escreveu: Robert Simpson wrote: > um ... It's a file. You just check to see if the file exists. No > sqlite calls involved. > > Robe

[sqlite] sqlite3_step() question

2005-08-11 Thread victor...
w can I take the old row? I need to use a pointer to all steps of a stmt?? There's the possibility of make a function called sqlite3_step_at_position()?! I need some ideas. Thank's []'s Victor "Só existem 10 tipos de pessoas, as que sabem e

Re: [sqlite] Date Comparison

2005-05-25 Thread victor...
it returns a char with the date formatted. []'s Victor Kurt Welgehausen <[EMAIL PROTECTED]> escreveu: > Already did. > It doesn't talk about date comparison. Dates are stored in SQLite as strings or numbers (your choice). Comparisons of dates are just comparisons of