Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

:\SQLite\sqlite-autoconf-317> RBS On Wed, Feb 15, 2017 at 12:11 AM, Cezary H. Noweta <c...@poczta.onet.pl> wrote: > Hello, > > On 2017-02-15 00:53, Bart Smissaert wrote: > >> I tried first with the original source, without altering anything at all. >> I

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Actually first time I saw these errors the source file and the solution file were on a USB stick and again that worked fine before. RBS On Tue, Feb 14, 2017 at 11:54 PM, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > There's no way to do this on a normal installation

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Tue, Feb 14, 2017 at 1:23 PM, Bart Smissaert > <bart.smissa...@gmail.com> wrote: > > C:\Program Files (x86)\Microsoft Visual Studio > > 12.0\VC\vcprojects\Win32\SQLite\s > > qlite-autoconf-317>nmake /f Makefile.msc > > What?! > > You're building fro

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

I tried first with the original source, without altering anything at all. I then had the errors. RBS On Tue, Feb 14, 2017 at 11:38 PM, Cezary H. Noweta <c...@poczta.onet.pl> wrote: > Hello, > > On 2017-02-14 23:52, Bart Smissaert wrote: > >> I tried both with an

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

First time I saw this. Mind you I only use MSVS to compile SQLite. RBS On Tue, Feb 14, 2017 at 10:57 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/14/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > I just tried with an old 3.11.1 and got different errors: > &

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Yes it looks it is a change in MSVS that is causing this trouble. Not sure now reinstalling is that simple with licensing etc. RBS On Tue, Feb 14, 2017 at 10:49 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Feb 2017, at 10:47pm, Bart Smissaert <bart.smissa...@gma

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

that problem. > > my .02 $ > > 2017-02-14 17:20 GMT-05:00 Simon Slavin <slav...@bigfraud.org>: > > > > > On 14 Feb 2017, at 10:15pm, Bart Smissaert <bart.smissa...@gmail.com> > > wrote: > > > > > The strange thing is that nil changed oth

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

I just tried with an old 3.11.1 and got different errors: Error 1 error C4703: potentially uninitialized local pointer variable 'pDbPage' used c:\program files (x86)\microsoft visual studio 12.0\vc\vcprojects\win32\sqlite\3_11_1\sqlite3.c 57565 1 SQLite Error 2 error C4703: potentially

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

, David Empson <demp...@emptech.co.nz> wrote: > > On 15/02/2017, at 10:23 AM, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > > -c sqlite3.c > > sqlite3.c > > sqlite3.c(16114) : error C2059: syntax error : 'if' > > sqlite3.c(16117) : error C20

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

) and compiled fine there. No idea what the problem is. RBS On Tue, Feb 14, 2017 at 8:25 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/14/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > > > Should I compile with nmake instead? > > Where should I

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

-amalgamation-317.zip <https://www.sqlite.org/2017/sqlite-amalgamation-317.zip> and same problem. Should I compile with nmake instead? Where should I type that? Thanks for the assistance. RBS On Tue, Feb 14, 2017 at 7:05 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/14/17,

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

wrote: > > On 14 Feb 2017, at 3:06pm, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > Yes, didn't expect this was reproducible. > > All I can think of is that somehow MSVS doesn't recognize this now as C > > code. > > Must be one of the settin

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

There is a setting in VS and that says compile as C code. Will start from scratch and make a new VS solution. RBS On Tue, Feb 14, 2017 at 3:32 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Feb 2017, at 3:06pm, Bart Smissaert <bart.smissa...@gmail.com> > wro

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Yes, didn't expect this was reproducible. All I can think of is that somehow MSVS doesn't recognize this now as C code. Must be one of the settings in VS that has somehow changed. RBS On Tue, Feb 14, 2017 at 2:18 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/13/17, Bart

[sqlite] Problem compiling 3.17.0 in MSVS 12

