Re: [sqlite] Windows performance problems associated with malloc()

ut the same .exe run always perfectly in Windows 7. Some days ago, the problem vanished as suddenly as it appeared, and I suspect that both times was the effect of one of the regular Windows's updates. HTH. A.J.Millan ___ sqlite-users mailing list sqli

Re: [sqlite] When to close a db?

Some time ago, I had a similar error because included a reference to a pointer sqlErrMsgPtr = (CHAR *) sqlite3_errmsg (dbPtr) in my SQLite class destructor. As someone has suggested, does look to be associated with a dangling pointer. HTH A.J. Millan - Original Message - From:

Re: [sqlite] Fw: What languages can include SQLite statically?

the definitive choice is Visual Studio Express. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What languages can include SQLite statically?

Not to say that in PHP you can't link any thing. But perhaps respond to your condition of a simpler language than C that would still be able to include SQLite. There you end with a single script, not an stand alone executable. A.J.Millan - Original Message - From: "Gilles Ga

[sqlite] Fw: What languages can include SQLite statically?

to debug. HTH A.J.Millan - Original Message - From: "Gilles Ganault" <gilles.gana...@free.fr> To: <sqlite-users@sqlite.org> Sent: Friday, May 21, 2010 11:31 AM Subject: [sqlite] What languages can include SQLite statically? > Hello > > My C skills are ver

[sqlite] New book about SQLite

use to get started quickly. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fine-grainy error report needed

ibich" <j...@kreibi.ch> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, November 16, 2009 4:54 PM Subject: Re: [sqlite] Fine-grainy error report needed > On Mon, Nov 16, 2009 at 11:32:59AM +0100, A.J.Millan scratched on the > wall:

Re: [sqlite] Fine-grainy error report needed

that in my case, the C++ compiler is faster that the SQL engine. Any way, again from a theoretical point of view you are right. If you could inspect my code I'm sure that you become horrified with the convolutions I need because my lack of an in deep SQL knowledge. A.J.Millan - Original Message

Re: [sqlite] Fine-grainy error report needed

He list: My apology for respond to myself: Perhaps can be the matter a good candidate to be included in the Extended Error Codes? Greetings A.J. Millan - Original Message - From: "A.J.Millan" <a...@zator.com> To: "General Discussion of SQLite Database" <

Re: [sqlite] Fine-grainy error report needed

on and must be an integer. > Therefore, the error most probably comes from your 'Id' - column. > > Martin > > A.J.Millan wrote: >> Hi list: >> >> Supposing a dBase without constraints (some like this but not limited to >> it): >> >> CREATE TABLE

[sqlite] Fine-grainy error report needed

ta from an attached table. Thanks in advance. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

internationalization. http://codesnipers.com/?q=utf-8-versus-windows-unicode The author asset that .NET is the only platform that offer full UTF-16 support in the Windows API. A.J.Millan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

Jean-Christophe: Thanks for your advice -very helpful and ilustrative for my-. Fortunately I'm not in the same horror history thank to the people in this list, and because I use the old and simple way: say plain SQLite C interface; plain Windows32 C API and plain Visual Cpp (Multibyte build in

Re: [sqlite] Some clarification needed about Unicode

d the database file >in the > first place determines its encoding. After that, it doesn't matter which > API calls > you use: SQLite will convert strings to the database encoding as > necessary. > Pass UTF-16 strings to *16 versions of API accepting void*, UTF-8 to > versions a

Re: [sqlite] Some clarification needed about Unicode

with WideCharToMultiByte(CP_UTF8) [4-1c] Use the result with Win32 api -SetTex()- OR? [4-2a] Read with sqlite3_column_text16() [4-2b] No convertion needed. [4-2c] Use the result ... The opposite to go from GetText() to dBase. -- A.J.Millan - Original Message - From: "Igor Tandetnik"

Re: [sqlite] Some clarification needed about Unicode

-2 before you use it. > Here you address the core question. Thanks for your imput; also to the other senders. Now, do you know about some library to conver to and from UTF-8 or UTF-16 to UCS-2? Thanks again. A.J.Millan ___ sqlite-users mailing list s

Re: [sqlite] Some clarification needed about Unicode

