Re: [sqlite] sqlite3_column_decltype and max and min

lumn is an aggregate or an > expression, it likely will not carry the origin declaration type anymore > and only overloading the datatype into the column name (via as) will work. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot abou

Re: [sqlite] sqlite3_column_decltype and max and min

nticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert > >Sent: Saturday, 6 January, 2018 15:00 > >To: SQLite mailing list > >Subject: Re: [s

Re: [sqlite] sqlite3_column_decltype and max and min

t about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert > >Sent: Saturday, 6 January, 2018 10:45 > >To: General Discussion of SQLite Databa

Re: [sqlite] sqlite3_column_decltype and max and min

> Which is bound to lead to problems at some point. Not sure it is a problem if SQLite still recognizes the custom data types as it's own data types. Eg, int_date will be considered integer. RBS On Sat, Jan 6, 2018 at 5:59 PM, Simon Slavin wrote: > On 6 Jan 2018, at 5:45pm, Bar

[sqlite] sqlite3_column_decltype and max and min

Is there any way with sqlite3_column_decltype (or otherwise) to get the declared data type (as in the table create sql in SQLite_master) when it is a simple expression such as max and min? for example we have a table created like this: create table1([integer_date] int_date) and we do: select ma

Re: [sqlite] pragma table_info return column delimiters?

OK, thanks. I am getting the information now from the create table statements and sofar that seems to work OK. Just wanted to make sure there wasn't a better way to handle this. RBS On Wed, Jan 3, 2018 at 11:08 AM, Richard Hipp wrote: > On 1/3/18, Bart Smissaert wrote: > > Is th

Re: [sqlite] pragma table_info return column delimiters?

> What are column delimiters? create table [table1)([ID] integer, [text_field] text) I am talking about the square brackets here surrounding the field names. Sorry, used the wrong word in saying delimiters. RBS On Wed, Jan 3, 2018 at 10:44 AM, Luuk wrote: > > > On 03-01-18

[sqlite] pragma table_info return column delimiters?

Is there a way with pragma table_info or otherwise (other than parsing the table create statement from SQLite_master) to get the column names including the column delimiters, eg double quotes or square brackets? So I would get eg: [column1] [column2] etc. if indeed the column names were delimited l

Re: [sqlite] values ?

Works OK here. What is your SQLite version? RBS On Tue, Dec 12, 2017 at 6:34 PM, Mark Wagner wrote: > My reading of https://sqlite.org/syntax/select-core.html makes me think > that I should be able to issue something like values('foo'); and get a row > with a single column whose value is 'foo'.

Re: [sqlite] How to use sqlite3_table_column_metadata?

auto-increment:0 How does that work? RBS On Mon, Nov 27, 2017 at 10:13 AM, Bart Smissaert wrote: > > My advise to the VB guy would be to load the extension instead of trying > to > get VB to marshal pointers from the C API. > > ?? I do load the extension although it is

Re: [sqlite] How to use sqlite3_table_column_metadata?

where I.ObjectType == O.ObjectType > > and I.ObjectName == O.ObjectName > > and I.IsPrimaryKey > 1); > > > > will return all the 'INTEGER PRIMARY KEY' in the "main" database ... > > > > I

Re: [sqlite] How to use sqlite3_table_column_metadata?

; database ... > > I do not know what it does for "without rowid" tables where there is a > single field declared as "integer primary key", if you have some of those > you will have to figure it out (and how to eliminate them if you want to do > so) yourself. >

Re: [sqlite] How to use sqlite3_table_column_metadata?

All sorted now. This was indeed a coding error and nil to do with SQLite. RBS On Sun, Nov 26, 2017 at 7:56 PM, Clemens Ladisch wrote: > Bart Smissaert wrote: > > Having some difficulty using sqlite3_table_column_metadata, used from > VB6. > > > > I keep getting a z

Re: [sqlite] How to use sqlite3_table_column_metadata?