Downloaded the latest 3.17.0 (sqlite-autoconf-317.tar.gz) and replaced my old 3.16.2 sqlite3.c file in the VC. Now for some reason I get lots of errors when building a Windows dll. First one is at line 16116 in this code block: #define SQLITE_SKIP_UTF8(zIn) { if( (*(zIn++))>=0xc0 ){

[sqlite] Problem compiling 3.17.0 in MSVS 12

Downloaded the latest 3.17.0 (sqlite-autoconf-317.tar.gz ) and replaced my old 3.16.2 sqlite3.c file in the VC. Now for some reason I get lots of errors when building a Windows dll. First one is at line 16116 in this code block:

Re: [sqlite] sqlite3_complete

On 2/9/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > I have seen a prepare take over a second. > > Take for example this recursive Sudoku SQL: > > > > I think you are confusing "prepare" with "prepare and execute". The > prepare for the

Re: [sqlite] sqlite3_complete

I have seen a prepare take over a second. Take for example this recursive Sudoku SQL: WITH RECURSIVE input(sud) AS ( VALUES('.3..76..1.5986.8...6...34..8.3..17...2...6.6284.9..58..7.') ), digits(z, lp) AS ( VALUES('1', 1) UNION ALL SELECT CAST(lp+1 AS

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

Would a "server app" be an option, so run SQLite on the remote location and return the dataset? RBS On Mon, Feb 6, 2017 at 10:28 AM, dandl wrote: > We have an application we converted from Access to Sqlite. Mostly it's > been a great success, but we have two queries that runs

Re: [sqlite] Problem with sqlite3_bind_int

<i...@tandetnik.org> wrote: > On 1/20/2017 6:15 PM, Bart Smissaert wrote: > >> Good idea, >> I have checked for this but will double check again. >> The problem arises already with the very first element of the variant >> array >> and my log shows the problem: >

Re: [sqlite] Problem with sqlite3_bind_int

There are no Boolean True values in the variant array. RBS On Fri, Jan 20, 2017 at 10:57 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 1/20/2017 4:55 PM, Bart Smissaert wrote: > >> These integer values are then bound like this: >> >> sqlite3_bind_int lStatementHand

Re: [sqlite] Problem with sqlite3_bind_int

> or storing the right values but recalling them incorrectly I am 100% sure they are recalled correctly but bound wrongly. Verified this in various different ways. RBS On Fri, Jan 20, 2017 at 9:59 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Jan 2017, at 9:55pm,

[sqlite] Problem with sqlite3_bind_int

Using the latest SQLite3 on Windows, accessed from an ActiveX dll. Come across a strange bug that I just can't unravel: I have a 2 dimensional VB6 variant array that I am moving to a SQLite table. This variant array is obtained from a .csv text file. The first column of this variant array holds

Re: [sqlite] Why this query plan?

> Anyone asking why the order is what it is is not a valid question Well, I think it was as I know the answer now and that was useful to know. RBS On Thu, Jan 12, 2017 at 11:17 PM, Darko Volaric wrote: > Your example is entirely wrong. Spreadsheet apps explicitly define the >

Re: [sqlite] Why this query plan?

ssage- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Bart Smissaert > Sent: Thursday, January 12, 2017 3:53 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Why this query plan? > > How about a > pragma_sort_as

Re: [sqlite] Why this query plan?

How about a pragma_sort_asc_on_rowid_or_primary_integer_key_for_unordered_selects ? RBS On 12 Jan 2017 20:35, "Richard Hipp" wrote: > On 1/12/17, David Raymond wrote: > > > > In the same vane I assume DRH's random ordering would be only random by >

Re: [sqlite] Why this query plan?

> Because the index is smaller than the main table. Less disk I/O. Yes and that is the one (and only one) interesting thing I found from this thread. So you could benefit from an index for reasons other than the usual reasons eg assisting the where clause. RBS On Thu, Jan 12, 2017 at 4:33 PM,

Re: [sqlite] Why this query plan?

I am fully aware of this and I have no problem at all with this behaviour. I just wondered why it choose the particular plan in this situation. There is no criticism, just curiosity. RBS On Thu, Jan 12, 2017 at 12:45 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/11/17, Bart

[sqlite] Why this query plan?

Say I have a table created like this: create table table1( [id] integer primary key, [dob] integer) with an index (not unique) on dob and I run this SQL: select id, dob from table1 then the query plan I get is: SCAN TABLE TABLE1 USING COVERING INDEX IDX_TABLE1_DOB The result is that the

Re: [sqlite] sqlite3_result_subtype and sqlite3_value_subtype, what are they used for?

OK, thanks. RBS On Sat, Jan 7, 2017 at 7:24 PM, Richard Hipp <d...@sqlite.org> wrote: > On 1/7/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > Maybe a strange question, but what are these methods used for? > > Does anybody have a real example? > > Inve

[sqlite] sqlite3_result_subtype and sqlite3_value_subtype, what are they used for?

Maybe a strange question, but what are these methods used for? Does anybody have a real example? RBS ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can the Explain explain what is going on here?

a useful fix. RBS On Wed, Jan 4, 2017 at 1:09 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > >> On 1/3/17, Bart Smissaert <bart.smissa...@gmail.com>

Re: [sqlite] Can the Explain explain what is going on here?

Thanks, will try that out. RBS On Wed, Jan 4, 2017 at 1:09 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > >> On 1/3/17, Bart Smissaert <bart.smissa..

Re: [sqlite] Can the Explain explain what is going on here?

, _ ByVal 0, _ ByVal 0) RBS On Wed, Jan 4, 2017 at 12:58 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > On Tuesday, 3 January, 2017 17:18. Simon Slavin <slav...@bigfraud.org> > wrote: > > > On 4 Jan 20

Re: [sqlite] Can the Explain explain what is going on here?

, at 12:09am, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > Secondly, can the Explain statement tell me that indeed the UDF runs > 10 > > times in the first SQL and only once for the second SQL? > > What makes you think that this is the case ? Why would

Re: [sqlite] Can the Explain explain what is going on here?

Thanks for that. Yes, indeed not a bug. Not sure there is a scenario imaginable where this optimization will be helpful in real practice. RBS On Wed, Jan 4, 2017 at 12:25 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/3/17, Bart Smissaert <bart.smissa...@gmail.com> wrote:

Re: [sqlite] Can the Explain explain what is going on here?

> What makes you think that this is the case ? I didn't check, but this was the only explanation I could think of. Will check in a bit. RBS On Wed, Jan 4, 2017 at 12:17 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 4 Jan 2017, at 12:09am, Bart Smissaert <bart.s

[sqlite] Can the Explain explain what is going on here?

Have a table (only used for testing) like this: CREATE TABLE Table1([Field1] INTEGER) It has 10 rows and all the values in Field1 are 1. There are no indexes. Now I run queries that include a UDF. The code of this UDF is in VBScript and generally this is slow. This is the first SQL:

Re: [sqlite] Unregister UDF, created with sqlite3_create_function_v2

<danielk1...@gmail.com> wrote: > On 12/19/2016 03:32 AM, Bart Smissaert wrote: > >> Using the latest SQLite from VB6 and trying to unregister a UDF, created >> with sqlite3_create_function_v2. >> This registration works fine and the UDF's work fine. >> No

[sqlite] Unregister UDF, created with sqlite3_create_function_v2

Using the latest SQLite from VB6 and trying to unregister a UDF, created with sqlite3_create_function_v2. This registration works fine and the UDF's work fine. Now I am trying to unregister this UDF and the only hint how to do this that I could find was in the documentation of

Re: [sqlite] Run non-data producing statement just once to test UDF

<h...@scigames.at> wrote: > Select AddOne( ); > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Bart Smissaert > Gesendet: Sonntag, 11. Dezember 2016 22:39 > An: General Discussion of

Re: [sqlite] Run non-data producing statement just once to test UDF

This is still a bit tricky, but I have another work-around for my problem and all sorted now. RBS On Sun, Dec 11, 2016 at 10:02 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Dec 2016, at 9:55pm, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > >>

Re: [sqlite] Run non-data producing statement just once to test UDF

OK, thanks, will try that. RBS On Sun, Dec 11, 2016 at 10:02 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Dec 2016, at 9:55pm, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > >> where rowid = (select min(rowid) from table1) > &g

Re: [sqlite] Run non-data producing statement just once to test UDF

uld be useful if there was something like sqlite3_step1 just for this scenario. RBS On Sun, Dec 11, 2016 at 9:47 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 12/11/2016 4:38 PM, Bart Smissaert wrote: > >> Say I have a UDF called AddOne in a statement like this: >>

[sqlite] Run non-data producing statement just once to test UDF

Say I have a UDF called AddOne in a statement like this: update table1 set field1 = AddOne(field1) and say the table table1 has some million rows. Now I want to test this statement to test the UDF but I want to do this for only one row. How do I do this? limit 1 only applies to data producing

Re: [sqlite] Setting up SQLite for VB6

I think you will need this ODBC driver: http://www.ch-werner.de/sqliteodbc/ RBS On Mon, Nov 21, 2016 at 8:12 AM, J Trahair wrote: > Hi everyone > > I am trying to link a VB6 project to SQLite. (I can do this fine in > VB.Net.) I am using System.Data.SQLite.dll

Re: [sqlite] no such column error

Hi Rob, I can see your point, but couldn't tell you if this should be considered a bug or not. Probably only DRH can tell you that. RBS On Thu, Oct 27, 2016 at 8:21 AM, Rob Golsteijn wrote: > Hi RBS, > > Re-introducing mytable in the sub-select is a workaround (and

Re: [sqlite] no such column error

Try this: UPDATE mytable SET myfield1 = (SELECT 1 from mytable ORDER BY EXISTS (SELECT 1 WHERE mytable.myfield2 = 1 ) ) RBS On Tue, Oct 25, 2016 at 4:40 PM, Rob Golsteijn

Re: [sqlite] 2 consecutive rises in value

> so that one can find more than one row for the same values of (Id,Date)? Yes and that messes up your idea. Solution is to tidy that table up first before running any select SQL. > Average, last one, largest one? For now I have taken the largest one as in R Smith's SQL. Probably it is better to

Re: [sqlite] 2 consecutive rises in value

> select distinct T1.Id-- only one per Id > from TABLE1 T1, TABLE1 T2, TABLE1 T3 -- very fast join on indexed rowid > where T2.Seq = T1.Seq+1 and T3.Seq = T1.Seq+2 -- consecutive triples > andT1.Id = T2.Id and T3.Id + T1.Id

Re: [sqlite] 2 consecutive rises in value

Thanks, will give that a try as well, but I am happy with the solution form R Smith. Only one relatively simple SQL and quite fast. Took about 1.5 secs to process 5 rows. RBS On Thu, Oct 20, 2016 at 4:55 PM, Jean-Luc Hainaut < jean-luc.hain...@unamur.be> wrote: > > What about this one? > >

Re: [sqlite] 2 consecutive rises in value

> and do NOT reverse comparison operators in the final WHERE clause. Yes, thank, that was it. RBS On Thu, Oct 20, 2016 at 4:40 AM, Cezary H. Noweta <c...@poczta.onet.pl> wrote: > Hello, > > On 2016-10-20 01:58, Bart Smissaert wrote: > >> I worked it round

Re: [sqlite] 2 consecutive rises in value

> It has three consecutive drops, no? E.g. 47 < 46 < 37 That is 3 values, but only 2 drops. RBS On Thu, Oct 20, 2016 at 1:07 AM, Petite Abeille <petite.abei...@gmail.com> wrote: > > > On Oct 20, 2016, at 1:58 AM, Bart Smissaert <bart.smissa...@gmail.com> >

Re: [sqlite] 2 consecutive rises in value

Thanks, will try that as well. RBS On Thu, Oct 20, 2016 at 12:16 AM, Petite Abeille <petite.abei...@gmail.com> wrote: > > > On Oct 20, 2016, at 12:23 AM, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > > Ah, yes, sorry, I needed actually drops and w

Re: [sqlite] 2 consecutive rises in value

5-03-30 39 62 2016-09-02 40 Any idea what I did wrong? RBS On Wed, Oct 19, 2016 at 11:23 PM, Bart Smissaert <bart.smissa...@gmail.com> wrote: > Ah, yes, sorry, I needed actually drops and was looking at that. > Will work it round. > > RBS > > > On Wed, Oct 19,

Re: [sqlite] 2 consecutive rises in value

Ah, yes, sorry, I needed actually drops and was looking at that. Will work it round. RBS On Wed, Oct 19, 2016 at 11:06 PM, Petite Abeille <petite.abei...@gmail.com> wrote: > > > On Oct 19, 2016, at 11:40 PM, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > >

Re: [sqlite] 2 consecutive rises in value

I get these ID's: ID 2 13 22 26 ID 2 for example shouldn't be selected. RBS On Wed, Oct 19, 2016 at 9:48 PM, R Smith <rsm...@rsweb.co.za> wrote: > > > On 2016/10/19 4:53 PM, Bart Smissaert wrote: > >> Have a table like this: >&

Re: [sqlite] 2 consecutive rises in value

ht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Bart Smissaert > Gesendet: Mittwoch, 19. Oktober 2016 16:53 > An: General Discussion of SQLite Database <sqlite-users@mailinglists. > sqlite.org> > Betreff: [sqlite] 2 consecutiv

[sqlite] 2 consecutive rises in value

Have a table like this: create table TABLE1([ID] INTEGER, [ISO8601_DATE] TEXT, [INT_VALUE] INTEGER) with data like this: ID ISO8601_dateINT_VALUE 1 2016-01-01 10 1 2016-01-28 9 1 2016-03-05

[sqlite] 64bit DLL vs 32bit

So, is there any way that a 32 bit VB6 ActiveX dll or a32 bit VB6 ActiveX exe could access a 64 bit SQLite dll? All this only comes into play for me when using 64 bit VBA in Excel. I have no problem to access the 64 bit SQLite dll from 64 bit VBA. RBS On Sun, May 15, 2016 at 7:12 PM, Richard

[sqlite] SQLITE_ENABLE_EXPLAIN_COMMENTS not showing with sqlite3_compileoption_used

Using SQLite 3.12.2 on Windows 10. Compiled from the amalgation to a 64 bit dll with these compile options: ENABLE_COLUMN_METADATA=1 SYSTEM_MALLOC=1 THREADSAFE=0 ENABLE_EXPLAIN_COMMENTS=1 When I run sqlite3_compileoption_used the first 3 compile options show indeed fine as they should, but

[sqlite] Compiling SQLite dll 64 bits in MSVS

el module is not imported by anything > the "imports" Pane is empty. > > About name decoration please see > https://msdn.microsoft.com/en-us/library/56h2zst2.aspx > > Bart Smissaert schrieb am 05.04.2016 um 23:42: > >> I said that wrong, even in the old 32 bit

[sqlite] Compiling SQLite dll 64 bits in MSVS

Haven't I got that here: > Additional Options: > > sqlite3.c /Gz -DSQLITE_API=__declspec(dllexport) Or should I leave the D off before SQLITE_API ? RBS On Tue, Apr 5, 2016 at 11:04 PM, J Decker wrote: > On Tue, Apr 5, 2016 at 2:09 PM, Bart Smissaert > wrote: > >

[sqlite] Compiling SQLite dll 64 bits in MSVS

I said that wrong, even in the old 32 bits Dependency Walker there is nil in the top right pane. Still, there are no decorated function names in the 64 bit dll to see. Is this normal or do I have to alter my command line parameters? RBS On Tue, Apr 5, 2016 at 10:23 PM, Bart Smissaert wrote

[sqlite] Compiling SQLite dll 64 bits in MSVS

exports. > Depending on your build flags you may need to comment out some exports. > > > > Bart Smissaert schrieb am 05.04.2016 um 22:01: > >> I downloaded the 64 bit version of DependencyWalker from here: >> https://support.microsoft.com/en-us/kb/256872 >> but it

[sqlite] Compiling SQLite dll 64 bits in MSVS

de/download/dependency-walker.html (German site, but > > downloads should be easy to spot). > > > > But if I remember this right, you need to include the sqlite3.def file > from > > the binary dll-package into your project to create the exports. > Depending on >

[sqlite] Compiling SQLite dll 64 bits in MSVS

ncy Walker comes in two different flavors, one for x86 and one for > x64. You need to use the appropriate one for your DLL. > > > > Bart Smissaert schrieb am 05.04.2016 um 09:50: > >> Trying to compile SQLite 64 bits in MSVS 2013 from the amalgation. >> Using

[sqlite] Compiling SQLite dll 64 bits in MSVS

Trying to compile SQLite 64 bits in MSVS 2013 from the amalgation. Using instructions from: http://pavel.cernohorsky.name/blog/2015/09/sqlite_64-bit_binaries_for_windows_and_how_to_build_them_with_visual_studio_2015.php All compiles well, so no warnings and get a dll of about 700 kB. Nil shows

[sqlite] sqlite in vba7.1 and windows 8.1

Did you figure this out? I have just come across the same problem in a 64 bit Office (Excel) installation. RBS On Fri, Feb 19, 2016 at 1:31 PM, Montes C?mara, < victor.montes at alicante-ayto.es> wrote: > Hello, > > I've been using sqlite in vba6 for some years using RichClient3 framework > of

[sqlite] Slight problem with sqlite3_compileoption_get

s about C. Agree and got the books, just need the time. RBS On Sun, Jan 24, 2016 at 10:53 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 24/01/16 13:12, Bart Smissaert wrote: > >>> I think that unless the argument is going to be altered I h

[sqlite] Slight problem with sqlite3_compileoption_get

> If your VB variable contains an sqlite3* then the item should be passed ByVal. Ah, yes, thanks for correcting that. RBS On Sun, Jan 24, 2016 at 10:18 PM, Keith Medcalf wrote: > > > >> I think that unless the argument is going to be altered I have to pass > > them always ByVal. > > That

[sqlite] Slight problem with sqlite3_compileoption_get

: SHA1 > > On 24/01/16 02:19, Bart Smissaert wrote: > > You didn't mention it but how arguments are called from VB6 is also > > very important, that is ByVal or ByRef. I think that unless the > > argument is going to be altered I have to pass them always ByVal. > >

[sqlite] Slight problem with sqlite3_compileoption_get

: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 24/01/16 02:19, Bart Smissaert wrote: > > You didn't mention it but how arguments are called from VB6 is also > > very important, that is ByVal or ByRef. I think that unless the > > argument is going t

[sqlite] Slight problem with sqlite3_compileoption_get

Sat, Jan 23, 2016 at 8:55 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 23/01/16 11:41, Bart Smissaert wrote: > > My question is how could I have foreseen this problem, so how could > > I have known that using long is no good here? >

[sqlite] Slight problem with sqlite3_compileoption_get

Using a .tlb file to access the sqlite3 functions from VB6. Sofar when the arguments of the sqlite3 function are declared as int I have been using long in the IDL source to compile the tlb and this has been fine. sqlite3_compileoption_get is defined like this: const char

[sqlite] Get X number of random integer numbers between A and B

t; > > On Fri, Jan 22, 2016 at 12:11 PM, Bart Smissaert < > bart.smissaert at gmail.com > > > wrote: > > > >> Say I want 1 random numbers between 100 and 1000 how can I do that > >> without > >> selecting from a table? > >> I know I

[sqlite] Get X number of random integer numbers between A and B

max from conf)) select n from rnd Not familiar with CTE's and it looks quite complex. RBS On Fri, Jan 22, 2016 at 11:22 AM, Stephan Beal wrote: > On Fri, Jan 22, 2016 at 12:11 PM, Bart Smissaert > > wrote: > > > Say I want 1 random numbers between 100 and 1000 how can