the database. > Really, preventing future possible problems, my textual data was stored as blob. The idea is rebuild converting from 8 bits ASCII to UTF-8. Then the question: can be done with mbstowcs() prior to using sqlite3_bind_text()? A.J.Millan

Re: [sqlite] Some clarification needed about Unicode

rs sets, Unicode, Multibite, and so- but with the details and seasoning of the stew. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Some clarification needed about Unicode

sizeof(w_char) == 2: can be used the UTF-16 content to directly fill an w_char string? Any clarification would be greatly appreciated. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Looking for a w_char alternative for sqlite3_get_table

mechanism. A.J.Millan - Original Message - From: "Nicolas Williams" <nicolas.willi...@sun.com> > On Tue, Sep 01, 2009 at 10:41:27AM +0200, A.J.Millan wrote: >> * Make sure there was no 16-bit version of the sqlite3_get_table at >> function -perhaps it would be

Re: [sqlite] Looking for a w_char alternative for sqlite3_get_table

Atul, Igor: Thanks for your kind replies. In fact, actually I'm using the new style querys, and my question was an attempt to: * Make sure there was no 16-bit version of the sqlite3_get_table at function -perhaps it would be a good idea to include it in the standard API. The reason is the

[sqlite] About the substr(x,y,z) core function

Of course it is rather obvious, but to me supposed some headache. HTH. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Looking for a w_char alternative to the sqlite3_mprintf famili of functions

= L"My Chinese Name"; w_char *zwSQL = sqlite3_x ("INSERT INTO table VALUES('%q')", zwUserName); Some suggestion? Thanks in advance A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .lib file?

Studio, the sqlite3.c file must be compiled as "C". See in: File-Properties > C/C++ > Advanced > Compile As Select "Compile as C Code (/TC)" The rest of the project can remain compiled as usual C/C++ files. Probably you must disable the use of precompiled he

Re: [sqlite] design question / discussion

Rich Rattanni wrote:>Hi I have a general design question. I have the following senario... >In an embedded system running linux 2.6.2x I have a sqlite database >constantly being updated with data acquired by the system. I cant >lose data (hence why I am using sqlite in the first place). However

Re: [sqlite] text datatype and referential integrity

- Original Message - From: "palmer ristevski" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" > I always saw SQLite as trying to be the database to beat out MS Access > for the desktop user. > And due to this belief I thought that referential

Re: [sqlite] Help with sqlite3_blob_open()

That work! Thanks a lot. Adolfo. - Original Message - From: <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, March 24, 2008 1:48 PM Subject: Re: [sqlite] Help with sqlite3_blob_open() > "A.J.Mil

[sqlite] Help with sqlite3_blob_open()

Hello all: Using Windows XP: D:\Z\Zator5>sqlite3 zdb1 SQLite version 3.5.4 Enter ".help" for instructions sqlite> .tables AgEfHolder AgEfemerAgVtHolder AgVtos Usr lnk AgEfIDt AgPdHolder AgVtIDt Block atm prm AgEfKlv AgPdIDt AgVtPre FreqUse

Re: [sqlite] Last insert in a table

. Cheers. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Last insert in a table

date of the table/s of my interest, but I try avoid global variables, so my question. Thanks anyway. A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Last insert in a table

in advance A.J.Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Re: About designing a query in sqlite3-style

My mistake: Of course, in the design A, the resp in while (resp == xxx) refers to the result in the prepare statement sqlite3_prepare_v2() Adolfo - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] About designing a query in sqlite3-style

Hi: Assuming that the definition of the dBase does not change, I wonder if the two pseudo code schemas are equally valid or if there are pros and cons in each one: // Design -A- do { // Compile the statement into a virtual machine resp =

Re: [sqlite] compiling for mingw

on Fri, 30 Nov 2007 15:21:56 -0800 Joe Wilso wrote: I would not bother with make install on MinGW - too much hassle - just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually to wherever you want to put it. Joe:So, do is there a libsqlite3.a file?Where is it?Thanks--

Re: [sqlite] Trying to build a static library

pretty well compiling projects in both C and C++ using that platform. Some idea? I use static libraries and gcc. Just use --enable-static and you should get the link library created. A.J.Millan wrote: Hi all: Instead the supplied DLL, I would like to statically link the SQLite library in a new

