[sqlite] CREATE FOREIGN KEY support

Hi, ALL, I believe the creation a foreign key on the existing tables is not supported on SQLite. However, I can issue a series of the SQL command which will emulate the creation of foreign key. 1. BEGIN 2. CREATE TEMPORARY TABLE temp AS SELECT * FROM ; 3. DROP TABLE ; 4. CREATE TABLE (, FOREIGN

Re: [sqlite] Is this behavior expected?

Hi, On Sun, Sep 24, 2017 at 7:46 AM, Baruch Burstein wrote: > SQLite version 3.20.1 2017-08-24 16:21:36 > sqlite> create table T(C); > sqlite> insert into T values("test 1"); > sqlite> select last_insert_rowid(); > 1 > sqlite> begin; > sqlite> insert into T values("test

Re: [sqlite] checking if a table exists

query: SELECT 1 FROM sqlite_master WHERE type = 'table' and name = ?;"; And then bind the actual variable to the query. If the execution return a row the table exists. Thank you. > > Mike > >> On Sep 22, 2017, at 15:24, Igor Korot <ikoro...@gmail.com> wrote: >&g

Re: [sqlite] checking if a table exists

Hi, On Fri, Sep 22, 2017 at 4:04 PM, David Raymond wrote: > Not familiar with perl, but... > > -You should never need to do writable_schema = on for any normal operation. > You can always read the schema even without that. > > -To my untrained eye it looks like you

Re: [sqlite] bug when saving database under dos

Hi, On Fri, Sep 22, 2017 at 11:36 AM, janezz55 . wrote: > Hello! Saving the database under dos-compiled sqlite does not work. How can > I go about debugging this (probably, just a small fix is necessary)? Maybe > you have experience with this bug? I made an image of the

Re: [sqlite] SQLite Site

Hi, Are you behind firewall? Thank you. On Sep 2, 2017 8:12 AM, "Stephen Chrzanowski" wrote: > I'm sitting on a new computer at work, and was trying to get the 3.20.1 > DLL, but, the browser is just spinning its wheels. > > I'm going to see what my Drobo has at home, and

Re: [sqlite] SQL statement and C++

Hi, What are you trying to achieve? Are you trying to perform a "VACUUM" command on the data base? Thank you. On Sep 1, 2017 2:23 PM, "Papa" wrote: In this snip, I'd like to show a brief description of what the class member function should do, in order to ask you if the SQL

Re: [sqlite] My 1st C++ SQLite3 program

Don, On Mon, Aug 28, 2017 at 6:33 AM, Don V Nielsen wrote: > database_name is never assigned a value? In SQLite3_RDB::SQLite3_RDB() it > is spelled databese_name? That is OK. The class member is not used anywhere and the "dxatabese_name" local is used instead. Thank you.

Re: [sqlite] My 1st C++ SQLite3 program

Hi, Chris, On Sun, Aug 27, 2017 at 6:53 PM, Chris Waters wrote: > Pardon my abject ignorance of C and C++. But just a quick naive observation. > Does it have anything to do with the fact that the string is declared > "database_name", but the invocation uses

Re: [sqlite] My 1st C++ SQLite3 program

On Sun, Aug 27, 2017 at 10:55 AM, Tim Streater wrote: > On 27 Aug 2017, at 15:35, Papa wrote: > >> First and foremost, I'd like to thank everybody for your replies. >> Although I have sound knowledge and understanding of C++ [ that can be >> debatable ]

Re: [sqlite] My 1st C++ SQLite3 program

Hi, On Sun, Aug 27, 2017 at 10:35 AM, Papa wrote: > First and foremost, I'd like to thank everybody for your replies. > Although I have sound knowledge and understanding of C++ [ that can be > debatable ] and still remember a little how C works, I have no Idea how to > utilize

Re: [sqlite] My 1st C++ SQLite3 program

Hi, On Sat, Aug 26, 2017 at 9:34 PM, Papa wrote: > class SQLite3_RDB { > private: > sqlite3* db; //!< Data Base > std::string database_name; >public: > SQLite3_RDB(); > ~SQLite3_RDB(){sqlite3_close(db); } > }; >

Re: [sqlite] sqlite3_column_text() return value

Richard, On Sat, Aug 26, 2017 at 2:19 PM, Richard Hipp <d...@sqlite.org> wrote: > On 8/26/17, Igor Korot <ikoro...@gmail.com> wrote: >> Hi, >> Is there a reason why the aforementioned function returns "const unsigned >> char *" instead of just "con

[sqlite] sqlite3_column_text() return value

Hi, Is there a reason why the aforementioned function returns "const unsigned char *" instead of just "const char *"? Will I miss anything if I cast out "unsigned"? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SQLITE PHP syntax issues - INSERT INTO db

Hi, On Tue, Aug 8, 2017 at 12:58 PM, Jens Alfke wrote: > >> On Aug 5, 2017, at 6:48 AM, Edmondo Borasio wrote: >> >> *$query1="INSERT INTO Table"."(ID,name,surname)"."VALUES(\' ' . $NewID . >> '\','newName','newSurname');"; * > > It’s a very, very

Re: [sqlite] Does it make sense to COMMIT/ROLLBACK?

On Wed, Jul 26, 2017 at 12:16 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Igor Korot wrote: >> If I execute "BEGIN TRANSACTION" and for whatever reason the call will fail >> will I get an error on COMMIT/ROLLBACK execution? > > sqlite> begin immediate

[sqlite] Does it make sense to COMMIT/ROLLBACK?

Hi, ALL, If I execute "BEGIN TRANSACTION" and for whatever reason the call will fail will I get an error on COMMIT/ROLLBACK execution? This is an un-named transaction and it is an outmost one. Thank you. ___ sqlite-users mailing list

Re: [sqlite] Database version

Hi, Keith, On Fri, Jul 21, 2017 at 4:17 PM, Keith Medcalf wrote: >>The only trouble is - how do I know what version were used. >>My application may use some features that is available right now and >>I want to use them because they are great. >>But if I open the DB from the

Re: [sqlite] Database version

Richard, et al, On Fri, Jul 21, 2017 at 2:08 PM, Richard Hipp wrote: > On 7/21/17, Simon Slavin wrote: >> >> The new features introduced by SQLite since it started using file format 3 >> all require explicit commands to use. Adding columns to existing

Re: [sqlite] Database version

t db file. Thank you. > > On 7/21/17, 10:46 AM, "sqlite-users on behalf of Igor Korot" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of > ikoro...@gmail.com> wrote: > > Hi, Peter et al, > > On Fri, Jul 21, 2017 at 11:35 A

Re: [sqlite] Database version

Hi, Peter et al, On Fri, Jul 21, 2017 at 11:35 AM, Peter Da Silva wrote: > The problem is that SQLITE_VERSION_NUMBER is not “the database version”, it’s > something like “the last version of SQLite that committed a transaction”. > > The database version number is

Re: [sqlite] Database version

Hi, Bob, On Fri, Jul 21, 2017 at 11:27 AM, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > On Fri, 21 Jul 2017, Igor Korot wrote: >> >> >> In my "Help -> About..." I'd like to say something like: >> >> "Using SQLite

Re: [sqlite] Database version

Hi, Andy, On Fri, Jul 21, 2017 at 11:19 AM, Andy Ling wrote: >>Let's say I made some database files 2 years ago. >>Now I want the current SQLite code to open them and performs some queries >>from the C interface. > > I would ask why do you care? Sqlite will read old

Re: [sqlite] Database version

9:58 AM, "sqlite-users on behalf of Igor Korot" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of > ikoro...@gmail.com> wrote: > > Hi, ALL, > Is there a way to know the version of the .db file I am using? > > I'd lik

[sqlite] Database version

Hi, ALL, Is there a way to know the version of the .db file I am using? I'd like to issue some kind of SELECT statement to get it. Looks like there is an interface to get the library version, but I don't see anything for a db file. Thank you. ___

Re: [sqlite] SQLite Port/ODBC Driver Question

Rob, On Mon, Jul 10, 2017 at 7:06 AM, Rob Willett wrote: > Vishal, > > SQLite isn't a traditional client/server relational database, therefore > there isn't a port to open up. It runs on a local machine. I believe SQLite can successfully be run remotely. Thank

Re: [sqlite] FOREING KEY constraint

Hi, Keith et al, On Mon, Jul 3, 2017 at 7:13 AM, Keith Medcalf wrote: > > From what I can tell the answer is (A). The constraint_name is simply a > comment to be reported (if possible) when the constraint is violated. So is it possible to check that the foreign key with

[sqlite] FOREING KEY constraint

Hi, ALL, Is SQLite supports naming a foreign key constraint? And if it does - is there a way to check for its uniqueness? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Create database

;> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı >> >> >> > -Original Message- >> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> > On Behalf Of Igor Korot >> > Sent: Friday, 14 April, 2017 08:26 >> >

Re: [sqlite] Create database

sqlite3_open( name2, _db ); [/pseudo-code] Thank you. > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > >> -Original Message- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> On Behalf Of Igor Korot >>

[sqlite] Create database

Hi, If I have a database open with sqlite3_open() and then want to issue another sqlite3_open(), the old database will be closed and the new one will open? Or I have to explicitly call sqlite3_close()? Thank you. ___ sqlite-users mailing list

Re: [sqlite] Error handling

Hi, Richard, On Wed, Feb 15, 2017 at 8:20 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/15/17, Igor Korot <ikoro...@gmail.com> wrote: >> >> Well, my question here is a bit different - if sqlite3_step () returns an >> error >> should the statement be re

Re: [sqlite] Error handling

Hi, Igor, On Feb 15, 2017 7:16 PM, "Igor Tandetnik" <i...@tandetnik.org> wrote: On 2/15/2017 7:02 PM, Igor Korot wrote: > My question is: how many calls to "sqlite3_finalize() should be there? > For every successful call to sqlite3_prepare[_v2], there

[sqlite] Error handling

Hi, ALL, Consider the following pseudo-code: [code] int ret = sqlite3_prepare_v2(); if( ret != SQLITE_OK ) { // henerate error message return 1; } while( ; ; ) { ret = sqlite3_step(); if( ret == SQLITE_ROW ) { // everything is good } else if( ret == SQLITE_DONE )

[sqlite] FOREIGN KEY question

Hi, ALL, Does SQLite supports the FK name? If yes, what is the proper syntax? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Executing multiple statements at once

Hi, ALL, Is it possible to write something like this: sqlite3_prepare_v2( m_db, "BEGIN TRANSACTION; CREATE TEMP TABLE temp AS SELECT * FROM mytable; DROP TABLE mytable; CREATE TABLE mytable(id INTEGER PRIMARY KEY, name TEXT PRIMARY KEY, salary INTEGER); INSERT INTO mytable SELECT * FROM temp;

[sqlite] Happy New Year!

Hi Happy New year to people on this lists. Many more releases and without bugs. :-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do I see a full query?

Keith, On Tue, Dec 27, 2016 at 10:59 PM, Keith Medcalf wrote: > >> > So whether hard coding the empty string in the query or using a >> parameter (in which you can use some value other than an empty string) >> depends on what you will need in the context of the application.

Re: [sqlite] How do I see a full query?

Hi, Simon, On Tue, Dec 27, 2016 at 12:14 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 Dec 2016, at 4:24am, Igor Korot <ikoro...@gmail.com> wrote: > >> I have a weird situation where executing a query in a shell gives me a row, >> but executing the s

Re: [sqlite] How do I see a full query?

mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von Igor Korot > Gesendet: Dienstag, 27. Dezember 2016 05:24 > An: Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org>; > General Discussion of SQLite Database <sqlite-us...@sqlite.org> >

Re: [sqlite] How do I see a full query?

ot; char(18), "abh_fhgt" smallint, "abh_fwgt" smallint, "abh_fitl" char(1), "abh _funl" char(1), "abh_fchr" smallint, "abh_fptc" smallint, "abh_ffce" char(18), " abl_fhgt" smallint, "abl_fwgt" smallint, "a

Re: [sqlite] How do I see a full query?

quot;abt_ownr\" = \'\';"; because abt_ownr field will always be empty (unless there is a way to know what user connected to the DB). Also I'm just curious - am I to run something like: res = sqlite3_bind_text( stmt, 2, "", -1, SQLITE_STATIC ); Thank you. > -

[sqlite] How do I see a full query?

Hi, ALL, I have a weird situation where executing a query in a shell gives me a row, but executing the same query through the C-interface: sqlite3_prepare_v2(), sqlite3_bind_text() and sqlite3_step() produces SQLITE_DONE. So I wonder - is it possible to see a full query string inside

Re: [sqlite] How do I check if the DB is open?

Jens, On Tue, Dec 13, 2016 at 8:38 PM, Jens Alfke wrote: > >> On Dec 13, 2016, at 5:33 PM, Simon Slavin wrote: >> >> The only thing you should do if sqlite3_close() doesn’t work is to print an >> error message which includes the value returned.

Re: [sqlite] How do I check if the DB is open?

Nathan, On Tue, Dec 13, 2016 at 8:36 PM, Nathan Bossett <nboss...@pierb.com> wrote: > On Tue, Dec 13, 2016 at 08:20:44PM -0500, Igor Korot wrote: >> > What more are you trying to find out? >> >> If I forget to finalize statement, I can use that sequence to f

Re: [sqlite] How do I check if the DB is open?

>> -Original Message- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> On Behalf Of Igor Korot >> Sent: Tuesday, 13 December, 2016 17:55 >> To: Discussion of SQLite Database; General Discussion of SQLite Database >> Subjec

Re: [sqlite] How do I check if the DB is open?

Simon, On Tue, Dec 13, 2016 at 8:33 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Dec 2016, at 1:20am, Igor Korot <ikoro...@gmail.com> wrote: > >> So are you saying that this code should be executed if sqlite3_close() >> didn't return SQLITE_OK? &

Re: [sqlite] How do I check if the DB is open?

e you saying that this code should be executed if sqlite3_close() didn't return SQLITE_OK? Thank you. > > -Nathan > > On Tue, Dec 13, 2016 at 07:54:34PM -0500, Igor Korot wrote: >> Hi, ALL, >> I'm using following code to check for errors in debug mode: >> >>

[sqlite] How do I check if the DB is open?

Hi, ALL, I'm using following code to check for errors in debug mode: int res = sqlite3_close( m_db ); if( res != SQLITE_OK ) { // error handling } #ifdef DEBUG sqlite3_stmt *statement = sqlite3_next_stmt( m_db, NULL ); if( statement ) const char *query =

Re: [sqlite] Weird issue with the query

Simon, On Fri, Dec 2, 2016 at 9:47 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Dec 2016, at 2:44am, Igor Korot <ikoro...@gmail.com> wrote: > >> Ok so in order to fix it I should assign the result of conversion to some >> variable? > > It m

Re: [sqlite] Weird issue with the query

Igor Ok so in order to fix it I should assign the result of conversion to some variable? Thank you. On Dec 2, 2016 9:07 PM, "Igor Tandetnik" <i...@tandetnik.org> wrote: On 12/2/2016 8:39 PM, Igor Tandetnik wrote: > On 12/2/2016 6:56 PM, Igor Korot wrote: > >>

Re: [sqlite] Weird issue with the query

Igor Ok so in order to fix it I should assign the result of conversion to some variable? Thank you. On Dec 2, 2016 9:07 PM, "Igor Tandetnik" <i...@tandetnik.org> wrote: > On 12/2/2016 8:39 PM, Igor Tandetnik wrote: > >> On 12/2/2016 6:56 PM, Igor Kor

Re: [sqlite] Weird issue with the query

On Fri, Dec 2, 2016 at 6:56 PM, Igor Korot <ikoro...@gmail.com> wrote: > Hi, ALL, > I wrote following code in C++ (error checking removed for clarity): > > [code] > const std::wstring ::GetTableComments(const > std::wstring , std::vector ) > { > std::wstring com

[sqlite] Weird issue with the query

Hi, ALL, I wrote following code in C++ (error checking removed for clarity): [code] const std::wstring ::GetTableComments(const std::wstring , std::vector ) { std::wstring comment = L""; sqlite3_stmt *stmt = NULL; std::wstring errorMessage; std::wstring query = L"SELECT

[sqlite] Export database into mySQL

Hi, Is it possible to load the SQLite schema from the .dump command into mySQL? Or I will have to do that on per-table? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] CREATE TABLE fails

Hi, guys, Parents with the comma before "PRIMARY" fixed it. Thx. On Tue, Nov 22, 2016 at 9:39 AM, Niall O'Reilly wrote: > On 22 Nov 2016, at 14:35, David Raymond wrote: > >> It's needed. The arrow coming out of [column-def] (visually) goes past >> [table-constraint]

Re: [sqlite] creating a table

John, On Tue, Nov 22, 2016 at 11:00 AM, John R. Sowden wrote: > That was a throw back to years ago. I was trying to protect against y2k by > making each dbf for 1 calendar year. Also, these files are about 800k in > size, so I was worried about storage and search

[sqlite] CREATE TABLE fails

Hi, ALL, SQLite version 3.13.0 2016-05-18 10:57:30 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE IF NOT EXISTS abc("abc_tnam" char(129) NOT NULL, "abc_tid" integer, "abc_ownr" char(129) NOT

Re: [sqlite] creating a table

Hi, Niall, On Mon, Nov 21, 2016 at 12:52 PM, Niall O'Reilly wrote: > On 21 Nov 2016, at 17:29, John R. Sowden wrote: > >> First of all, I come from the dBASE/Foxpro world. There is no distinction >> between a table and a database. I understand that with Sqlite a database

Re: [sqlite] creating a table

Hi, John, On Mon, Nov 21, 2016 at 12:29 PM, John R. Sowden wrote: > First of all, I come from the dBASE/Foxpro world. There is no distinction > between a table and a database. I understand that with Sqlite a database > includes tables and other items. The scenario

[sqlite] Fwd: Bug in the docs

Hi, ALL, On the page https://www.sqlite.org/c3ref/exec.html following phrase is written: [quote] If the 5th parameter to sqlite3_exec() is not NULL then any error message is written into memory obtained from sqlite3_malloc() and passed back through the 5th parameter. [/quote] Shouldn't it start

[sqlite] Bug in the docs

Hi, ALL, On the page https://www.sqlite.org/c3ref/exec.html following phrase is written: [quote] If the 5th parameter to sqlite3_exec() is not NULL then any error message is written into memory obtained from sqlite3_malloc() and passed back through the 5th parameter. [/quote] Shouldn't it start

Re: [sqlite] Backward cursor support?

qlite.org/draft/rowvalue.html > http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference > > >> -Original Message- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> On Behalf Of Igor Koro

[sqlite] Backward cursor support?

Hi, Does SQLite support backward cursor? Something like step_back()? If not, what would be a way to do it? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Query time execution difference between my application and SQLiteBrowser

Laura, On Thu, Sep 8, 2016 at 5:22 AM, Laura BERGOENS wrote: > Hi everyone, > > So I've put indexes myself on the most used tables in my program, then > ANALYZE the db, and now it flies. > The automatic creation of index probably took a lot of time, and it affects >

Re: [sqlite] Query time execution difference between my application and SQLiteBrowser

Hi, Laura, On Wed, Sep 7, 2016 at 12:25 PM, Laura BERGOENS wrote: > Hi Dominique, > > I guess it's not, but I'm not quite sure on what I can share, I'm a newbie > in a professional environment. I would be more confortable if I ask my boss > first. In the meantime, all

Re: [sqlite] Query time execution difference between my application and SQLiteBrowser

Hi, Laura, On Wed, Sep 7, 2016 at 10:48 AM, Laura BERGOENS wrote: > Note : I had some real queries that use to take 100 seconds to execute, and > I optimized them myself. > It looks like this : > > I have 4 tables: tableA, tableLink, tableC and tableD > tableA, Link

Re: [sqlite] REQUETES

Hi, On Wed, Aug 31, 2016 at 9:14 AM, REGIANY Lucie wrote: > > HELLO > I WOULD DO SELECT FROM MY TABLE > select * > FROM "_L93_ZONAGES_exportdirectory_list" > WHERE "_L93_ZONAGES_exportdirectory_list".'TYPE' LIKE 'TAB%' > OR > "_L93_ZONAGES_exportdirectory_list".'TYPE'

Re: [sqlite] bug in sqlite when

Hi, Sergey, On Wed, Aug 24, 2016 at 8:55 AM, Sergey Shamshyn wrote: > Hi. > I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I think > this is a 100% SQLite bug, because: > - only ONE THREAD of my process is writing periodically to db file > - onlt

Re: [sqlite] AS being optional

Dominick, On Fri, Aug 12, 2016 at 9:24 AM, Dominique Devienne wrote: > On Fri, Aug 12, 2016 at 2:42 PM, Keith Medcalf wrote: > >> [...] The main problem with the JOIN/ON syntax is that to a casual reading >> order is implied > > > No idea what you mean

Re: [sqlite] How restrict access to SQLite database?

Hi, On Tue, Aug 9, 2016 at 9:25 AM, Jaime Stuardo wrote: > Hello, > > > > I am developing an application that should use a database. System is very > simple that I will try with a file based database system, however, I have > found a subject that is very critical for

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

Hi, Kevin, On Fri, Aug 5, 2016 at 3:18 PM, Kevin O'Gorman wrote: > Okay, I followed some of the advice y'all gave and got some results. > > 1. The original problem was compromised by malformed input. However, it > appears that did not cause the wedging of the process.

Re: [sqlite] The upcoming "pi" release of SQLite

Mr. Hipp, On Sat, Jul 23, 2016 at 11:16 AM, Richard Hipp wrote: > The next release of SQLite will be the "pi" release - version 3.14. > It will probably occur within the next two weeks. > > Draft change log: https://www.sqlite.org/draft/releaselog/3_14_0.html > > Code snapshot:

Re: [sqlite] Compiling on Xcode

Simon et al, On Sat, Jul 23, 2016 at 2:20 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jul 2016, at 4:26am, Igor Korot <ikoro...@gmail.com> wrote: > >> "Ambiguous expansion of macro MIN/MAX" > > Sorry, I don't recognise this problem. I would

Re: [sqlite] Compiling on Xcode

Simon, Sorry for the long delay. I was trying to catch up on some other stuff. On Thu, Jul 14, 2016 at 10:01 AM, Igor Korot <ikoro...@gmail.com> wrote: > On Thu, Jul 14, 2016 at 9:38 AM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 14 Jul 2016, at 12:44pm, Igo

Re: [sqlite] Compiling on Xcode

On Thu, Jul 14, 2016 at 9:38 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Jul 2016, at 12:44pm, Igor Korot <ikoro...@gmail.com> wrote: > >> Is there anything else to check? > > No. Those look correct. You looked at the right place and it

Re: [sqlite] How to do PRAGMA in C-interface?

Hi, On Thu, Jul 14, 2016 at 8:05 AM, Richard Hipp wrote: > On 7/14/16, wu tao wrote: >> I tried to do the sqlite db PRAGMA via c-interface, sqlite3_exec() with the >> following statements, >> >> PRAGMA main.cache_size=5000;PRAGMA main.page_size = 2048;PRAGMA

Re: [sqlite] Compiling on Xcode

Simon, On Wed, Jul 13, 2016 at 11:51 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Jul 2016, at 4:43am, Igor Korot <ikoro...@gmail.com> wrote: > >> Right now my C Language option on the Xcode 5.1.1 is set to "GNU99". >> When using this opti

[sqlite] Compiling on Xcode

Hi, ALL, Right now my C Language option on the Xcode 5.1.1 is set to "GNU99". When using this option I am getting a lot of different warnings like: Value Conversion Issue Implicit conversion loses integer precision. I know its just a warning, but I prefer the code to be compiled clean. I would

Re: [sqlite] Menory leak/false positive

Igor, On Wed, Jul 13, 2016 at 8:23 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 7/13/2016 8:12 PM, Igor Korot wrote: >> >> char *z = sqlite3_mprintf( query2.c_str(), tableName >> ); > > > There is a bunch of calls to sqlite3_mprint

[sqlite] Menory leak/false positive

Hi, ALL, I am trying to create my software with MSVC 2010 and latest SQLite. Because MSVC reported memory leaks, I tried VLD. Here is their output: [quote] Detected memory leaks! Dumping objects -> {158248} normal block at 0x011EA4B8, 48 bytes long. Data: 50 52 41 47 4D 41 20 66 6F 72 65 69 67

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

Simon, As Mr Hipp pointed out - what problems you observed with SQLite? It is possible that if you report it it will be fixed and you won't need to do that restoration anymore. Thank you. On Wed, Jul 13, 2016 at 5:52 PM, S.Ajina wrote: >> What console font are you using,

Re: [sqlite] Database is locked

Dan, On Sun, Jul 10, 2016 at 11:57 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 07/10/2016 06:21 AM, Igor Korot wrote: >> >> Simon, >> >> On Sat, Jul 9, 2016 at 7:09 PM, Simon Slavin <slav...@bigfraud.org> wrote: >>> >>> On 10 Ju

Re: [sqlite] Database is locked

Simon, On Sat, Jul 9, 2016 at 7:09 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 Jul 2016, at 12:06am, Igor Korot <ikoro...@gmail.com> wrote: > >> I'm trying to write some software in C{++}. Everything works fine except >> when I exit the progr

[sqlite] Database is locked

Hi, Here is my situation. I'm trying to write some software in C{++}. Everything works fine except when I exit the program exit I get the error "Database is locked". I am only trying to retrieve the information about the database (queries on sqlite_master). So here are my questions: 1. When the

Re: [sqlite] SQLite policy on compile warnings

Simon, On Sun, Jun 26, 2016 at 12:16 AM, Igor Korot <ikoro...@gmail.com> wrote: > Simon, > > On Sat, Jun 25, 2016 at 11:31 PM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 26 Jun 2016, at 3:30am, Igor Korot <ikoro...@gmail.com> wrote: >>

Re: [sqlite] SQLite policy on compile warnings

Mr. Hipp, On Sat, Jun 25, 2016 at 11:31 PM, Richard Hipp <d...@sqlite.org> wrote: > On Sun, Jun 26, 2016 at 4:30 AM, Igor Korot <ikoro...@gmail.com> wrote: >> >> I am wondering what is the current policy on the compilation >> warning for the SQLite? >> >

Re: [sqlite] SQLite policy on compile warnings

Simon, On Sat, Jun 25, 2016 at 11:31 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Jun 2016, at 3:30am, Igor Korot <ikoro...@gmail.com> wrote: > >> ATM I'm using OSX 10.8 with Xcode 5.1.1. compiling everything for C++11 >> and libc++. > > You

Re: [sqlite] Conversion failure

On Sat, Jun 25, 2016 at 11:26 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Jun 2016, at 2:52am, Igor Korot <ikoro...@gmail.com> wrote: > >> Now we need to see the actual German version test result with old and >> new version of the shell tool.

[sqlite] SQLite policy on compile warnings

Hi, ALL, I am wondering what is the current policy on the compilation warning for the SQLite? The reason being - I'm trying to incorporate SQLite into my software. The software will be cross-platform. On both Windows and Linux, I don't see any issues. However, trying to compile on Mac I have a

Re: [sqlite] Conversion failure

Simon, On Sat, Jun 25, 2016 at 9:11 PM, Igor Korot <ikoro...@gmail.com> wrote: > Simon, > > On Sat, Jun 25, 2016 at 8:32 PM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 26 Jun 2016, at 1:29am, Igor Korot <ikoro...@gmail.com> wrote: >>

Re: [sqlite] Conversion failure

Simon, On Sat, Jun 25, 2016 at 8:32 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Jun 2016, at 1:29am, Igor Korot <ikoro...@gmail.com> wrote: > >> Now it would be interesting to know what is the result on German >> version of Windows with German >

Re: [sqlite] Conversion failure

Simon, On Sat, Jun 25, 2016 at 8:18 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Jun 2016, at 1:14am, Igor Korot <ikoro...@gmail.com> wrote: > >> That would be 313, correct? > > Yes. The idea is to see if the bug still occurs in the current v

Re: [sqlite] Conversion failure

Simon, On Sat, Jun 25, 2016 at 8:08 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 25 Jun 2016, at 5:51am, Igor Korot <ikoro...@gmail.com> wrote: > >> This are the results of me trying: >> >> SQLite version 3.9.2 2015-11-02 18:31:45 >>

Re: [sqlite] Conversion failure

Keith, On Sat, Jun 25, 2016 at 10:14 AM, Keith Medcalf wrote: >> > And look in the registry under >> HKLM\CurrentControlSet\Control\NLS\CodePage > >> On my Windows 8.1 machine I don't have HK_LOCAL_MACHINE\CurrentControlSet. > > Ooops. My typo ... > > It is

Re: [sqlite] Conversion failure

ts.sqlite.org] On Behalf Of Simon Slavin >> Sent: Saturday, 25 June, 2016 02:40 >> To: SQLite mailing list >> Subject: Re: [sqlite] Conversion failure >> >> >> On 25 Jun 2016, at 5:51am, Igor Korot <ikoro...@gmail.com> wrote: >> >> > So no

Re: [sqlite] Conversion failure

Simon, On Sat, Jun 25, 2016 at 4:39 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 25 Jun 2016, at 5:51am, Igor Korot <ikoro...@gmail.com> wrote: > >> So now the question is - what encoding is that value, so that it can >> be successfully converted to wstri

Re: [sqlite] Conversion failure

Scott, On Fri, Jun 24, 2016 at 2:16 PM, Scott Robison wrote: > On Fri, Jun 24, 2016 at 12:03 PM, Scott Robison > wrote: > >> On Windows, when you get a string of characters, you either get an ANSI >> string using some code page, or you get a

Re: [sqlite] Conversion failure

Hi, On Fri, Jun 24, 2016 at 12:51 PM, R Smith wrote: > > > On 2016/06/24 6:11 PM, Simon Slavin wrote: >> >> The ALT+num system for entering unusual characters is a Windows thing. On >> a Mac you do it by picking the character from a virtual keyboard shown on >> the display,

Re: [sqlite] Conversion failure

Simon, On Fri, Jun 24, 2016 at 11:44 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Jun 2016, at 4:37pm, Igor Korot <ikoro...@gmail.com> wrote: > >> Now are all those scenarios correct? >> Will me and my German friend be able to open each other d

<    1   2   3   4   5   >