[sqlite] Get X number of random integer numbers between A and B

Say I want 1 random numbers between 100 and 1000 how can I do that without selecting from a table? I know I can do: select abs(random() %(1000 - 100)) + 100 as rnd from TableWith1Rows but there must be a better way. RBS

[sqlite] Problem with sqlite3_create_function

Hipp wrote: > On 11/4/15, Bart Smissaert wrote: > > Been trying to get to the bottom of this, but no success. > > Note that with one UDF in the statement all runs perfectly fine. > > Could somebody confirm that they can run 2 UDF's (I have mainly tried > with > > the

[sqlite] Parsing the contents of a field

It probably can be done with just SQLite's built-in text functions such as instr and substr, although with 20 to 30 items it may get a bit messy and complex. RBS On Wed, Jan 13, 2016 at 5:42 AM, audio muze wrote: > I have a table of roughly 500k records with a number of fields > containing

[sqlite] Can SQLite know from the statement string if it is row producing or not?

ntents > > -Urspr?ngliche Nachricht- > Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Bart > Smissaert > Gesendet: Freitag, 08. J?nner 2016 21:28 > An: General Discussion of SQLite Database > Bet

[sqlite] Can SQLite know from the statement string if it is row producing or not?

> Presumably this is something the original poster wants. Yes, need to know if the statement >could< produce rows. RBS On Sat, Jan 9, 2016 at 4:57 PM, Simon Slavin wrote: > > On 9 Jan 2016, at 1:18pm, Bart Smissaert wrote: > > >> but only after at least