I am passing a pointer to UTF encoded strings and the passed table and column do exist. There must be something wrong in my code. RBS On Sun, Nov 26, 2017 at 7:56 PM, Clemens Ladisch wrote: > Bart Smissaert wrote: > > Having some difficulty using sqlite3_table_column_metadata,

[sqlite] How to use sqlite3_table_column_metadata?

Having some difficulty using sqlite3_table_column_metadata, used from VB6. I keep getting a zero for the first output argument (should be pointer to declared data type string) and the return value of the function keeps giving 1. I read in Jay Kreibich's book: db_name A logical database name, enco

Re: [sqlite] SQL top 3

--- > CanadaPodunk1 > UKLondon10 > UKBirmingham9 > UKManchester8 > USA New York 10 > USA Los Angeles 9 > USA Chicago 8 > > > -Origina

[sqlite] SQL top 3

Say I have a table like this: CREATE TABLE COUNTRIES(COUNTRY TEXT, CITY TEXT, POPULATION INTEGER) What would be the SQL to get 3 cities for each country with the highest 3 populations for that country? So, for example for the United Kingdom it would show London, Birmingham, Manchester in that ord

Re: [sqlite] Simple SQL question?

they exist, either in the inner or outer correlate. > > --- > 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- > &

Re: [sqlite] Simple SQL question?

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 Bart Smissaert > >Sent: Wednesday, 15 November, 2017 14:55 >

Re: [sqlite] Simple SQL question?

E_DATE) FROM > TABLE_P AS P WHERE P.ID = ID); > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Bart Smissaert > Sent: Wednesday, November 15, 2017 4:17 PM > To: General Discussion of SQLite Database >

Re: [sqlite] Simple SQL question?

create a view instead, and not bother calculating > age_at_issue until necessary since it’s derived completely from two other > columns? > > On 11/15/17, 3:16 PM, "sqlite-users on behalf of Bart Smissaert" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of >

[sqlite] Simple SQL question?

Have 2 tables, TABLE_A and TABLE_P like this: CREATE TABLE_A(ID INTEGER, ISSUE_DATE INTEGER, AGE_AT ISSUE INTEGER) CREATE TABLE_P(ID INTEGER, DOB INTEGER) ID is he common field. Now I want to update the field AGE_AT_ISSUE of TABLE_A, so it will hold the age of the person identified by ID, at th

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

william.dr...@l3t.com> wrote: > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > > Behalf Of Bart Smissaert > > Sent: Monday, November 13, 2017 6:52 PM > > To: SQLite mailing list > > Subj

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

As you are familiar with VBA I can see two other options: 1. Use Christian Werner's ODBC driver from Access (or Excel): http://www.ch-werner.de/sqliteodbc/ 2. Use Olaf Schmidt's COM dll with Access (or Excel): http://www.vbrichclient.com/#/en/About/ RBS On Mon, Nov 13, 2017 at 9:54 PM, Balaji

Re: [sqlite] Valid characters for indentifiers

