Re: [sqlite] Why do I only get one record?

Hi, On Wed, Feb 19, 2020 at 2:12 PM Jose Isaias Cabrera wrote: > > > Thanks, Keith. Darn it! GROUP BY and ORDER BY! Got it, it's working now. > Thanks. > > > > From: sqlite-users on behalf > of Keith Medcalf > Sent: Wednesday, February 19, 2020 03:09 PM >

Re: [sqlite] how to disable dot commands?

Hi, On Sun, Jan 12, 2020 at 7:44 PM Xingwei Lin wrote: > > Hi, > > Is there any way can we disable the dot commands feature in sqlite? Are you talking about the SQLite shell? Why do you want to disable them? What is your specific scenario? Thank you. > > -- > Best regards， > Xingwei Lin >

Re: [sqlite] Bug? SQLite command-line result is different from Perl DBI::Sqlite result

Hi, On Tue, Jan 7, 2020 at 2:01 AM Clemens Ladisch wrote: > > Richard Hipp wrote: > > On 1/5/20, Keith Medcalf wrote: > >> select * from a, b, c using (id); -- very strange result > > > > PostgreSQL and MySQL process the query as follows: > > > >SELECT * FROM a, (b JOIN c USING(id)); > > > >

Re: [sqlite] SQLite command-line result is different from Perl DBI::Sqlite result

Hi, On Sat, Jan 4, 2020 at 7:31 PM Amer Neely wrote: > > Hello all, > I'm fairly new to SQLite, but have been using MySQL / mariadb in a local > and web-based environment for several years. So far I'm happy and > impressed with SQLite, but I recently noticed some odd behaviour with > one of my qu

Re: [sqlite] Bug Report