[sqlite] Trying to build a static library

. A.J.Millan - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Data encryption

mation and ideas, but this morning the URL was unable. May be if you recite certain magic spell, Günter can appear again... Cheers A.J.Millan - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Suggests for improving the SQLite website

Regarding the basic "look" of the site, we were considering using a style similar to the once found at ActiveState http://www.activestate.com/ However the tendency in computers screen is wider than until now. Today the standard is about 1440 pixels x 900, so a unique horizontal arrange y

Re: [sqlite] Suggests for improving the SQLite website

but can't afford the cost of a maintenance subscription (or don't need it); put a "donate" button and add a list of contributors. A.J.Millan - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: A beginner SQL question

the fact that, in this case, the columns are integers, can be done some trickery in the concatenation to avoid that? Some like: A||'*'||B||'*||C ? A.J.Millan - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Re: A beginner SQL question

. A.J.Millan A.J.Millan <> wrote: Suppose a table: CREATE TABLE 'myTable' ( A INTEGER NOT NULL, B INTEGER NOT NULL, C INTEGER); Do is there some query to return if there are some duplicate files and/or who are they? Consider duplicate file if there are two or more rows with the same values. I.E

[sqlite] A beginner SQL question

I All: Suppose a table: CREATE TABLE 'myTable' ( A INTEGER NOT NULL, B INTEGER NOT NULL, C INTEGER); Do is there some query to return if there are some duplicate files and/or who are they? Consider duplicate file if there are two or more rows with the same values. I.E: two or more with

[sqlite] About cloning a table in a new dBase

Hi all: Suppose a dBase named dBase1 and a table declared in it: CREATE TABLE 'tb1' (Id INTEGER PRIMARY KEY, Nm INTEGER, Ci INTEGER); Then, after some inserts I open a new dBase, say dBase2, and duplicate dBase1.tb1 with the C API functions executing the querys: "ATTACH dBase1 AS

Re: [sqlite] Why do you use SQLite? Comments for an article needed

us competitors" part of the sentence. In fact there are not so many dbases that match the proposed conditions for it's Bureau. A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] About a Vista problem

the sources. So I plain do some test with the "official" one, and because in my situation isn't there a real need of a "shared" library, I plain do some tests using a library statically linked with he application instead. I would be gratefully to hear other experiences about this. A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] About a Vista problem

;. Note that despite that the application runs Ok in Windows98, the option "Compatibility with Windows98/Windows ME) hangs the proccess :-D Note also that it wasn't necessary to run with administrator privileges. [1] I'm unsure of the true title of those options in the english version (I'm tran

Re: [sqlite] A suggestion

it with sqlite3.exe that ability is lost. By the way, after this response, I have been looking in the XP box and there are a doskey.exe, but does not work in that way, but when try with sqlite3 in it, that works fine!! Perhaps that would make me jump to that system despite my reluctance :-) A.J.Millan

[sqlite] A suggestion

helpful. A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: How to obtain the integer part of a result

-in aggregate funcion? Thanks in advance A.J.Millan ZATOR Systems - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Sunday, May 06, 2007 3:32 PM Subject: [sqlite] Re: How to obtain the integer part of

Re: [sqlite] I'm Starving for New User Information

e it worth its price. A.J.Millan ZATOR Systems. - Original Message - From: "km4hr" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, May 07, 2007 2:59 AM Subject: [sqlite] I'm Starving for New User Information > > Is there a sqlite intro

[sqlite] How to obtain the integer part of a result

, neither SELECT round(julianday('now')-Dat, 0) FROM SomeTable WHERE ...; Produces the desired result. I always get xxx.0 (1 decimal). A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Make test under windows

Surely You must link those two files explicitly in yours project. A.J.Millan > Hi All, > > I'm trying to compile sqlite3.3.16 under windows using MinGW, and MSYS, when typing make, it compiles correctly, but make test, give me 2 errors > gcc.exe user32.lib [no such file or director

[sqlite] Query before ending a query

y to avoid the error? I suppose that not always is possible perform all desired actions in a single SQL query. Is that correct? Is there a best way to get that kind of results? Thanks in advance A.J.Millan ZAT

Re: [sqlite] how it works

