Re: [sqlite] Conversion failure

On Fri, Jun 24, 2016 at 11:36 AM, Simon Slavin wrote: > > On 24 Jun 2016, at 4:34pm, Igor Korot wrote: > >> What do you mean? >> I'm talking here about the SQLite shell tool downloaded from the >> official web site (the executable). >> I'm NOT t

Re: [sqlite] Conversion failure

Simon, On Fri, Jun 24, 2016 at 11:34 AM, Igor Korot wrote: > Simon, > > On Fri, Jun 24, 2016 at 11:13 AM, Simon Slavin wrote: >> >> On 24 Jun 2016, at 3:55pm, Igor Korot wrote: >> >>> Are those 3 scenarios correct? >> >> They are if the shell t

Re: [sqlite] Conversion failure

Simon, On Fri, Jun 24, 2016 at 11:13 AM, Simon Slavin wrote: > > On 24 Jun 2016, at 3:55pm, Igor Korot wrote: > >> Are those 3 scenarios correct? > > They are if the shell tool (or any other SQLite software) works the way it > should do. If you have found a situation

Re: [sqlite] Conversion failure

Rowan et al, On Fri, Jun 24, 2016 at 4:34 AM, Rowan Worth wrote: > On 24 June 2016 at 16:13, Simon Slavin wrote: > >> On 24 Jun 2016, at 5:04am, Igor Korot wrote: >> >> > But everything should work independently of what code page is being used? >> >

Re: [sqlite] Conversion failure

Kevin, On Thu, Jun 23, 2016 at 11:39 PM, Kevin Benson wrote: > -- >-- > -- > --Ô¿Ô-- > K e V i N > > On Thu, Jun 23, 2016 at 10:38 AM, Igor Korot wrote: > >> Hi, Clemens, >> >> On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch

Re: [sqlite] Conversion failure

Simon, On Thu, Jun 23, 2016 at 8:44 PM, Simon Slavin wrote: > > On 23 Jun 2016, at 11:42pm, Igor Korot wrote: > >> OK, so are they UTF-8, UTF-16 or something else? >> And I'm talking the default one - the one which is set when I just >> open the shell tool and sa

Re: [sqlite] Conversion failure

Simon, On Thu, Jun 23, 2016 at 6:14 PM, Simon Slavin wrote: > > On 23 Jun 2016, at 10:53pm, Igor Korot wrote: > >> So what I'm trying to do is to see what will happen if I get a >> database with the German character(s) >> or Asian characters in the table/fie

Re: [sqlite] Conversion failure

Hi, Ralf, On Thu, Jun 23, 2016 at 12:38 PM, Ralf Junker wrote: > If you are on Windows, you can use SQLiteSpy to correct such wrongly entered > ANSI text to Unicode throughout an entire database: It is not wrongly entered text. I am using Windows with English locale only. So what I'm trying to

Re: [sqlite] Conversion failure

unds like there is a byte sequence before the string, which identifies the encoding. Will this help? Thank you. > > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@mailinglists.sqlite.org > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Igor > Kor

Re: [sqlite] Conversion failure

should be in some kind of UTF encoding (UTF-8 or UTF16). And I didn't explicitly changed the encoding at all. Thank you. > > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@mailinglists.sqlite.org > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Au

Re: [sqlite] Conversion failure