[sqlite] Bug in sqlite3_prepare16_v2

/16, Bart Smissaert wrote: > > If I run sqlite3_prepare16_v2 on this statement: > > > > PRAGMA compile_optionsXXX > > > > I get a return value of 0 and there is a non-zero statement handle. > > I would expect a return value of 1 and a zero statement handle. >

[sqlite] Bug in sqlite3_prepare16_v2

If I run sqlite3_prepare16_v2 on this statement: PRAGMA compile_optionsXXX I get a return value of 0 and there is a non-zero statement handle. I would expect a return value of 1 and a zero statement handle. But if I run instead sqlite3_prepare16_v2 on this statement: PRAGMA compile_options XXX

[sqlite] Can SQLite know from the statement string if it is row producing or not?

adisch wrote: > >> Bart Smissaert wrote: >> >>> I am interested to know from the statement string if the statement is >>> invalid, row producing (could produce rows) or non row producing. >>> >> <http://www.sqlite.org/c3ref/column_count.html> says

[sqlite] Can SQLite know from the statement string if it is row producing or not?

> sqlite3_column_count Ah, yes that looks good, will try that one. RBS On Sat, Jan 9, 2016 at 11:30 AM, Clemens Ladisch wrote: > Bart Smissaert wrote: > > I am interested to know from the statement string if the statement is > > invalid, row producing (could produce rows) or