ouble quotes are better. RBS On Sat, Nov 11, 2017 at 4:52 PM, R Smith wrote: > On 2017/11/11 1:04 PM, Bart Smissaert wrote: > >> What are the exact rules for valid identifier names (tables, columns and >> indexes)? >> This is both for names enclosed in square brackets ([]

[sqlite] Valid characters for indentifiers

What are the exact rules for valid identifier names (tables, columns and indexes)? This is both for names enclosed in square brackets ([]) or double quotes (") and also for names that are not enclosed within square brackets or double quotes. Had a good look for this, but couldn't find a clear answe

Re: [sqlite] What is the most flexible way to exact the table name from a SQL statement

I have a VB6/VBA procedure that takes a SQL and produces the table that was altered by that SQL. I think it works with any SQL, but not sure if is of any help to you. RBS On Sat, Oct 28, 2017 at 1:44 PM, Shane Dev wrote: > Hello, > > Let's say I have a table containing of SQL statements, for ex

Re: [sqlite] Small Performance Regression (3.21.0)

the DatePart UDF as used in other databases eg: https://www.w3schools.com/sql/func_sqlserver_datepart.asp and it looks useful and will just add this in my wrapper. RBS On Sat, Oct 28, 2017 at 10:54 PM, Olaf Schmidt wrote: > Am 28.10.2017 um 19:22 schrieb Bart Smissaert: > >> This is inte

Re: [sqlite] Small Performance Regression (3.21.0)

This is interesting, not so much for the performance regression, but for the fact that the posted Northwind database has spaces in table names and view names. I wasn't aware this is allowed and it caused a lot of errors in my app. I have this nearly fixed now (by adding the square brackets), but I

Re: [sqlite] BedrockDB interview on Floss Weekly

Is this BedrockDB something that could be used to connect to a server and run SQL and avoid the problems (mainly slowness) that SQLite would have in this situation? RBS On Fri, Oct 27, 2017 at 10:40 AM, R Smith wrote: > > On 2017/10/27 7:19 AM, Wout Mertens wrote: > >> Interesting that you emul

Re: [sqlite] version hash

OK, thanks. RBS On Wed, Oct 25, 2017 at 5:53 PM, Richard Hipp wrote: > On 10/25/17, Bart Smissaert wrote: > > Just downloaded and compiled the new 3.21.0 amalgation and noticed the > alt2 > > at the > > end as I added to UDF's to the SQLite source, so to sqlite

[sqlite] version hash

Just downloaded and compiled the new 3.21.0 amalgation and noticed the alt2 at the end as I added to UDF's to the SQLite source, so to sqlite3.c. Just wonder what the difference is between alt1 and alt2. Also, what is the best way add these UDF's, without altering sqlite3.c? Is there a way to do

Re: [sqlite] sqlite3_errcode()

Ok, thanks. All cleared up. RBS On 1 Oct 2017 19:32, "Igor Tandetnik" wrote: On 10/1/2017 1:56 PM, Bart Smissaert wrote: > This is in the documentation of sqlite3_errcode(): > > If the most recent API call was successful, then the return value from > sqlite3_errcode() i

[sqlite] sqlite3_errcode()

This is in the documentation of sqlite3_errcode(): If the most recent API call was successful, then the return value from sqlite3_errcode() is undefined. I can see that if there is no error then then return value of sqlite3_errcode() can be SQLITE_ROW (100) or SQLITE_DONE (101). So, to check if t

Re: [sqlite] How does SQLite handle \r and \n in values?

I needed this recently and for a line break this worked: 'text before linebreak' || char(10) || 'text after linebreak' RBS On Thu, Sep 21, 2017 at 2:56 PM, heribert wrote: > Hello, > > i attempt to make a INSERT with a TEXT field containing a string with \r > and \n characters, but it fails (

Re: [sqlite] Fwd: Problem on Windows 10 machines

ashes: type "k" for displaying the > stack trace or "!analyze" for automated exception analysis. > > Regards, > > Renaat > > > Op 7/09/2017 om 12:56 schreef Bart Smissaert: > > Noticed in the crash dump: >> >> LoadedModule[4]=C:\Users\Use

Re: [sqlite] Fwd: Problem on Windows 10 machines

ception analysis. > > Regards, > > Renaat > > > Op 7/09/2017 om 12:56 schreef Bart Smissaert: > >> Noticed in the crash dump: >> >> LoadedModule[4]=C:\Users\User\AppData\Roaming\Microsoft\ >> AddIns\Bin\MSVBVM60.DLL >> >> This system dll shouldn

Re: [sqlite] Fwd: Problem on Windows 10 machines

is very similar to VB6. In fact the VB6 ActiveX dll is called from VBA (Excel). RBS On Thu, Sep 7, 2017 at 12:24 PM, R Smith wrote: > > > On 2017/09/07 11:09 AM, Bart Smissaert wrote: > >> >> SQLite is a third party product, and would not be pre-installed by >>>

Re: [sqlite] Fwd: Problem on Windows 10 machines

Noticed in the crash dump: LoadedModule[4]=C:\Users\User\AppData\Roaming\Microsoft\ AddIns\Bin\MSVBVM60.DLL This system dll shouldn't be in that folder and I deleted it, but didn't solve any problem. RBS On Thu, Sep 7, 2017 at 11:41 AM, Bart Smissaert wrote: > Process Monitor

Re: [sqlite] Problem with mailing list

4:28 AM, Bart Smissaert wrote: > >> For some reason it seems postings I send sometimes don't get through or >> maybe they do get through but I can't see them. >> I posted something yesterday at 12:55 pm (Problem on Windows 10 >> machines) and I still can't see

Re: [sqlite] Fwd: Problem on Windows 10 machines

(about 5 inches square) > > and > > > "something went wrong, sorry about your luck". > > > > > > > > > --- > > > The fact that there's a Highway to Hell but only a Stairway to Heaven > > says > > > a lot

Re: [sqlite] Fwd: Problem on Windows 10 machines

ng a blue-screen, but is just failing. > > > Could the problem be that SQLite is installed by MS already on those > machines? > > SQLite is a third party product, and would not be pre-installed by > Microsoft. > > > Thanks, > Chris > > > On Thu, Sep

Re: [sqlite] Fwd: Problem on Windows 10 machines

2017 15:06 > >To: SQLite mailing list > >Subject: Re: [sqlite] Fwd: Problem on Windows 10 machines > > > > > > > >On 6 Sep 2017, at 10:03pm, Bart Smissaert > >wrote: > > > >> When my wrapper makes the call to the Sqlite dll my app crashes &g

Re: [sqlite] Fwd: Problem on Windows 10 machines

Well, on one machine I get a crash with no feedback at all. On the other Win 10 machine I get a massage, but these messages are meaningless, pointing to procedures that are not involved at all. RBS On 6 Sep 2017 22:06, "Simon Slavin" wrote: > > > On 6 Sep 2017, at 10:0

Re: [sqlite] Fwd: Problem on Windows 10 machines

Sep 2017, at 8:15pm, Bart Smissaert wrote: > > > On 2 different Win 10 machines I get a crash though when using the dll. > > What crash ? What error ? Is it the same one every time ? > > Simon. > ___ > sqlite-users mailing list

Re: [sqlite] Problem with mailing list

of a Dependency Walker problem than my problem. Any idea what could be the problem here? RBS On Wed, Sep 6, 2017 at 12:05 PM, Scott Doctor wrote: > Check your spam folder. Some messages get trapped from the list in there > occassionally > > On September 6, 2017 1:28:21 AM PDT,

Re: [sqlite] Problem with mailing list

Strange thing the reply to your e-mail came straight through, but nil yet of that resent mail. RBS On Wed, Sep 6, 2017 at 12:05 PM, Scott Doctor wrote: > Check your spam folder. Some messages get trapped from the list in there > occassionally > > On September 6, 2017 1:28:21

Re: [sqlite] Problem with mailing list

Had a look, but not in there, Will just resend it. RBS On Wed, Sep 6, 2017 at 12:05 PM, Scott Doctor wrote: > Check your spam folder. Some messages get trapped from the list in there > occassionally > > On September 6, 2017 1:28:21 AM PDT, Bart Smissaert < > bart.smissa..

[sqlite] Fwd: Problem on Windows 10 machines

-- Forwarded message -- From: Bart Smissaert Date: Tue, Sep 5, 2017 at 12:55 PM Subject: Problem on Windows 10 machines To: General Discussion of SQLite Database < sqlite-users@mailinglists.sqlite.org> Have a std_call compiled dll (sqlite3 3.20.1) that works perfectly fin

[sqlite] Problem with mailing list

For some reason it seems postings I send sometimes don't get through or maybe they do get through but I can't see them. I posted something yesterday at 12:55 pm (Problem on Windows 10 machines) and I still can't see that posting on the list. I mail from my normal GMail account. Is there anything th

[sqlite] Problem on Windows 10 machines

Have a std_call compiled dll (sqlite3 3.20.1) that works perfectly fine on a Win 7 machine. On 2 different Win 10 machines I get a crash though when using the dll. This happens already when I run sqlite3_initialize. When I omit that step it will crash on the next first call to the dll, which is sql

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Thanks that runs fine now. RBS On Mon, Sep 4, 2017 at 8:45 AM, Richard Hipp wrote: > On 9/4/17, Bart Smissaert wrote: > > > > malformed JSON > > > > SQLite should never segfault, regardless of whether or not the JSON is > malformed. > > The ticket (https:

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Thanks, this runs OK now. I am not familiar with JSON, but was just trying this out and see if I could make it work in SQLite. RBS On Mon, Sep 4, 2017 at 8:40 AM, Rowan Worth wrote: > On 4 September 2017 at 15:37, Bart Smissaert > wrote: > > > Trying this out, so I edited

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Trying this out, so I edited the source and indeed now there is no crash. I get however a message: malformed JSON This is the dump of that testing table, dataset: doc {"field1": [{"value": "val1"}, {"value": "val2"}] {"field1": [{"value": "val3"}, {"value": "val2"}] {"field1": [{"value": "val4"}

Re: [sqlite] Example uses of the dbstat virtual table

ducts'; > > Generally though, just using total() is easier ... > > --- > 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:sql

Re: [sqlite] Example uses of the dbstat virtual table

Both integer. RBS On Mon, Sep 4, 2017 at 12:50 AM, Simon Slavin wrote: > > > On 4 Sep 2017, at 12:00am, Bart Smissaert > wrote: > > > It looks this example doesn't work: > > > > SELECT sum(pgsize-unused)/sum(pgsize) FROM dbstat WHERE name='xyz&#

[sqlite] Example uses of the dbstat virtual table

It looks this example doesn't work: SELECT sum(pgsize-unused)/sum(pgsize) FROM dbstat WHERE name='xyz' I thinks it should be something like this: SELECT cast(sum(pgsize-unused) as real) / cast(sum(pgsize) as real) FROM dbstat WHERE name='xyz' RBS ___

Re: [sqlite] Problem with mailing list

Seems to be all sorted now. RBS On Wed, Aug 30, 2017 at 2:47 PM, Stephen Chrzanowski wrote: > I can't help with the list, but I received this note. > > On Wed, Aug 30, 2017 at 4:20 AM, Bart Smissaert > wrote: >

Re: [sqlite] Determine SQLite data type after UDF conversion

UDF is OK. RBS On Wed, Aug 30, 2017 at 12:27 PM, Richard Hipp wrote: > On 8/30/17, Bart Smissaert wrote: > > Say I have a query like this: > > > > Select tbl, BlobAsText(sample) from sqlite_stat4 > > Where BlobAsText is a UDF that takes a blob and converts it

[sqlite] Determine SQLite data type after UDF conversion

Say I have a query like this: Select tbl, BlobAsText(sample) from sqlite_stat4 Where BlobAsText is a UDF that takes a blob and converts it to a string. Now I need to know that the second column of the output needs to be dealt with as text. Is there any SQLite API that can help me with this? sqlit

[sqlite] Problem with mailing list

Got this message: -- Your mail to 'sqlite-users' with the subject Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list Is being held until the list moderator can review it for

[sqlite] Determine SQLite data type after UDF conversion

Say I have a query like this: Select tbl, BlobAsText(sample) from sqlite_stat4 Where BlobAsText is a UDF that takes a blob and converts it to a string. Now I need to know that the second column of the output needs to be dealt with as text. Is there any SQLite API that can help me with this? sqlite3

Re: [sqlite] Output of pragma optimize?

Thanks, now it works! I get: optimize --- ANALYZE "main"."t1" RBS On Sun, Aug 27, 2017 at 12:48 AM, Richard Hipp wrote: > On 8/26/17, Bart Smissaert wrote: > > I looked at my application code and that seems OK, but the output is a > > single

Re: [sqlite] Output of pragma optimize?

ze; > > etc etc. > > https://sqlite.org/pragma.html > > > --- > 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-

Re: [sqlite] Output of pragma optimize?

> SELECT * FROM PRAGMA optimize(1); That doesn't prepare, error at ( RBS On Sat, Aug 26, 2017 at 11:03 PM, Simon Slavin wrote: > > > On 26 Aug 2017, at 10:58pm, Bart Smissaert > wrote: > > > I looked at my application code and that seems OK, but the outp

Re: [sqlite] Output of pragma optimize?

I looked at my application code and that seems OK, but the output is a single null value. What kind of output should I get? RBS On Sat, Aug 26, 2017 at 10:05 PM, Richard Hipp wrote: > On 8/26/17, Bart Smissaert wrote: > > Thanks, tried that but no output. > > Should I run: pr

Re: [sqlite] Output of pragma optimize?

Tried that but no output. Will check my application code, my guess it doesn't handle this statement well. RBS On Sat, Aug 26, 2017 at 10:05 PM, Richard Hipp wrote: > On 8/26/17, Bart Smissaert wrote: > > Thanks, tried that but no output. > > Should I run: pragma optimize

Re: [sqlite] Output of pragma optimize?

Thanks, tried that but no output. Should I run: pragma optimize(1) ? RBS On Sat, Aug 26, 2017 at 9:54 PM, Richard Hipp wrote: > On 8/26/17, Bart Smissaert wrote: > > OK, thanks, I got it. > > What would be a way to show this output? > > I created a large table with no i

Re: [sqlite] Output of pragma optimize?

OK, thanks, I got it. What would be a way to show this output? I created a large table with no indexes, but no output. Then added an index but no analyse, but no output. RBS On Sat, Aug 26, 2017 at 9:16 PM, Clemens Ladisch wrote: > Bart Smissaert wrote: > > Looking at the r

[sqlite] Output of pragma optimize?

Looking at the results of sqlite3_column_count (1) and also sqlite3_column_name (optimize) it seems that pragma optimize can have an output. What would that output be and what would be a way to show such ouput? Using the latest 3.20.1 RBS ___ sqlite-user

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

hat 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...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert > >Sent:

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

---Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert > >Sent: Friday, 25 August, 2017 15:25 > >To: SQLite mailing list > >Subject: Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, > &

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

eak; > > #ifndef SQLITE_OMIT_VIRTUALTABLE > case PragTyp_MODULE_LIST: { > HashElem *j; > pParse->nMem = 1; > for(j=sqliteHashFirst(&db->aModule); j; j=sqliteHashNext(j)){ > Module *pMod = (Module*)sqliteHashData(j); > sqlite3VdbeMultiLoad(v

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

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 Bart Smissaert > >Sent: Friday, 25 August, 20

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

I copied the exact code block as in http://www.sqlite.org/src/info/b79cc8dc88c8ae03 compiled in MSVS, no errors and dll works fine, but still duplicate output. This is in Windows 8. I compiled the edited amalgation. I checked in Notepad that sqlite3.c had indeed the needed changes and it had, so no

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

I applied this fix, but still get the duplicate output. RBS On Fri, Aug 25, 2017 at 10:45 AM, Dan Kennedy wrote: > On 08/25/2017 06:41 AM, Keith Medcalf wrote: > >> If you search sqlite3.c for the SQLITE3_INTROSPECTION_PRAGMAS you will >> see in pragma.c (or in sqlite3.c) the following code: >>

Re: [sqlite] FIX FOR:: Duplicate output with pragma_list, function_list, module_list

gt; #endif /* SQLITE_INTROSPECTION_PRAGMAS */ > > In each, the sqlite3VdbeAddOp2 should be removed. sqlite3VdbeMultiLoad, > as well as adding the data to the vdbe program also generates an > OP_ResultRow instruction ... > > --- > The fact that there's a Highway to Hell but only a

[sqlite] Duplicate output with pragma_list, function_list, module_list

The pragma names and function names are duplicated with these pragma's. Is this a bug? RBS ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pragma pragma_list

Figured this out. SQLITE_INTROSPECTION_PRAGMAS needs to be a Preprocessor definition in MSVS. Not sure why all the pragma's are duplicated. Is this a bug? RBS On Wed, Aug 23, 2017 at 6:17 PM, Bart Smissaert wrote: > Using the latest 3.20.0 and trying to get this pragma to work

[sqlite] pragma pragma_list

Using the latest 3.20.0 and trying to get this pragma to work. I am compiling in MSVS 12 and added this to the compile options: -DSQLITE_INTROSPECTION_PRAGMAS=1 It compiles fine, but I get no output and I expected a list of pragma's. pragma database_list works fine and gives me the expected outp

Re: [sqlite] Packing integer primary key with field bits

Actually looking at the subject title it looks he was. Sorry. RBS On Thu, Aug 10, 2017 at 11:43 AM, Bart Smissaert wrote: > Not sure the OP wanted to touch the rowid/integer primary key. > I think he just was contemplating putting a number of integers in one > single, normal integ

Re: [sqlite] Packing integer primary key with field bits

Not sure the OP wanted to touch the rowid/integer primary key. I think he just was contemplating putting a number of integers in one single, normal integer column. Might be mistaken there. RBS On Thu, Aug 10, 2017 at 10:53 AM, Hick Gunter wrote: > For the sake of the argument, let's try to devi

Re: [sqlite] SQLITE_STMT extension

Ah, OK. I will just keep track then of statement handles in my own code, which is quite simple. RBS On Sat, Aug 5, 2017 at 2:54 PM, Richard Hipp wrote: > On 8/5/17, Bart Smissaert wrote: > > > > SQLite_stmt doesn't hold the statement handle... > > I wonder why thi

[sqlite] SQLITE_STMT extension

As I understand this the eponymous-only virtual table, sqlite_stmt, will show any active (so not finalized) statements on the current database connection. As mentioned this can be useful to track unfinalized statements and this is what I was interested in. There are 2 problems with this: Firstly a

Re: [sqlite] sqlite3_prepare16_v3 and prepFlags

Not quite clear as point 9 in the release notes of 3.20.0 seems to me to suggest that this only applied if you are using FTS3, FTS5 or the R-Tree extension. RBS On Wed, Aug 2, 2017 at 11:09 PM, Nico Williams wrote: > On Wed, Aug 02, 2017 at 11:01:07PM +0100, Bart Smissaert wrote: > &

[sqlite] sqlite3_prepare16_v3 and prepFlags

Using 3.20.0 now on Windows and wonder when exactly I should use the SQLITE_PREPARE_PERSISTENT flag instead of a zero. I have tried both options with a plain select statement producing some 10 rows. Both worked and

Re: [sqlite] Cannot delete a Database file?

What is the return value of sqlite3_close? RBS On Wed, Jun 28, 2017 at 10:37 AM, Domonic Tom wrote: > After calling sqlite3_close(handle) I try then to use the 'remove' method > in C++ to delete my .db file. For some reason it just won't delete. > > > It's hard to show you the whole project be

Re: [sqlite] Something broke between version 3.15 and 3.19.3

explain query plan select * from TripDetails Causes problems as well. RBS On Sun, Jun 11, 2017 at 5:27 AM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > Hi, > > I maintain a personal database on sqlite. It is quite small, with > about 30 tables, and an equal number of views.

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

need to call it just before > sqlite3_finalize(). In fact, if you’re sure your code sets all the > parameters in the statement there’s no need to call it at all. > > On 28 May 2017, at 12:24pm, Bart Smissaert > wrote: > > > If there was a successful sqlite3_step just precedi

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

likely there is no relevant gain. RBS On Sun, May 28, 2017 at 12:28 PM, Gwendal Roué wrote: > > > Le 28 mai 2017 à 13:24, Bart Smissaert a > écrit : > > > >> Calling sqlite3_clear_bindings does the same thing as calling > > sqlite3_bind_null for all arguments. >

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

possibly be unsuccessful? If there was a successful sqlite3_reset just preceding it could a sqlite3_clear_bindings possibly be unsuccessful? RBS On Sun, May 28, 2017 at 12:14 PM, Gwendal Roué wrote: > Hello Bart, > > > Le 28 mai 2017 à 13:03, Bart Smissaert a > écrit : > &g

[sqlite] sqlite3_reset and sqlite3_clear_bindings

Using SQLite3 3.19.0 on a Windows machine. I have some general questions about sqlite3_reset and sqlite3_clear_bindings: I am processing data from a 2D variant array (this is VB6). 1. I understand that after processing a row (binding all the values in a row of that variant array) I need to do eith

Re: [sqlite] SQLite3.Step fast forward / skipping rows

I might be wrong, but to me this sounds like an application coding problem to do with your listview. You will need to code in such a way that the listview doesn't get updated when it doesn' t have to. Does the data come directly from the DB or is there an intermediate eg an array? RBS On Wed, Ma

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

Maybe it is simpler (no parsing needed) to have an extra table with a unique column holding tablename_fieldname and a second column holding the comment for that field. RBS On 15 Mar 2017 10:35, "R Smith" wrote: > > On 2017/03/14 2:54 PM, PICCORO McKAY Lenz wrote: > >> an important feature in

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

Can't you add it to the field name? For example for a field holding date of birth: DOB_INT or DOB_TXT. RBS On Tue, Mar 14, 2017 at 12:54 PM, PICCORO McKAY Lenz wrote: > an important feature in a DB its the column field that gives to developers > metadata info INDEPENDENT of the tecnologies us

Re: [sqlite] Compile Windows dll with MinGW with stdcall calling convention?

st to stick with MSVS. RBS On Sun, Feb 19, 2017 at 4:00 PM, Cezary H. Noweta wrote: > Hello, > > On 2017-02-18 17:35, Bart Smissaert wrote: > >> This is simple in MSVS, but can't see how this can be done with the MinGW >> compiler. >> Any idea how this can be done

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

source file, sqlite3.c. RBS On Wed, Feb 15, 2017 at 3:36 AM, Kevin Benson wrote: > On Tue, Feb 14, 2017 at 7:56 PM, Bart Smissaert > wrote: > > > I had to install WinZip though and at the first unzip I got directly to > the > > files whereas now I had a .tar file fir

[sqlite] Compile Windows dll with MinGW with stdcall calling convention?

This is simple in MSVS, but can't see how this can be done with the MinGW compiler. Any idea how this can be done with the sqlite3.c amalgation? RBS ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

No idea why that is. Could the WinZip alter the file? Another thing is that if I run that sqlite3.c from the MSVS IDE I get the same errors. RBS On Wed, Feb 15, 2017 at 1:11 AM, Cezary H. Noweta wrote: > Hello, > > On 2017-02-15 01:56, Bart Smissaert wrote: > >> Downloade

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

why the difference as the previous source file was fresh downloaded as well. I had to install WinZip though and at the first unzip I got directly to the files whereas now I had a .tar file first and had to unzip that. Thanks for getting me on the right track! RBS On Wed, Feb 15, 2017 at 12:3

<    1   2   3   4   5   6   >