Hi, Clemens, On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> I am trying to find out why the following code fails to do proper conversion. >> It works if the tableName have "abcd", but fails if it has "abcß" (the >> Ger

[sqlite] Conversion failure

Hi, I am trying to find out why the following code fails to do proper conversion. It works if the tableName have "abcd", but fails if it has "abcß" (the German letter for the "ss" (looks like Greek letter beta)). struct Table { std::wstring name; std::vector fields; std::vector foreign

Re: [sqlite] Version issues on Mac after updating

Hi, On Tue, May 31, 2016 at 11:01 AM, Dominique Devienne wrote: > On Tue, May 31, 2016 at 4:41 PM, Eric Kestler wrote: > >> Where does Sqlite actually reside when installed on a Mac? >> > > Probably *inside* navicat. > > When you build a native application, you can use static linking of > librar

[sqlite] Typo in the docs

Hi, Page https://www.sqlite.org/see/doc/trunk/www/readme.wiki [quote] Do decrypt a database do this: .rekey old-key "" [/quote] I think it should be "To decrypt..." Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

[sqlite] Configure check of SQLite

Hi, ALL, Is it possible to do a configure check/runtime check for the SQLite presence? Thank you.

[sqlite] database disk image is malformed

Simon, On Sat, Apr 30, 2016 at 10:12 PM, Simon Slavin wrote: > > On 1 May 2016, at 2:39am, Igor Korot wrote: > >> How do I recover the information? > > Do you have a copy of that file from before you updated ? Can you run > integrity_check() on it ? IIUC, this file di

[sqlite] database disk image is malformed

Hi, I just updated my system along with the compiler from 4.x to 5.2. And now I start receiving the aforementioned errors trying to start Anjuta. I tried to open the db file with sqlite3 - it opens, but running "PRAGMA integrity_check" it immediately gives: igor at IgorDellGentoo ~/.cache/anjuta

[sqlite] Illegal SQL not rejected

--Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Igor > Korot > Sent: Friday, April 29, 2016 1:42 PM > To: SQLite mailing list > Subject: Re: [sqlite] Illegal SQL not rejected > >

[sqlite] Illegal SQL not rejected

Hi, On Fri, Apr 29, 2016 at 1:28 PM, John McKown wrote: > On Fri, Apr 29, 2016 at 12:00 PM, Jann Roder > wrote: > >> Hi, >> It seems like a too obvious omission to not be intentional. But I wonder >> why a query like >> >> SELECT SUM(A) >> FROM TABLE >> GROUP BY B >> HAVING A <> 0 >> >> Is not r

[sqlite] No datasize field - why?

On Sat, Apr 23, 2016 at 3:22 PM, Richard Hipp wrote: > On 4/23/16, Igor Korot wrote: >> I merely tried to ask why in SQLite one can't have an information >> about the table field size - that is all. > > Answer: That information would consume memory. Thank you. That wa

[sqlite] No datasize field - why?

Hi, Keith, On Sat, Apr 23, 2016 at 5:56 AM, Keith Medcalf wrote: >> > What you are seeing there is SQLite just repeating back the type that >> the CREATE TABLE command used. It is not the type of data SQLite is >> actually storing. > >> > There is no 'varchar' datatype in SQLite. And it never t

[sqlite] No datasize field - why?

Hi, Simon, On Fri, Apr 22, 2016 at 9:23 AM, Simon Slavin wrote: > > On 22 Apr 2016, at 2:09pm, Igor Korot wrote: > >> The field type is set to be "varchar(100)" for the name field. >> Wouldn't it be more logical to have it as "varchar" and have an

[sqlite] No datasize field - why?

Hi, ALL, [code] SQLite version 3.9.2 2015-11-02 18:31:45 Enter ".help" for usage hints. sqlite> PRAGMA table_info(league); sqlite> PRAGMA table_info(leagues); 0|id|integer|0||1 1|name|varchar(100)|0||0 2|drafttype|integer(1)|0||0 3|scoringtype|integer(1)|0||0 4|roundvalues|integer(1)|0||0 5|league

[sqlite] autoincrement

Hi, On Wed, Apr 13, 2016 at 1:54 PM, Igor Korot wrote: > Hi, Peter, > > On Wed, Apr 13, 2016 at 1:16 PM, Peter Aronson wrote: >> There is one limitation to this approach, however. The entry for an >> autoincrement column in the sqlite_sequence table isn't made

[sqlite] autoincrement

interface, you > can identify autoincrement columns using sqlite3_table_column_metadata. I will test that when I come home from work. Thank you. > > Peter > > On Wednesday, April 13, 2016 9:40 AM, Igor Korot > wrote: > > > > Hi, Kees, > > On Wed, Apr 13,

[sqlite] autoincrement

Hi, Kees, On Wed, Apr 13, 2016 at 12:15 PM, Kees Nuyt wrote: > On Wed, 13 Apr 2016 10:58:54 -0400, Igor Korot > wrote: > >> Hi,, >> >>On Wed, Apr 13, 2016 at 10:54 AM, J Decker wrote: >>> Yes, you can get the create statement from sqlite_master table >

[sqlite] autoincrement

13, 2016 at 4:54 AM, Igor Korot wrote: >> Hi, >> Is it possible to get whether the column is set to autoincrement or not? >> >> PRAGMA table_info() does not give such info... >> >> Thank you. >> ___ >> s

[sqlite] autoincrement

Hi, Is it possible to get whether the column is set to autoincrement or not? PRAGMA table_info() does not give such info... Thank you.

[sqlite] sqlite3_column_decltype change

Hi, On Tue, Apr 5, 2016 at 1:57 PM, L?szl? B?sz?rm?nyi (GCS) wrote: > Hi, > > It seems sqlite3_column_decltype() is changed in 3.12.0 without > mentioning it in the changelog. A test case is attached. Using 3.11.1, > the result is not quoted, with 3.12.0 it is. > As such, the former outputs: typ

[sqlite] SQLite Pronunciation

On Wed, Mar 16, 2016 at 3:53 PM, Richard Hipp wrote: > On 3/16/16, Daniel Telvock wrote: >> I was at the Investigative Reporters and Editors Conference last week and >> the presenter for SQLite courses 1 and 3 said that it is actually >> pronounced SQ Lite. Even he thought that was odd considerin

[sqlite] Creating system table

Hi, Clemens, On Sat, Mar 12, 2016 at 1:41 PM, Clemens Ladisch wrote: > Igor Korot wrote: >> There is a notion of system table vs. user table in the DBMS. > > System tables are tables with a name beginning with "sqlite_". > >> My question is: what should I do

[sqlite] Creating system table

Hi, Simon, On Sat, Mar 12, 2016 at 1:18 PM, Simon Slavin wrote: > > On 12 Mar 2016, at 6:07pm, Igor Korot wrote: > >> There is a notion of system table vs. user table in the DBMS. >> >> The SQLite has at least 1 system table that is well-known: sqlite_master. > >

[sqlite] Creating system table

Hi, ALL, There is a notion of system table vs. user table in the DBMS. The SQLite has at least 1 system table that is well-known: sqlite_master. My question is: what should I do if I want to create a system table? Thank you.

[sqlite] Can SQLite be used from DLL

Hello, Teg, On Fri, Feb 26, 2016 at 11:41 AM, Teg wrote: > Hello Igor, > > I use Sqlite through a DLL interface. I mean I have another DLL that > includes Sqlite static linked inside it. All opening, closing and > access to Sqlite takes place inside the context of the DLL. The > application never

[sqlite] Can SQLite be used from DLL

Hi, I'm trying to design/make a program where I will use SQLite from the DLL. What I mean is I will establish a connection inside a DLL but disconnect from the database in my main application. It turns out that doing so I am getting the crash when I try to disconnect from the database file. Con

[sqlite] SQLite crashing

ouple of days ago. What are the conditions when the application will not be able to acquire the global file lock? Thank you. On Sun, Jan 31, 2016 at 1:11 PM, Olivier Mascia wrote: >> Le 31 janv. 2016 ? 18:06, Igor Korot a ?crit : >> >> Ok, I did try to recompile everything

[sqlite] How to enter Unicode character?

Hi, On Tue, Feb 9, 2016 at 3:09 AM, Dominique Devienne wrote: > On Mon, Feb 8, 2016 at 6:26 PM, Dominique Devienne > wrote: > >> OK, I retried with latest sqlite3.exe, and the results are different: >> >> C:\Users\DDevienne>sqlite3 >> SQLite version 3.10.2 2016-01-20 15:27:19 >> Enter ".help" f

[sqlite] How to enter Unicode character?

Dominique, On Mon, Feb 8, 2016 at 11:43 AM, Dominique Devienne wrote: > On Mon, Feb 8, 2016 at 5:33 PM, Dominique Devienne > wrote: > >> On Mon, Feb 8, 2016 at 4:46 PM, Igor Korot wrote: >> >>> On Mon, Feb 8, 2016 at 10:36 AM, Dominique Devienne >>>

[sqlite] How to enter Unicode character?

Dominique, Stehan, On Mon, Feb 8, 2016 at 10:36 AM, Dominique Devienne wrote: > On Mon, Feb 8, 2016 at 4:28 PM, Dominique Devienne > wrote: > >> On Mon, Feb 8, 2016 at 4:17 PM, Igor Korot wrote: >> >>> Now my question is: is it possible to enter a Unicode charact

[sqlite] How to enter Unicode character?

Hi, On Mon, Feb 8, 2016 at 10:21 AM, Stephan Beal wrote: > On Mon, Feb 8, 2016 at 4:17 PM, Igor Korot wrote: > >> Hi, ALL, >> I live in US and therefore have an English-based laptop with an >> English-based keyboard. >> >> I am also a programmer and would

[sqlite] How to enter Unicode character?

Hi, ALL, I live in US and therefore have an English-based laptop with an English-based keyboard. I am also a programmer and would like to test what happen if I have a SQLite table which contains a Unicode character. Now my question is: is it possible to enter a Unicode character (umlaut symbol,

[sqlite] SQLite crashing

Teg, On Sun, Jan 31, 2016 at 12:29 AM, Igor Korot wrote: > Teg, > > On Sat, Jan 30, 2016 at 1:54 PM, Teg wrote: >> Hello Igor, > > This is all compiling with /MTd. > >> >> I might set a break point in the destructor for the DB class and make >> sure

[sqlite] SQLite crashing

Clemens, On Fri, Jan 29, 2016 at 3:19 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> 1>odbccp32.lib(dllload.obj) : error LNK2019: unresolved external >> symbol __imp___vsnprintf referenced in function >> _StringVPrintfWorkerA at 20 > > Looks like a bug

[sqlite] SQLite crashing

Hi, ALL, On Tue, Jan 26, 2016 at 3:08 PM, Clemens Ladisch wrote: > Igor Korot wrote: >> sqlite.dll!sqlite3_mutex_enter(sqlite3_mutex * p) Line 19996 + 0xc >> bytesC >> sqlite.dll!sqlite3Close(sqlite3 * db, int forceZombie) Line 726 + 0xc >> by

[sqlite] SQLite crashing

Hi, Clemens, On Tue, Jan 26, 2016 at 7:14 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> sqlite.dll!sqlite3_mutex_enter(sqlite3_mutex * p) Line 19996 + 0xc >> bytesC >> sqlite.dll!sqlite3Close(sqlite3 * db, int forceZombie) Line 726 + 0xc >> by

[sqlite] SQLite crashing

Teg, On Mon, Jan 25, 2016 at 9:25 PM, Igor Korot wrote: > Hi, Teg, > > On Mon, Jan 25, 2016 at 5:21 PM, Igor Korot wrote: >> Hi, Teg, >> >> On Mon, Jan 25, 2016 at 4:51 PM, Teg wrote: >>> Hello Igor, >>> >>> Then I'd note the addr

[sqlite] SQLite crashing

Hi, Teg, On Mon, Jan 25, 2016 at 5:21 PM, Igor Korot wrote: > Hi, Teg, > > On Mon, Jan 25, 2016 at 4:51 PM, Teg wrote: >> Hello Igor, >> >> Then I'd note the address of the object (make a copy of the pointer >> right as it's allocated)

[sqlite] SQLite crashing

; __declspec(dllexport) Database *CreateObject(Database *db) >>> IK> { >>> IK> db = new SQLiteDatabase(); >>> IK> db->Connect(); >>> IK> return db; >>> IK> } >>> >>> IK> In the main application: >>> &g

[sqlite] SQLite crashing

ne saying "hey, that should have > got deleted already!... oh somehow delete x instead of safe_delete(x) > got used so while it got deleted earlier and x should have been null > at this point" > > Are you unit testing the trivial cases? > Create+Destroy > Create+Connect+Des

[sqlite] SQLite crashing

base *db = NULL; LoadLibrary(); func = GetProcAddress(); m_db = func( db ); } Also, in C++ delete'ing NULL is perfectly normal operation. Thank you. > > regards, > Adam DeVita > > On Mon, Jan 25, 2016 at 11:16 AM, Igor Korot wrote: >> Hi, Peter, >> >

[sqlite] SQLite crashing

e3.{obj,dll}. They rather link to the .lib file which has all exported functions. Thank you. > > Peter > > > On 1/25/2016 9:16 AM, Igor Korot wrote: >> >> Hi, Peter, >> >> On Mon, Jan 25, 2016 at 10:50 AM, Peter Aronson wrote: >>> >>> Igor,

[sqlite] SQLite crashing

id ConnectToDb(); > IK> private: > IK> Database *m_db; > IK> }; > > IK> mainframe.cpp: > > IK> void MainFrame::ConnectToDb() > IK> { > IK> Database *db = NULL; > IK> LoadLibrary(); > IK> func = GetProcAddress(); > IK>

[sqlite] SQLite crashing

pointer address are the same in DLL and main application MainFrame class. And as I said the crash occurs when it tries to acquire the mutex lock. Thank you. > > Peter > > > > > On 1/24/2016 10:18 PM, Igor Korot wrote: >> >> Hi, ALL, >> I have a strange proble

[sqlite] SQLite crashing

Hi, Clemens, On Mon, Jan 25, 2016 at 2:42 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> Upon exiting from the application > > When exactly? Is DllMain() involved in any way? The DLL where SQLite pointer is alocated there is a DLLMain. Then this pointer is brought b

[sqlite] SQLite crashing

If it matters, I'm trying Win 8.1 with MSVC 2010. Thank you. On Mon, Jan 25, 2016 at 12:18 AM, Igor Korot wrote: > Hi, ALL, > I have a strange problem. > > I am trying to use sqlite in my program. It has a main application and > couplef DLLs. > > I am getting the co

[sqlite] SQLite crashing

Hi, ALL, I have a strange problem. I am trying to use sqlite in my program. It has a main application and couplef DLLs. I am getting the connection in one of the DLL, then the pointer is passed up to the main application. Upon exiting from the application I'm trying to close the connection and d

[sqlite] Updating the contents of a field in table A with the value of the same field in table B

Hi, On Sat, Jan 16, 2016 at 12:58 AM, audio muze wrote: > Apologies if I'm asking an obvious question, but I've searched and > tried various options and have not been able to arrive at an UPDATE > statement in SQLite that does what I need. > > I've two tables with a unique identifier that enables

[sqlite] Parsing the contents of a field

Hi, On Wed, Jan 13, 2016 at 10:05 AM, Jim Morris wrote: > Might be doable with a recursive CTE > > On 1/13/2016 1:22 AM, Bart Smissaert wrote: >> >> It probably can be done with just SQLite's built-in text functions such as >> instr and substr, >> although with 20 to 30 items it may get a bit mes

[sqlite] Fwd: Happy New Year

-- Forwarded message -- From: Igor Korot Date: Thu, Dec 31, 2015 at 5:06 PM Subject: Happy New Year To: "python-list at python.org" , General Discussion of SQLite Database Happy New Year to everybody on those lists. Let this year brings us a lot of happiness and joy.

[sqlite] How is the name of the db file is identified?

Hi, ALL, Is it possible to save the SQLite DB file whose name contains some Unicode characters? Have such a character in the table name? Thank you.

[sqlite] sqlite3_errmsg and wide char

Hi, guys. But what about Linux/Mac? Can I use that function there? Thank you. On Nov 27, 2015 9:54 AM, "Dominique Devienne" wrote: > On Fri, Nov 27, 2015 at 2:45 PM, OBones wrote: > > > Dominique Devienne wrote: > > > >> That's UTF-16, while a wstring is expected to be in the current locale > >

[sqlite] sqlite3_errmsg and wide char

Hi, Scott, On Fri, Nov 27, 2015 at 1:01 AM, Scott Robison wrote: > On Thu, Nov 26, 2015 at 10:13 PM, Igor Korot wrote: >> >> Hi, >> Is there any way to have "sqlite3_errmsg" function return a wide char > string? >> Or do a conversion in a portable wa

[sqlite] sqlite3_errmsg and wide char

Hi, Is there any way to have "sqlite3_errmsg" function return a wide char string? Or do a conversion in a portable way? Thank you.

[sqlite] Retrieving the table info fails

Igor, On Mon, Nov 16, 2015 at 4:50 PM, Igor Tandetnik wrote: > On 11/16/2015 4:20 PM, Simon Slavin wrote: >> >> >> On 16 Nov 2015, at 9:09pm, Igor Korot wrote: >> >>> 1|name|varchar(100)|0 | |0 >> >> >&g

[sqlite] Retrieving the table info fails

Simon, On Mon, Nov 16, 2015 at 4:20 PM, Simon Slavin wrote: > > On 16 Nov 2015, at 9:09pm, Igor Korot wrote: > >> 1|name|varchar(100)|0 | |0 > > Note that this does not tell you anything about the affinity of the column, > or the t

[sqlite] Retrieving the table info fails

Simon, On Mon, Nov 16, 2015 at 3:13 PM, Simon Slavin wrote: > > On 16 Nov 2015, at 7:40pm, Igor Korot wrote: > >> But if I issue this PRAGMA command the field name, field type and the PK >> are guaranteed to have some values, right? > > No. Create a field without a

[sqlite] Retrieving the table info fails

Hi, On Mon, Nov 16, 2015 at 2:20 PM, R Smith wrote: > > > On 2015/11/16 7:59 PM, Igor Korot wrote: >> >> Stephan, >> >> On Mon, Nov 16, 2015 at 12:42 PM, Stephan Beal >> wrote: >>> >>> On Mon, Nov 16, 2015 at 6:11 PM, Igor Korot wro

[sqlite] Retrieving the table info fails

Stephan, On Mon, Nov 16, 2015 at 12:42 PM, Stephan Beal wrote: > On Mon, Nov 16, 2015 at 6:11 PM, Igor Korot wrote: > >> The variables referenced are defined as "std::string" and the code is in >> C++. >> > > the std::string(char const *) constructor do

[sqlite] Retrieving the table info fails

Igor, On Mon, Nov 16, 2015 at 12:42 PM, Igor Tandetnik wrote: > On 11/16/2015 12:11 PM, Igor Korot wrote: >> >> The crash occurs when the program tries to retrieve the value for >> "fieldDefaultValue". >> Looking at the output of "PRAGMA table_info();&

[sqlite] Retrieving the table info fails

Hi, ALL, I was successfully able to use Mr. Hipp' suggestion: char *z = sqlite3_mprintf("PRAGMA table_info(\"%w\");", zTableName); The prepare and step z. Then: sqlite3_free(z); However, for some reason, I'm getting crash. Here is the relevant code: fieldName = reinterpret_cast( sqliteColumnTex

[sqlite] Why am I getting an error?

Richard, On Sat, Nov 14, 2015 at 7:13 PM, Richard Hipp wrote: > On 11/14/15, Igor Korot wrote: >> Hi, Richard, >> >> On Sat, Nov 14, 2015 at 6:54 PM, Richard Hipp wrote: >>> On 11/14/15, Igor Korot wrote: >>>> Hi, ALL, >>>> I am tryin

[sqlite] Why am I getting an error?

Hi, Richard, On Sat, Nov 14, 2015 at 6:54 PM, Richard Hipp wrote: > On 11/14/15, Igor Korot wrote: >> Hi, ALL, >> I am trying to use following query: >> >> "PRAGMA table_info(?)" > > The argument to a pragma is not an expression, and hence it cannot

[sqlite] Why am I getting an error?

Hi, ALL, I am trying to use following query: "PRAGMA table_info(?)" with the sqlite3_prepare_v2()/sqlite3_bind()/sqlite3_step() sequence. However the call to sqlite3_prepare_v2() fails with the SQLITE_ERROR or the value of 1. The following call to sqlite3_ermsg() says "near "?": syntax error".

[sqlite] sql query

Hi, On Thu, Sep 10, 2015 at 1:17 PM, H?ctor Fiandor wrote: > Dear members: > > I am trying to use a SQL statement like this: > > fdm.tNegSerAct.SQL:='SELECT * FROM NegSerAct > > WHERE codNegSerAct >=desde AND codNegSerAct <=hasta > > ORDER BY codNegSerAct'; > > > > but the trouble is tha

[sqlite] Query

Hi, On Thu, Sep 3, 2015 at 5:33 AM, manash b wrote: > Hello, > > > I am using SQLite version 3.8.11.1 and PHP for my web application. > > Table *employee* has 4 columns. Last two columns have default NULL values. > > Insert query - > > > > *INSERT INTO employee SELECT 3 AS 'eid','manash' AS 'name

[sqlite] Could frequent 'database is locked' errors mean SQLite is not a good fit for my application?

Hi, Kathleen, On Thu, Jul 2, 2015 at 5:34 PM, James K. Lowden wrote: > On Thu, 2 Jul 2015 10:09:12 -0400 > Kathleen Alexander wrote: > >> Essentially, I have written an application in C++ that interfaces >> (reads and writes) with a SQLite database, and I am getting lots of >> 'database is lock

[sqlite] Fault on transaction begin, end, and rollback statements

Che, On Thu, Jun 25, 2015 at 5:38 PM, Kees Nuyt wrote: > On Thu, 25 Jun 2015 16:41:25 + (UTC), Ch? > wrote: > >>After using sqlite3_prepare_v2 to prepare "BEGIN TRANSACTION", "END >>TRANSACTION", and "ROLLBACK TRANSACTION", the system will fault at a delayed >>time when calling sqlite3_step.

[sqlite] Fault on transaction begin, end, and rollback statements

Hi, Che, On Thu, Jun 25, 2015 at 12:41 PM, Ch? wrote: > After using sqlite3_prepare_v2 to prepare "BEGIN TRANSACTION", "END > TRANSACTION", and "ROLLBACK TRANSACTION", the system will fault at a delayed > time when calling sqlite3_step. If I call prepare and step right away, there > is no fault.

[sqlite] implicit vs explicit joins

Clemens, On Thu, Jun 11, 2015 at 7:01 AM, Clemens Ladisch wrote: > Paul Sanderson wrote: >> I have just been asked whether implicit and explicit join are the same >> >> select text, handle.id from message,handle where handle_id = handle.ROWID; > > This is an implicit *inner* join. > >> SELECT me

[sqlite] index broken by insert

Hi, Roman, On Tue, May 19, 2015 at 1:23 PM, Roman Fleysher wrote: > "Confirmation" of a bug: > > When I use old SQLite version 3.7.2, the offending INSERT does NOT lead to > integrity failure. This is indicative of either bug in old integrity check or > new insert. Please let me know what usefu

[sqlite] Fwd: Is there an ODBC driver for SQLite

Hi, ALL, Is there an ODBC driver for SQLite DB? I'm trying to see if it will be possible to have an application written in dBase + Paradox to be converted to dBase + SQLite. So, if there is such a driver I would be very interested in requesting it and evaluate it. Also it would be nice to know

[sqlite] SQLite to SQL Server

Hi, On Tue, Apr 14, 2015 at 10:31 AM, Drago, William @ CSG - NARDA-MITEQ wrote: > Thanks for the tip. I've used dump before to move data around between SQLite > databases. I should have realized that I could have used it to move data to > SQL Server. And you can use bcp (freebcp from freeTDS p

[sqlite] Windows 8.x security requirements / SafeSEHCheck - NXCheck - DBCheck

HI, If I may... On Thu, Apr 2, 2015 at 4:25 PM, Richard Hipp wrote: > On 4/2/15, Random Coder wrote: >> >> I'd recommend the SQLite team turn them on for the version of the DLL >> they distribute, but I'm honestly not sure if there are negative side >> effects to doing so. > > That's not possibl

Re: [sqlite] VACUUM requires 6.7 times space ?

Hi, Simon, On Mon, Jan 5, 2015 at 6:32 AM, Dan Kennedy wrote: > On 01/05/2015 06:22 PM, Simon Slavin wrote: >> >> I have a database file which is 120GB in size. It consists of two huge >> tables and an index. >> Its journal_mode is DELETE. >> >> It is on a partition with 803GB of free space. By

Re: [sqlite] SQL newbie, how to implement a delete correctly.

Simon, On Tue, Dec 30, 2014 at 1:41 PM, Simon Slavin wrote: > On 30 Dec 2014, at 6:19pm, Jonathan Leslie wrote: > >> C:\jon>cat t2.lis | gawk "/.*/ { print \"delete from \" $3 \" where \" $4 }" >> |cut -d"," -f1delete from "parent01" where VALUES(1417556005delete from >> "child01" where VALUES

Re: [sqlite] Android sqlite error

Hi, On Fri, Jun 13, 2014 at 12:24 AM, Sathish N wrote: > hi Igor Korot, > > yes it is happening, every time i update the database. because of this the > application is getting crashed. > > Can you please help me with the solution. As this is the internal apk > inside the

Re: [sqlite] Android sqlite error

Hi, Satnish, On Fri, Jun 13, 2014 at 12:01 AM, Sathish N wrote: > hi, > > Thanks for the reply. > what do you mean that i cant write at dest. i am not sure what it means. It means you are trying to execute an INSERT/UPDATE statement which fails. It's quite obvious. Thank you. > > > > > On Thu,

Re: [sqlite] How to write a query

Hi, Simon, On Wed, Mar 5, 2014 at 2:21 AM, Simon Davies wrote: > On 5 March 2014 10:04, Igor Korot wrote: > > Hi, ALL, > > Let's say I have a table with following data: > > > > field1field2field3 field4 > > 12 3 4 &

[sqlite] How to write a query

Hi, ALL, Let's say I have a table with following data: field1field2field3 field4 12 3 4 5 6 7 8 How do I write a query which will produce the output as: 1 2 5 6 3 4 7 8 Is it possible to write a single query which will produce t

[sqlite] Happy New Year

Hi, ALL, I want to wish everybody who is reading and involved with the list Happy and oyful New Year! Let's have a great time in it and lets make a lot of good products and new releases with the software that everybody involve with. Thank you. ___ sqlite

[sqlite] Web application with SQLite

Hi ALL, Does people use SQLite for Web development? Or web apps are written only with mySQL/MS SQL? What are pros/cons of usinf SQLite for Web app? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/l

Re: [sqlite] 32-bit vs 64-bit build

Keith, On Fri, Dec 13, 2013 at 7:52 PM, Keith Medcalf wrote: > >>In order to retrieve the key of the tables I received a suggestion to >>use sqlite3_int64 type which should handle big numbers. > >>My question is: Will it work correctly on Windows XP which is 32-bit OS? > > Yes. The size of decla

[sqlite] 32-bit vs 64-bit build

Hi, ALL, I'm building a software that should work on Windows XP+ and Mac. As far as I know Windows XP is 32-bit only system. I'm building the software on Windows 7 (64-bit) using MSVC 2010 32-bit project. In order to retrieve the key of the tables I received a suggestion to use sqlite3_int64 type

Re: [sqlite] Is this a proper call?

Clemens, Thank you for clearing that up. On Sun, Dec 1, 2013 at 8:55 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> Is this a proper call to execute: >> >> if( sqlite3_exec( m_handle, "PRAGMA foreign_keys = OFF", NULL, NULL, 0 ) != >> SQLITE_OK ) &g

[sqlite] Is this a proper call?

Hi, ALL, Is this a proper call to execute: if( sqlite3_exec( m_handle, "PRAGMA foreign_keys = OFF", NULL, NULL, 0 ) != SQLITE_OK ) { // displaying error message } The problem is that after successful execution of such code, I am still getting error: "foreign key constraint failed" when executing

Re: [sqlite] What this function returns?

Simon, On Fri, Nov 29, 2013 at 7:33 PM, Simon Slavin wrote: > > On 30 Nov 2013, at 3:28am, Igor Korot wrote: > >> Also I am compiling 32-bit app on both platforms. > > Do you absolutely need to compile 32-bit for Macs ? There are almost no Macs > which can't h

Re: [sqlite] What this function returns?

Drake, On Fri, Nov 29, 2013 at 7:04 PM, Drake Wilson wrote: > Quoth Igor Korot , on 2013-11-29 18:49:05 -0800: >> Trying to change the return type to long does not solve the warning. >> >> Which value should this function return? > > As you can see f

[sqlite] What this function returns?

Hi, ALL, One stupid question: what sqlite3_last_insert_rowid() function returns? I have the following code: int MyClass::Foo() { return sqlite3_last_insert_rowid( m_handle ); } It compiles fine on Windows (7 64 bit) with MSVC 2010 SP1 Pro 32-bit project. But on Snow Leopard XCode 4.2 32-b

[sqlite] Nested transactions

If I understand correctly, I can do this (pseudo-code): BEGIN TRANSACTION; // some SQL statements BEGIN TRANSACTION; // some more SQL statements IF (more SQL statements == SUCCESS ) COMMIT; END / no need to ROLLBACK here, it will be done in the outer transaction IF( SQL statements == SUCCE

[sqlite] 2 more questions

d. What is best practice here? Should I use "ORDER BY" or leave my code as it is? 2. sqlite> EXPLAIN QUERY PLAN SELECT players.playerid FROM players WHERE players.na me = "Igor Korot" AND players.age = 25 AND players.teamid = (SELECT teamid FROM teams WHERE teams.name = "

<    1   2   3   4   5   >