[sqlite] Can SQLite know from the statement string if it is row producing or not?

On 08-01-16 21:27, Bart Smissaert wrote: > >> I am interested to know from the statement string if the statement is >> invalid, row producing (could produce rows) or non row producing. I know >> sqlite3_prepare16_v2 can see if the statement is valid or not but how >&g

[sqlite] How to make sqlite3_release_memory produce a result?

still doesn't free the excess. > > Looks like that was added in 3.8.11 back in July. > > -scott > > > On Thu, Jan 7, 2016 at 5:44 AM, Bart Smissaert > wrote: > > > These are the compile flags of my sqlite3.dll: > > > > compile_option >

[sqlite] Can SQLite know from the statement string if it is row producing or not?

I am interested to know from the statement string if the statement is invalid, row producing (could produce rows) or non row producing. I know sqlite3_prepare16_v2 can see if the statement is valid or not but how about the other 2? I can do this in code no problem, but it may not always be 100%

[sqlite] How to make sqlite3_release_memory produce a result?

back in July. > > -scott > > > On Thu, Jan 7, 2016 at 5:44 AM, Bart Smissaert > wrote: > > > These are the compile flags of my sqlite3.dll: > > > > compile_option > > > > DEBUG > > EN

[sqlite] How to make sqlite3_release_memory produce a result?

