Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

Irreproachable argumentation, which in my humble opinion is little or nothing useful to those who want to enter in the diabolic world of SQL. Especially, if you have not yet managed to change the chip and find out that for example, you must carry out a program without using variables. All the

Re: [sqlite] Question about floating point

Although the problem is well known by the readers, may be someone would like remember the basics (somethin written by me some years ago -in spanish-). http://www.zator.com/Cpp/E2_2_4a.htm If you want "play" whiths the numbers in IEE754 this page bay be the fun (unfortuately, the original is not

Re: [sqlite] C++ compiler

Hi: Not only it can, but that is probably the use in the 99.00% of C++ applications that uses SQLite. The only caveat is that you can get some warnings depending on the compiler you use. Cheers -- Adolfo J. Millan > > Mensaje original > De: eli > Para:

Re: [sqlite] Converting an sqlite database into format that anAndroid app can uses?

> Mensaje original > De: Csányi Pál > Para: SQLite mailing list > Fecha: Mon, 28 Aug 2017 15:50:13 +0200 > Asunto: Re: [sqlite] Converting an sqlite database into format that > anAndroid app can uses? > >I understand. >If

[sqlite] WinForms | WPF: Using SQLite DataBase

Perhaps maybe of interest to those beginners using SQLite in Windows. WPF: Using SQLite DataBase https://www.codeproject.com/Tips/988690/WinForms-WPF-Using-SQLite-DataBase-For-User-For-Ap HTH -- Adolfo J. Millán. ___ sqlite-users mailing list

Re: [sqlite] Sqlite + Dropbox

> De: Nigel Verity > Asunto: [sqlite] Sqlite + Dropbox > > I have just started using Dropbox to share documents. If I place a Sqlite > database in my Dropbox folder I access it from a local application as a local > file. This is then automatically synced with the copy

Re: [sqlite] confused getting started

Besides the need to include RDBMS engine inside your application, and manage it from the code. You have a standalone application (sqlite3.exe) who let manage your databese from the CLI (command line interpreter) of your system, and play whit the majority options who SQLite offer. HTH. --

Re: [sqlite] Thread safety of serialized mode

> Mensaje original > De: Richard Hipp > Para: SQLite mailing list > Fecha: Tue, 14 Feb 2017 20:15:49 -0500 > Asunto: Re: [sqlite] Thread safety of serialized mode >> > > On 2/14/17, Darren Duncan wrote:

Re: [sqlite] Why does a query run 50x slower across a network?

Besides my own experience, although it is a bit older and I couldn't find it in this email list, It is still in my archive, so there you have (copy-paste) of related email of 2014-09-08 in this list, send by jose isaias cabrera <...@cinops.xerox.com> in response of a query: Re: [sqlite] Does

Re: [sqlite] Why does a query run 50x slower across a network?

In respect to the Windows environment I've appreciated that the use of UNC convention over a network (LAN) behaves much slower that "mapping" the logical unit as a drive letter D, E, .. Z in the local host. Altought unfortunately this doesn't seem very handy in all situations. -- Adolfo. > >

Re: [sqlite] Slight incompatibility of v. 3.16.2 from previousreleases (compiler error)

> Mensaje original > De: Dan Kennedy > Para: sqlite-users@mailinglists.sqlite.org > > On 01/30/2017 05:39 PM, a...@zator.com wrote: >> Hi list: >> >> Building with SQLite v. 3.16.2 and MS VC++ 2015 (v 14.0) there appeared a >> linker error: >> >> Error LNK2019

[sqlite] Slight incompatibility of v. 3.16.2 from previous releases (compiler error)

Hi list: Building with SQLite v. 3.16.2 and MS VC++ 2015 (v 14.0) there appeared a linker error: Error LNK2019 external simbol _sqlite3FkReferences unresolved in function _sqlite3Insert Who belong (I suppose) to a compiler warning: line 109039: warning C4013: 'sqlite3FkReferences' undefined

Re: [sqlite] Does the Connection string support UNC paths?

> > Mensaje original > De: "Chris" > Para: > Fecha: Sat, 6 Sep 2014 23:46:19 -0500 > Asunto: [sqlite] Does the Connection string support UNC paths? > > > >I am old database programmer that just came across SQLite and am working

[sqlite] MS open source Portable Class Library for SQLite

May be that some know it already, but digging the Web to know about the client-side storage Web SQL Database, I've found this post of MS Open Technologies, that may be of interest to many of you who often ask about SQLite in Window Phone.

Re: [sqlite] Support SQLite in México

Hi Francisco: I can tell you that this list, is plenty of very clever people who sure can help you if in trouble -supposing you know how to ask-. Usually here a an incredible technical level and service intention for free. But as a last resource, you can get professional support from the

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 versionandlater

Igor: You're right. Thanks you and congratulations on your fine smell. As indicated in the OP, indeed I was using relative path with the "original" table. I wish I had thought before, especially, because I remember that some time ago, I had problems for the same reason, it seems, Visual

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version andlater

Problem (partially) solved: Using MS Windows 8; MS Visual Studio 2012 for desktop, and SQLite 3.7.15.1 I get consistently the following behavior for the application: Running in Debug-mode, fails as reported in the OP. Running in Release-mode (without debugging), fails as reported. Starting

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