Hi, On Fri, Dec 27, 2019 at 12:57 PM Bigthing Do wrote: > > Dear sqlite developers: > > We met an accidental crash in sqlite with the following sample: > > CREATE VIEW table1 ( col1 , col2 ) AS WITH aaa AS ( SELECT * FROM table1 ) > SELECT col2 FROM table1 ORDER BY 1 ; > WITH aaa AS ( SELECT * F

Re: [sqlite] Possible bug in storing text values in numeric columns

Hi, On Sun, Oct 13, 2019 at 4:12 PM Shawn Wagner wrote: > > The documentation for a column with NUMERIC affinity says > > > When text data is inserted into a NUMERIC column, the storage class of > the text is converted to INTEGER or REAL (in order of preference) if such > conversion is lossless a

Re: [sqlite] SQLite - macOS

Hi, On Mon, Sep 23, 2019 at 11:58 AM Pierre Clouthier wrote: > > Can anyone explain how to write UTF-8 in SQLite on the Mac? > > We use this statement: > > sqlite3_exec("PRAGMA encoding = \"UTF-8\";") You should probably use this inside #ifdef _WINDOWS #endif Thank you. > > This work

Re: [sqlite] what's wrong with this trigger

Hi, On Mon, Sep 9, 2019 at 9:43 PM Doug wrote: > > What works, please? I saw no answer. There is an answer down below. Thank you. > Doug > > > -Original Message- > > From: sqlite-users > > On Behalf Of Rael Bauer > > Sent: Monday, September 09, 2019 7:01 PM > > To: sqlite-users@mailin

Re: [sqlite] How to insert the BLOB in database?

Hi, Richard, Thank you for the reply. On Sun, Jun 9, 2019 at 7:24 PM Richard Hipp wrote: > > On 6/9/19, Igor Korot wrote: > > > > Now I open this database in sqlite3 CLI binary and would like to insert some > > png > > file inside this BLOB field. > > >

[sqlite] How to insert the BLOB in database?

Hi, ALL, Let's say I have some database, where I have table called test. This test table contains the field whose type is BLOB. Now I open this database in sqlite3 CLI binary and would like to insert some png file inside this BLOB field. And I am not talking about the file name - the actual conten

Re: [sqlite] Returning NULL or empty values when the SELECT does not satisfy all of the query

Hi, On Fri, Apr 5, 2019 at 1:36 PM Jose Isaias Cabrera wrote: > > > Thanks, Simon. Works like a charm... Unless backwards compatibility is important (do you expect to go back to pre-foreign keys implementation), I'd do FOREIGN KEY amd forget anout that... Thank you. > > > From: Simon Davies

Re: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie

Hi On Tue, Mar 12, 2019 at 5:03 PM Ted Goldblatt wrote: > > On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote: > > > I may have missed this already being discussed. > > > > Will you have access to a copy of the database as it was before corruption > > testing ? Can you use SQLite to see wheth

Re: [sqlite] Why am I not getting anything?

Thank you. On Sun, Feb 10, 2019 at 1:35 AM Shawn Wagner wrote: > > SELECT * FROM pragma_foreign_key_list('temp1'); > > The table name needs to be a string for the pragma_foreign_key_list virtual > table. (It's not for the corresponding pragma statement.) > >

[sqlite] Why am I not getting anything?

Hi, ALL, [code] sqlite> SELECT * FROM sqlite_master WHERE name LIKE '%temp%'; type|name|tbl_name|rootpage|sql table|temp|temp|40|CREATE TABLE temp(id INTEGER PRIMARY KEY, name VARCHAR(200)) table|temp1|temp1|41|CREATE TABLE temp1(myid INTEGER PRIMARY KEY, id INTEGER, my name VARCHAR(200), CONSTRAI

Re: [sqlite] SQLite slow when lots of tables

Peter, On Tue, Jan 29, 2019 at 7:53 PM Peter da Silva wrote: > > On Tue, Jan 29, 2019, 7:46 PM Igor Korot > > You can install mySQL/MariaDB for free and use it for your needs. > > I believe that if you pay to Oracle/MariaDB Foundation, it will be > > just for support

Re: [sqlite] SQLite slow when lots of tables

Hi, On Tue, Jan 29, 2019 at 7:06 PM Keith Medcalf wrote: > > On Tuesday, 29 January, 2019 16:28, Wout Mertens wrote: > > >To: SQLite mailing list > >Subject: Re: [sqlite] SQLite slow when lots of tables > > > > I always have to explain to people that there's no magic sauce that > > "real database

Re: [sqlite] SQLite slow when lots of tables

Hi, On Mon, Jan 28, 2019 at 10:17 AM wrote: > > Dear, > > I developed an application that need to create 1 table with thousand of rows > every time when a certain event occours. Are you coming from the FoxBase/ForPro world? Thank you. > > This works in a good way, but when the number of the t

Re: [sqlite] SQLite 3.24.0 Solaris 9 build failure

Dennis, On Sat, Jan 19, 2019 at 9:31 PM Dennis Clarke wrote: > > > > And SPARC version is still available for download... > > Let us know when you get that running. Install of x86 went very smooth. And I was able to compile fairly recent SQLite with Oracle Studio 12.6 with just couple of warnings

Re: [sqlite] SQLite 3.24.0 Solaris 9 build failure

Hi, On Sat, Jan 19, 2019 at 4:29 PM Dennis Clarke wrote: > > On 1/19/19 4:47 PM, Andy Goth wrote: > > Dennis Clarke wrote: > >> On 2018-07-28 08:33, Andy Goth wrote: > >>> SQLite 3.24.0 fails to build on Solaris 9 (a.k.a. Solaris 2.9) > > > >> It may be [worth] while to spin up a Solaris 9 zone o

[sqlite] Solaris Studio 12.6 compilation failure

"sqlite3.c", line 29907: warning: conversion to double is out of range "sqlite3.c", line 52491: warning: statement not reached Is it something to be worry? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Or for the simplicity sake - just add the sqlite3.* files to the project and compile everything. But then you will NOT need to follow the instruction in my previous email. As Keith said, you should choose the path and follow it - either use the source code or use precompiled library. Thank you.

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

ee those exact words. If you can, it would be > helpful to know the route to get there, like > > Linker>>Input>>??????? > Thanks for your time. > > From: Igor Korot > To: SQLite mailing list > Sent: Friday, December 21, 2018 4:47 PM > Subject:

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Hi, On Fri, Dec 21, 2018 at 6:26 PM zydeholic wrote: > > My cpp code consists of this at the moment: > #include "sqlite3.h" > #include > #include > using namespace std; > > int main() > { > sqlite3 *db; > } > > I have added sqlite3.h to my header files.I have added sqlite3.c to my source >

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Hi, Unfortunately you didn't tell what did you try to compile, where did you get the files you tried to compile from and you didn't even supply the error message you received from the compilation. Please follow-up and provide this and hopefully someone here will be able to help. Thank you. On Th

Re: [sqlite] Creating and dropping tables with multiple connections

Hi, On Tue, Nov 20, 2018 at 10:32 AM Dominique Devienne wrote: > > On Tue, Nov 20, 2018 at 5:28 PM Simon Slavin wrote: > > > On 20 Nov 2018, at 3:34pm, Albert Banaszkiewicz < > > albert.banaszkiew...@tomtom.com> wrote: > > > > > ExecuteInTransaction(writeDb1, KCreateTable); > > > > I can't answe

Re: [sqlite] Help!

Hi, On Sat, Oct 27, 2018 at 1:41 PM am...@juno.com wrote: > > 10/27/18 Dear Good People: I have two issues which I have not been able to > solve. Hopefully at least one of you good people know how to do these. The > first is: how do I make a field wrap the text. In other words, rather than > h

Re: [sqlite] Unique Constraint Failed

Hi, On Fri, Sep 14, 2018 at 3:14 PM Andrew Stewart wrote: > > Hi all, > I realize that this is the constraint that is failing. The > data is very large, encrypted and at a customer's site - not easy to use an > external program to view or to transfer to my office. > >

Re: [sqlite] Common index for multiple databases

k to the office. Thank you. > > John > > > > On 08/02/2018 11:33 AM, Igor Korot wrote: >> >> Hi, >> >> On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden >> wrote: >>> >>> I made a mistake. I should have said table, not database

Re: [sqlite] Common index for multiple databases

Hi, On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden wrote: > I made a mistake. I should have said table, not database. My concern is if > I have 4 databases each with tables associated with a particular use, like > accounting, technical, etc., which may reside on different computers, how do > I

Re: [sqlite] Check if the new table has been created

Hi, Simon, On Thu, Jul 5, 2018 at 11:45 AM, Simon Slavin wrote: > On 5 Jul 2018, at 4:51pm, Igor Korot wrote: > >> Is there a way to get which command was executed? >> Or which table was added/changed/dropped? > > There is no reason for SQLite to record the inf

Re: [sqlite] Check if the new table has been created

Hi, On Tue, Jun 19, 2018 at 1:56 PM, Richard Hipp wrote: > On 6/19/18, Igor Korot wrote: >> Hi, Wout, >> >> On Tue, Jun 19, 2018 at 1:31 PM, Wout Mertens >> wrote: >>> you can query the table with >>> https://www.sqlite.org/pragma.html#pragm

Re: [sqlite] column types and constraints

Hi, ALL, I am not sure what are we talking about here and is discussed. Just like on the paper the hard drive is storing the characters. It is for us (humans, developers) to interpret those characters as a TEXT, numeric value (be it INTEGER or FLOAT/DOUBLE) or some binary data. As long as the clie

Re: [sqlite] Check if the new table has been created

he default parameters. It means that I can safely pass the connection I made to the secondary thread and update my table cache and everything will work just fine. Am I reading the docs correctly? Thank you. On Wed, Jun 20, 2018 at 9:17 PM, Igor Korot wrote: > David, > > On Wed, Jun 20, 201

Re: [sqlite] Check if the new table has been created

>> On 21/06/2018, at 12:44 PM, Igor Korot wrote: >> >> Hi, guys, >> I put in this code: >> >>if( sqlite3_prepare_v2( m_db, "PRAGMA >> schema_version", NULL, &stmt, NULL ) == SQLITE_OK ) >>

Re: [sqlite] Check if the new table has been created

Richard, On Wed, Jun 20, 2018 at 8:17 PM, Richard Hipp wrote: > On 6/20/18, Igor Korot wrote: >> if( ( res = sqlite3_step( stmt ) ) == SQLITE_OK ) > > sqlite3_step() returns SQLITE_ROW when it has data, not SQLITE_OK. But SQLITE_ROW value is not 21 - its

Re: [sqlite] Check if the new table has been created

Hi, guys, I put in this code: if( sqlite3_prepare_v2( m_db, "PRAGMA schema_version", NULL, &stmt, NULL ) == SQLITE_OK ) { if( ( res = sqlite3_step( stmt ) ) == SQLITE_OK ) { m_schema

Re: [sqlite] Check if the new table has been created

Hi, guys, On Tue, Jun 19, 2018 at 4:37 PM, Igor Korot wrote: > Hi, Ryan, > > On Tue, Jun 19, 2018 at 3:22 PM, R Smith wrote: >> >> On 2018/06/19 8:26 PM, Igor Korot wrote: >>> >>> Hi, >>> Is there a C API which checks if the new table has been c

Re: [sqlite] Check if the new table has been created

Hi, Ryan, On Tue, Jun 19, 2018 at 3:22 PM, R Smith wrote: > > On 2018/06/19 8:26 PM, Igor Korot wrote: >> >> Hi, >> Is there a C API which checks if the new table has been created? > > > We could break this down into a few separate questions: > > 1 - Is

Re: [sqlite] Check if the new table has been created

Is there a different way? Thank you. > > On Tue, Jun 19, 2018, 8:26 PM Igor Korot wrote: > >> Hi, >> Is there a C API which checks if the new table has been created? >> >> Thank you. >> ___ >> sqlite-us

[sqlite] Check if the new table has been created

Hi, Is there a C API which checks if the new table has been created? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reset the cursor

Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > >>-Original Message- >>From: sqlite-users [mailto:sqlite-users- >>boun...@mailinglists.sqlite.org] On Behalf Of Igor Korot >>Sent: Thursday, 7 June, 2018 2

Re: [sqlite] Reset the cursor

linglists.sqlite.org] On Behalf Of Olivier Mascia >>Sent: Tuesday, 5 June, 2018 15:35 >>To: SQLite mailing list >>Subject: Re: [sqlite] Reset the cursor >> >>> Le 5 juin 2018 à 22:47, Igor Korot a écrit : >>> >>> As a side note: is it the case for

Re: [sqlite] Reset the cursor

Hi, Olivier, On Tue, Jun 5, 2018 at 3:15 PM, Olivier Mascia wrote: >> Le 5 juin 2018 à 18:19, Igor Korot a écrit : >> >> My query is: >> >> std::string query = "PRAGMA foreign_key_list( \"%w\" )"; >> >> Then I'm doing this:

Re: [sqlite] Reset the cursor

er Reset > ! > > Loop 3, No Reset, Got SQLITE_DONE > ! > sqlite3_reset returns 0 > > which is what I would expect ... > > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. >

Re: [sqlite] Reset the cursor

ep() gives SQLITE_DONE. But I guess the next time it runs it just fails for some in-known reason. If that's not it - I guess I will have to give you the test case for it. Thank you and sorry for not thinking about this immediately. On Tue, Jun 5, 2018 at 6:38 AM, Igor Korot wrote: > Hi,

Re: [sqlite] Reset the cursor

he second iteration. Thank you. > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > >>-Original Message- >>From: sqlite-users [mailto:sqlite-users- >>boun...@mailingl

Re: [sqlite] Reset the cursor

loop because the statement was not reset. >> >>One more thing: >> >>Is my assumption correct that sqlite3_errcode() returning 0, indicate >>there was no error? >> >>Thank you. >> >>> >>> --- >>> The fact that there's

Re: [sqlite] Reset the cursor

From: sqlite-users [mailto:sqlite-users- >>boun...@mailinglists.sqlite.org] On Behalf Of Igor Korot >>Sent: Monday, 4 June, 2018 11:50 >>To: SQLite mailing list >>Subject: Re: [sqlite] Reset the cursor >> >>Keith, >> >>On Mon, Jun 4, 2018 at 12:35 PM, Keit

Re: [sqlite] Reset the cursor

Keith, On Mon, Jun 4, 2018 at 12:35 PM, Keith Medcalf wrote: > > #include "sqlite3.h" > #include > > void main(int argc, char** argv) > { > sqlite3* db = 0; > sqlite3_stmt* stmt = 0; > char* rest = 0; > int rc = 0; > int value = 0; > sqlite3_open(":memory:", &db); > r

Re: [sqlite] Reset the cursor

also presume you are testing under the latest SQLite source? Thank you. > > 2018-06-04 10:41:10 MinGW [D:\work] >>test > > Loop 1, no reset > 1 2 3 4 5 6 7 8 9 10 ! > sqlite3_reset returns 0 > > Loop 2, after reset > 1 2 3 4 5 6 7 8 9 10 ! > sqlite3_reset returns

Re: [sqlite] Reset the cursor

x, On Mon, Jun 4, 2018 at 10:54 AM, x wrote: > If the first loop exits with res3 == SQLITE_DONE then !result will be true > and the second loop should process exactly the same (assuming underlying data > is unchanged). I can’t see why the code below wouldn’t work although I’m > confused by the

Re: [sqlite] Reset the cursor

evious post a successful sqlite3_step doesn’t return SQLITE_OK > so > > res3 == SQLITE_ROW is never true. But SQLITE_OK != SQLITE_ROW. Thank you. > > > > > > ____ > From: sqlite-users on behalf > of Igor Korot > Sent: Monday, Jun

Re: [sqlite] Reset the cursor

ply to Igor's post. Thank you. > > > > > From: sqlite-users on behalf > of Igor Korot > Sent: Monday, June 4, 2018 1:52:05 PM > To: SQLite mailing list > Subject: Re: [sqlite] Reset the cursor > > Hi, > > On Mon, J

Re: [sqlite] Reset the cursor

Hi, Igor, On Mon, Jun 4, 2018 at 7:55 AM, Igor Tandetnik wrote: > On 6/4/2018 12:31 AM, Igor Korot wrote: >> >> Now I'd like the cursor in the recordset of the "stmt" to go to the record >> 1 >> so I can process those records again. >> >> I

Re: [sqlite] Reset the cursor

Hi, On Mon, Jun 4, 2018 at 7:54 AM, Igor Korot wrote: > Hi, Clemens et al, > > On Mon, Jun 4, 2018 at 1:23 AM, Clemens Ladisch wrote: >> Igor Korot wrote: >>> res = sqlite3_step( stmt ); >>> >>> Now I'd like the cursor in the recordset o

Re: [sqlite] Reset the cursor

Hi, Clemens et al, On Mon, Jun 4, 2018 at 1:23 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> res = sqlite3_step( stmt ); >> >> Now I'd like the cursor in the recordset of the "stmt" to go to the record 1 >> so I can process those records again.

[sqlite] Reset the cursor

Hi, All, After executing the following: int res = sqlite3_prepare_v2( ... stmt ); while( ; ; ) { res = sqlite3_step( stmt ); if( res == SQLITE_ROW ) { // process the record } else if( res == SQLITE_DONE ) break; else { // error procressing }

Re: [sqlite] ALTER TABLE

Hi, Charles, On Tue, May 22, 2018 at 2:30 PM, Charles Leifer wrote: > As a workaround, you can always rename the existing table, create the new > table with desired attributes, and do a INSERT INTO ... SELECT FROM > old_table. Then you can safely drop the old table. But the table_name will be di

Re: [sqlite] unknown type name 'sqlite_int64'

Hi, On Mon, Apr 30, 2018 at 7:31 PM, jungle Boogie wrote: > On 5:20PM, Mon, Apr 30, 2018 Igor Korot wrote: >> >> Hi, >> >> On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie > wrote: >> > Hi All, >> > >> > What's happening here? &

Re: [sqlite] unknown type name 'sqlite_int64'

Hi, On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie wrote: > Hi All, > > What's happening here? > > $ cc --version > OpenBSD clang version 6.0.0 (tags/RELEASE_600/final) (based on LLVM 6.0.0) > Target: aarch64-unknown-openbsd6.3 > Thread model: posix > > ARM64 bit on a pine64-lts device running: >

Re: [sqlite] String Too Long

Hi, On Thu, Mar 1, 2018 at 1:20 PM, Matías Badin wrote: > Hi all; > I am trying to insert a big string and i have the message: Request too long. > > I set my parameter as "text" but i still have this problem. > > Do you know if i can use another type? BLOB? Thank you. > > Thanks >

Re: [sqlite] Please remove my id from mailing list/subscription.

Hi, On Thu, Feb 8, 2018 at 10:00 AM, Vasanth wrote: > Please remove my id from mailing list/subscription. Why not do it yourself? Did you try to go to the link shown at the end of this email or any other for that matter? Thank you. > ___ > sqlite-use

Re: [sqlite] Vetting SQLite

Hi, On Mon, Feb 5, 2018 at 11:41 AM, Simon Slavin wrote: > On 5 Feb 2018, at 5:21pm, Drago, William @ CSG - NARDA-MITEQ > wrote: > >> I've been using/loving SQLite for years, but the use of open source software >> is highly discouraged where I work, and now I have to prove to our IT dept. >>

Re: [sqlite] sqlite3_column_decltype and max and min

Hi, On Sat, Jan 13, 2018 at 6:32 AM, Niall O'Reilly wrote: > > > On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G > : > >> You can >> download and/or compile your own up-to-date SQLite that is twice as >> fast and has all the latest features. > > It may be more convenient to use

Re: [sqlite] Retrieving constraint name

gt;>the comma delimited part of the well formed CREATE TABLE statement. >>When >>obtained from sqlite_master, the statement is guaranteed to be well >>formed. Simply examine each comma delimited candidate part. If >>present, >>the first word between keyword CONSTRA

Re: [sqlite] Retrieving constraint name

Hi, Cezary et al, On Mon, Dec 11, 2017 at 5:48 PM, Cezary H. Noweta wrote: > Hello, > > On 2017-12-11 04:29, Igor Korot wrote: >> >> Thank you, but I need to keep the official SQLite code. > > Anyway, for the people who are interested in foreign key names: >

Re: [sqlite] C++ compiler

Hi, On Tue, Jan 2, 2018 at 3:34 PM, wrote: > Hi: > > Not only it can, but that is probably the use in the 99.00% of C++ > applications that uses SQLite. That number should probably be 99.999(9)%... ;-) Thank you. > > The only caveat is that you can get some warnings depending on the comp

Re: [sqlite] C++ compiler

Hi, On Sat, Dec 30, 2017 at 5:35 AM, eli wrote: > Hello, > > It would be awesome if SQLite could compile as a part of bigger C++ project. > Right now there is a bunch of pointer casting errors, that can be fixed in > a matter of hour IMHO. Which OS/compiler are you trying? What is the exact erro

Re: [sqlite] Move to Github!!?

Hi, On Wed, Dec 27, 2017 at 12:00 PM, Warren Young wrote: > On Dec 27, 2017, at 7:49 AM, Nelson, Erik - 2 > wrote: >> >>> Also when you're forced to use a third party ticket system, fossil i >>> missing one of its big advantages. >> >> I'm no Fossil expert, but it does seem to have a ticketing

Re: [sqlite] Retrieving constraint name

On Mon, Dec 11, 2017 at 4:48 PM, Cezary H. Noweta wrote: > Hello, > > On 2017-12-11 04:29, Igor Korot wrote: >> >> Thank you, but I need to keep the official SQLite code. > > Anyway, for the people who are interested in foreign key names: > http://sqlite.chncc.eu/

Re: [sqlite] Retrieving constraint name

constraint name. Yes, I may try to do that in the meantime. Thank you. > > Peter > > > > > > > > > > On Sun, Dec 10, 2017 at 7:29 PM, Igor Korot wrote: > >> Hi, >> >> On Sun, Dec 10, 2017 at 8:30 PM, Cezary H. Noweta >> wrote: >> > He

Re: [sqlite] Retrieving constraint name

Hi, On Sun, Dec 10, 2017 at 8:30 PM, Cezary H. Noweta wrote: > Hello, > > On 2017-12-11 01:04, Igor Korot wrote: > >> On Sun, Dec 10, 2017 at 5:01 PM, Cezary H. Noweta >> wrote: > > >>> On 2017-12-10 07:21, Igor Korot wrote: > > >>>>

Re: [sqlite] Retrieving constraint name

Hi, On Sun, Dec 10, 2017 at 5:01 PM, Cezary H. Noweta wrote: > Hello, > > On 2017-12-10 07:21, Igor Korot wrote: >> >> The CREATE TABLE statement supports the following syntax: >> >> CREATE TABLE( , CONSTRAINT FOREIGN >> KEY() REFERENCES (ref_column_list&

[sqlite] Retrieving constraint name

Hi, The CREATE TABLE statement supports the following syntax: CREATE TABLE( , CONSTRAINT FOREIGN KEY() REFERENCES (ref_column_list>); However, the statement "PRAGME foreign_key_list;" does not list the foreign key name ("fk_name" in the statement above). Does the info for the aforementioned PRA

Re: [sqlite] Why Unicode is difficult

Stephen, On Mon, Dec 4, 2017 at 1:01 PM, Stephen Chrzanowski wrote: > ... as in how 1 != "1"? No. 1000 vs 1,000 vs 1.000 vs 1,000.00 vs whatever. > > On Mon, Dec 4, 2017 at 11:07 AM, Igor Korot wrote: > >> Hi, >> >> On Mon, Dec 4, 2017 at 7:42 AM, Jay

Re: [sqlite] Why Unicode is difficult

Hi, On Mon, Dec 4, 2017 at 7:42 AM, Jay Kreibich wrote: > > > Next, we can talk about how dates and times are simple and straight-forward. And then the number representation... Thank you. > > -j > > > >> On Dec 4, 2017, at 7:08 AM, Simon Slavin wrote: >> >> Every so often someone asks on thi

Re: [sqlite] how into insert row into middle of table with integer primary key

Hi, On Wed, Nov 22, 2017 at 2:30 PM, Shane Dev wrote: > On 22 November 2017 at 17:08, Igor Korot wrote: > >> Hi, Shane, >> >> >> What I don't understand is why do you need to do that? >> > > Imagine I have a GUI element with a drop down list of fr

Re: [sqlite] Many ML emails going to GMail's SPAM

Hi, On Wed, Nov 22, 2017 at 10:53 AM, jungle Boogie wrote: > On 22 November 2017 at 07:56, Igor Korot wrote: >> Hi, >> Postgres very recently switched to PGLister for their ML >> >> This software switch tries to do exactly that - it tries to stay >> co

Re: [sqlite] how into insert row into middle of table with integer primary key

ng the record is an implementation detail which shouldn't bother you at all. Unless you can sow us that the time required to retrieve the sorting data will SIGNIICANTLY differ in both cases. I am ready to hear arguments against this approach. ;-) Thank you. > > > On 22 Novembe

Re: [sqlite] Many ML emails going to GMail's SPAM

Hi, Postgres very recently switched to PGLister for their ML This software switch tries to do exactly that - it tries to stay complaint with all this DMARC stuff. Here is the announcement that was posted on their wiki page: https://wiki.postgresql.org/wiki/PGLister_Announce. Since SQLite follows

Re: [sqlite] how into insert row into middle of table with integer primary key

Simon, On Tue, Nov 21, 2017 at 4:48 PM, Simon Slavin wrote: > > > On 21 Nov 2017, at 10:09pm, Jens Alfke wrote: > >>> On Nov 21, 2017, at 1:56 AM, R Smith wrote: >>> >>> That assumes you are not starting from an integer part (like 4000) and >>> hitting the exact same relative insert spot every

Re: [sqlite] how into insert row into middle of table with integer primary key

Hi, On Mon, Nov 20, 2017 at 10:12 AM, R Smith wrote: > This question pops up from time to time. > > I will show a correct query script to achieve this below, but I want to > emphasize what others have said: Data in an RDBMS has no intrinsic order, > it's all SETs, and if you artificially bestow o

Re: [sqlite] Best way to develop a GUI front-end

Take a look at wx{Phoenix, Python}. It is much simpler, written in python, supports all its versions, and there demos and samples on its website - www.wxpython.org Thank you. On Wed, Nov 15, 2017 at 2:32 PM, Peter Da Silva wrote: > Tk is platform independent, so long as you don’t do UNIX-specifi

Re: [sqlite] Best way to develop a GUI front-end

Hi, Did you look at wxPython (or wxPhoenix)? It was recenty saw a new release.. Thank you. On Tue, Nov 14, 2017 at 3:39 PM, Peter Da Silva wrote: > On 11/14/17, 3:33 PM, "sqlite-users on behalf of Balaji Ramanathan" > balaji.ramanat...@gmail.com> wrote: >> I am leaning towards tcl/tk given the

[sqlite] PRAGMA foreign_key_list

Hi, I am curious - how hard will it be to add the constraint name to the result of this view? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite_master structure

Simon, On Wed, Nov 1, 2017 at 10:44 PM, Simon Slavin wrote: > > > On 2 Nov 2017, at 3:37am, Igor Korot wrote: > >> I see that sqlite_master have 2 fields: name and tbl_name. It looks >> like they have >> the same value in my case. >> >> Is t

[sqlite] sqlite_master structure

Hi, ALL, I see that sqlite_master have 2 fields: name and tbl_name. It looks like they have the same value in my case. Is there a scenario when those 2 are different? And what should I check for the "table name"? Thank you. ___ sqlite-users mailing list

Re: [sqlite] very sqlite3 noobie error

Hi, John, On Sun, Oct 22, 2017 at 9:59 PM, John R. Sowden wrote: > Since I am trying to learn sqlite3 (unlearning foxpro) I find that python is > the simpleist language, wfich allows me to focus on sqlite, I amtrying the > =guide just sent to the list. > > I am getting a syntax error on line 5.

Re: [sqlite] How to create primary key from two another PK's?

Hi, On Oct 21, 2017 5:18 AM, "csanyipal" wrote: I try to follow advices and modify my database so it is now like this: *CREATE TABLE "student" ( "idnum" TEXT NOT NULL CONSTRAINT "pk_student" PRIMARY KEY, "studentname" TEXT NOT NULL, "teachinglang" VARCHAR(2) NOT NULL, "grade" TINYINT,

Re: [sqlite] How to handle such situation

Hi Keith, On Oct 6, 2017 12:59 PM, "Keith Medcalf" wrote: The return code will tell you the cause of the failure Love them. Check them. Every time. I'm checking them. But if there is a ROLLBACK failure I will tell the user and when the app will close sqlite3_close() will be called. I guess

Re: [sqlite] How to handle such situation

Hi Simon et al, So I shouldn't card if _close() fail either way? Just give an error and quit? Thank you. On Oct 5, 2017 2:01 PM, "Simon Slavin" wrote: On 5 Oct 2017, at 6:42pm, Igor Korot wrote: > My question here is about ROLLBACK failure vs sqlite3_close() failure.

Re: [sqlite] How to handle such situation

11:50 AM, "Simon Slavin" wrote: > > > On 5 Oct 2017, at 4:35pm, Igor Korot wrote: > > > You mean like have some kind of flag and display an error on disconnect > > only if not set? > > If ROLLBACK fails, it’s probably because of a hardware failure or

Re: [sqlite] How to handle such situation

Jens, You mean like have some kind of flag and display an error on disconnect only if not set? Thank you. On Oct 5, 2017 11:32 AM, "Jens Alfke" wrote: > > > > On Oct 4, 2017, at 7:16 PM, Igor Korot wrote: > > > > And if the ROLLBACK fails? > > Then A

Re: [sqlite] How to handle such situation

17 6:15:55 PM EDT, Jens Alfke wrote: >> >> >>> On Oct 4, 2017, at 2:20 PM, Igor Korot wrote: >>> >>> If I start transaction, all queries were successful, but issuing >>"COMMIT" fails. >>> On such failure I am going to present an e

Re: [sqlite] How to handle such situation

Hi, Jens, On Wed, Oct 4, 2017 at 6:15 PM, Jens Alfke wrote: > > >> On Oct 4, 2017, at 2:20 PM, Igor Korot wrote: >> >> If I start transaction, all queries were successful, but issuing "COMMIT" >> fails. >> On such failure I am going to present an e

[sqlite] How to handle such situation

Hi, list, Have a following question. I am writing an application in which I will be using transactions. At the end of the application I will close the connection. The application will verify every single call to SQLite for an error. If I start transaction, all queries were successful, but issuing

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

Simon, On Fri, Sep 29, 2017 at 4:38 PM, Simon Slavin wrote: > > > On 29 Sep 2017, at 9:06pm, Denis V. Razumovsky wrote: > >> What can be wrong for _any_ of the compilers if you will define >> SQLITE_4_BYTE_ALIGNED_MALLOC as 0 in sqlite3.h? It's so simple. I think >> it should only get better for

Re: [sqlite] FULLMUTEX and exclusive transactions between threads

Not if you use connection-per-thread model. On Thu, Sep 28, 2017 at 3:07 PM, Simon Slavin wrote: > > > On 28 Sep 2017, at 8:01pm, pisymbol . wrote: > >> So you can still have issues with thread 1 issuing a "BEGIN" and then >> thread 2 issuing another "BEGIN" before thread 1 finalizes the transac

Re: [sqlite] FULLMUTEX and exclusive transactions between threads

Hi, Simon, On Thu, Sep 28, 2017 at 11:55 AM, Simon Slavin wrote: > > > On 28 Sep 2017, at 3:31pm, pisymbol . wrote: > >> Specificially, if thread 1 and 2 both have a handle to sqlite3 with full >> mutex, then both could start a transaction simultaneously, one will win the >> other will wait, [sn

Re: [sqlite] CREATE FOREIGN KEY support

Hi, Clemens, On Wed, Sep 27, 2017 at 7:04 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> 3. DROP TABLE ; >> >> On step 3 all ttriggers and indexes will be dropped as well, right? > > Yes. > >> 4. CREATE TABLE (, FOREIGN KEY() REFERENCE pkTable() ) AS SELE

  1   2   3   4   5   >