reverse_unordered_selects 0 PRAGMA secure_delete 0 PRAGMA wal_autocheckpoint 1000 PRAGMA writable_schema 0 PRAGMA journal_mode off PRAGMA auto_vacuum NONE PRAGMA synchronous OFF PRAGMA temp_store DEFAULT RBS On Thu, Jan 7, 2016 at 1:39 PM, Bart Smissaert wrote: > > So you should > see results if

[sqlite] How to make sqlite3_release_memory produce a result?

n 7, 2016 at 6:05 AM, Scott Hess wrote: > On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissaert > wrote: > > > Have compiled sqlite3.dll (latest) compiled with > ENABLE_MEMORY_MANAGEMENT, > > but sofar > > not been able yet to make sqlite3_release_memory produce anything

[sqlite] How to make sqlite3_release_memory produce a result?

OK, will try that. sqlite3_release_memory doesn't have the DB connection as an argument, but found sqlite3_db_release_memory and that has that as an argument and that may work better. RBS On Thu, Jan 7, 2016 at 6:05 AM, Scott Hess wrote: > On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissa

[sqlite] How to make sqlite3_release_memory produce a result?

Have compiled sqlite3.dll (latest) compiled with ENABLE_MEMORY_MANAGEMENT, but sofar not been able yet to make sqlite3_release_memory produce anything else than 0. What would be the simplest way to make this happen? I don't want to do this with C coding, so it should be some SQL scenario or to do