> > Mensaje original > De: Pavel Ivanov > Para: a...@zator.com, General Discussion of SQLite Database > > Fecha: Wed, 09 Jan 2013 16:08:51 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.75 version and > later > >

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

> > Mensaje original > De: Clemens Ladisch > Para: sqlite-users@sqlite.org > Fecha: Wed, 09 Jan 2013 14:25:31 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version > andlater > > > >a...@zator.com wrote: >>int resp =

[sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

Hi list: I've an application who from a long time, worked in Windows 98; XP; Vista; W7, and now in W8. The things go fine until now, but with SQLite versions 3.7.15 and 3.7.15.1, sqlite3_prepare_v2() fails and return 1. Here is a brief of the situation: 1.- The application is running in a

Re: [sqlite] SQLite Encryption Extension Performance?

Hi: Assuming using SEE, do is there the ability to decide what I/O operations are to be performed encrypted or with the plain (as is) content? I'm planning an application with only selected data encripted (in each row of certain tables, there is a flag showing the encrypted/plain state).

Re: [sqlite] Query by License -Consulta por Licencia

Guillermo: Due to generous copyright conditions of its author DRH, you can use SQLite in any application you want and for any purpose. HTH -- -- Adolfo J. Millan Zator Systems. > > Mensaje original > De: Guillermo Soland > Para: sqlite-users@sqlite.org >

Re: [sqlite] How point numbers are they stored in sqlite?

> From: Paxdo Presse > To: General Discussion of SQLite Database > Date: Tue, 17 Apr 2012 11:12:45 +0200 > Subject: [sqlite] How point numbers are they stored in sqlite? > >Hi, > >How point numbers are they stored in sqlite? > >In a field with REAL

Re: [sqlite] how to export to html file with table

Hi: Perhaps some of you would be interested AscToTab, a free utility that is over there from a long time. http://www.jafsoft.com/asctotab/ HTH. Adolfo J. Milllán. Z.S. > > Mensaje original > De: Simon Slavin > Para: General Discussion of SQLite Database

Re: [sqlite] How about a proper forum rather than an e-mail list

Definitely I would like to have the SQLite mail list in a fashion as StackOverlow. > > Original Message > From: epank...@comcast.net > Sent: Tue, 18 Oct 2011 16:23:11 +0200 > > > >I'll say one thing - a forum would have saved me the wasted time of having to >download and then

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

Roger: Thanks for your input. Really already I was using the suggested functions, but for some reason, the sections with strings where user inputs can be adds single quotes, have maintained that legacy code. Any way thanks again,althought I need verify that the "bind" method does not have

Re: [sqlite] How to get the actual user-name and password?

Simon: Thanks for your's input. Really it is there, in the last line. I has been blind. A.J. Millan On 26 Jul 2009, at 12:47pm, a...@zator.com wrote: > I can't find the way to accesso to the list and get the forgotten > password. Click on the link at the bottom of every post. Simon.

[sqlite] How to get the actual user-name and password?

I can't find the way to accesso to the list and get the forgotten password. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What is quicker?

In relation with the floating point number and its IEEE internal representation, may be of interest: http://babbage.cs.qc.edu/IEEE-754/ HTH Adolfo ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] design question / discussion

> Hi I have a general design question. I have the following senario... IMHO your design sound reasonable. In relation with the vacuum question I suggest try to delete and re-create each table and watch both timings. HTH Adolfo ___ sqlite-users

Re: [sqlite] SQLite version 3.5.9

On Wed, May 14, 2008 at 3:40 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > >> >> WORKAROUNDS: >> >> Or, brute force: Copy the file locally, do your stuff, copy it back. >> > Looks like the brute force solution is the only answer here. (Translated automatically from the Spanish original)

Re: [sqlite] a suggestion to write tutorial for sqlite

Why not include a section "User Contributed Notes" (in the style of the php doc) besides each page of the SQLite man pages? specially those devoted to: 1. List Of Objects 2. List Of Constants 3. List Of Functions HTH Adolfo. -Original Message- From: D. Richard Hipp [mailto:[EMAIL

Re: [sqlite] SQL Quick Review/Reference

Mike: As a purchaser of your Book, I think that perhaps you can have a copy of the book in plain text form. Then, with a little effort can be made a index of words, and (also) perhaps it would be easier that Apress let you publish it. In respect to the index creation I would help in that.

Re: [sqlite] reading MS Access 97 files

Perhaps this URL can help you http://www.allbusiness.com/technology/software-services-applications-programming/5893603-1.html Good luck, and greetings Adolfo. -Original Message- From: John Grant [mailto:[EMAIL PROTECTED] Sent: Thursday, April 10, 2008 05:59 PM To: 'General Discussion

Re: [sqlite] ticket 3007

In general I believe that is a good idea give to the developer the maximun control of what happen under the hood. Greetings Adolfo -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Friday, April 4, 2008 08:15 PM To: sqlite-users@sqlite.org Subject: [sqlite] ticket 3007 Any

[sqlite] Looking for a cryptographic library

Hi all: I'm writing an application that uses SQLite to store user's data, and need a library to crypt some stuff, including passwords and data. The goal is to crypt before insert and decript after extract tha data, so this last can't be seen by others who gain access to the SQLite dataBase.