> Hi > > I need to know how this works in detail: > I have sqlite3 database file stored on SD/MMC FLASH card and i would to insert > rows to some tables often. There will be triggers to clean old and obsolete > data. > How often it will write to database file? After every INSERT command, or it >

Re: [sqlite] Search engines and the Sqlite.Org website

>> I consider the behavior of the MSN bot to be abusive. I'm >> sorely tempted to ban the MSN bot from the entire sqlite.org >> website. Absolutely agree. >> If SQLite ceased to be indexed by MSN, would that >> seriously inconvenience any users? IMHO none at

Re: [sqlite] stupid man's manual to sqlite?

t E. Rector and Joseph M. Newcomer, Addison-Wesley. A "brick" with 1522 pages, those that the index occupies 187 pages of words to three columns per page. The one that can let You pass three years of continuous trips without getting

Re: [sqlite] stupid man's manual to sqlite?

>I will get back to you about the index. I also would like to invite >anyone else who has any specific things they would like to see changed >in the index to tell me. Assuming I can get a revised index out >electronically, I will make any such changes immediately to the file I >have on-hand. >--

Re: [sqlite] stupid man's manual to sqlite?

>.For the record, Apress had the index generated by a third party. I've >used the index myself recently, and frankly it worked for me -- I >found what I was looking for. >The SQL and C API references to which you refer --- taken from the >on-line documentation --- start on page 365. Furthermore,

Re: [sqlite] stupid man's manual to sqlite?

lf is about SQL generalities, an a quarter a copy-paste of the on-line manual without more comment. At the end, the horrific index i've ever seen. A.J.Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Newbie question about LIKE and ESCAPE

- Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" Sent: Sunday, March 04, 2007 12:59 AM Subject: [sqlite] Re: Newbie question about LIKE and ESCAPE > For example, this query retrieves all rows where someField contains '%' > character:

[sqlite] Newbie question about LIKE and ESCAPE

veil me the correct syntax for that query? Can I use some like: SELECT someField IN someTable WHERE name LIKE 'xyzetc' ESCAPE ; Thanks in advance. A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Newbie SQL question

Igor: Thank you very much for your's help A.J.Millan - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Tuesday, February 06, 2007 10:50 PM Subject: [sqlite] Re: Newbie SQL qu

Re: [sqlite] Newbie SQL question

Dennis: Thank you very much for your's Help. A. J.Millan - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 06, 2007 11:16 PM Subject: Re: [sqlite] Newbie SQL question > > > Yes. See the documentation for PRAGMA

[sqlite] Newbie SQL question

Hi all: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? Thanks in advance --- A.J.Millan ZATOR

[sqlite] Fw: Problem in version 3.3.10

Hi: An application was running Ok under version 3.3.7. When recompiling with v. 3.3.10, crashed at certain point in runtime. "invalid page in module MSVCRT.DLL of 0167:780027a3". The Sistem is running MS Windows98 SE fully patched. Msvcrt.dll is version 6.10.8924.0. I compile with

[sqlite] Trouble ensuring partial uniqueness in trigger

Let's say: CREATE TABLE tableA ( Id TEXT, Cl INTEGER ... ); I need the following conditions: a: Both fields, Id and Cl, can be NULL b: If Id is not null, then the pair Id - Cl must be unique. I use a TRIGGER for BEFORE INSERT on tableA that works pretty well for the

Re: [sqlite] Re: Trouble with Trigger

Igor: Your answer includes two points that I consider very illustrative, at least for my. Although I am relatively new in this forum, I believe that your interventions always mean interesting. Greetings. A. J. Millan - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To:

Re: [sqlite] Trouble with Trigger

Dennis: Thanks for unveil (to me) that interesting page. Greetings A. J. Millan - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, November 14, 2006 12:57 AM Subject: Re: [sqlite] Trouble with Trigger >

[sqlite] Trouble with Trigger

I want know if is possible to do a DELETE, INSERT or UPDATE statement from inside a TRIGGER. Let's say: CREATE TABLE tableA ( Id INTEGER, ... ); CREATE TABLE tableB ( Ref INTEGER, ... ); CREATE TRIGGER DeleteReferences BEFORE DELETE ON tableA BEGIN SELECT CASE WHEN (SELECT count(*)