[sqlite] Malloc getting segmentation fault in sqlite

; > Then you will know which line could be related to the problem. > > > -Original Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > > bounces at mailinglists.sqlite.org] On Behalf Of Bart Smissaert > > Sent: Saturday, 26 De

[sqlite] Malloc getting segmentation fault in sqlite

QLITE_TRANSIENT > > But as it uses SQLITE_TRANSIENT, I understand SQLite will make local > copy > > and deal with it properly itself. > > > > All the other code is just copying data from SQLite to local VB6 > > variables. > > > > RBS > > > > > &g

[sqlite] Malloc getting segmentation fault in sqlite

5:23pm, Bart Smissaert > wrote: > > >> all is perfectly fine when the SQL statement has only one UDF in it > > > > Just a correction on this. Have now also seen problems when there is only > > one UDF in the SQL statement. > > It is not entirely predictable, so s

[sqlite] Malloc getting segmentation fault in sqlite

:31 PM, Bart Smissaert wrote: > Thanks for clearing that up. > I know all this has very little to do with SQLite, but people using SQLite > with VB6 or VBA might be interested in this. > What puzzles me that all is perfectly fine when the SQL statement has only > one UDF in it, but

[sqlite] Malloc getting segmentation fault in sqlite

conventions (cdecl versus stdcall). > > I'll try looking for my old VB6 SQLite integration code when I have some > spare cycles. > > Sent from my iPhone > > > On Dec 24, 2015, at 11:10 AM, Bart Smissaert > wrote: > > > > OK, thanks > > I don't u

[sqlite] Malloc getting segmentation fault in sqlite

oes sqlite3.dll actually do, directly running after the UDF? It should be the next sqlite3_step, but that doesn't appear in my debug log, so something goes wrong before that. Again, I will drop all this if it is deemed to be inappropriate as it has little to do with SQLite. Happy Xmas,RBS

<    1   2   3   4   5   6   >