Re: [sqlite] Compiling spellfix for sqlite3

Thanks for those explanations Keith and Richard. I always thought the <> were the ones supplied by the language. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Compiling-spellfix-for-sqlite3-tp70656p97122.html Sent from the SQLite mailing list archive at Nabble.com. __

Re: [sqlite] Compiling spellfix for sqlite3

On 8/25/17 2:15 PM, Keith Medcalf wrote: When the included file is in " " then the file is expected to be located relative to the current directory. If the included file is in < > then it is relative to one of the directories specified in the "include search path". This search may or may not

Re: [sqlite] Compiling spellfix for sqlite3

ed traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of curmudgeon >Sent: Friday, 25 August, 2017 11:35 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Compiling spellfix for sqlite3 > &g

Re: [sqlite] Compiling spellfix for sqlite3

Thanks Keith, the config info is most welcome. I wasn't sure if I was supposed to download zlib.h the fact it was inside <> instead of "" but understand now. Is the include in csv.c not a bug though, or is it again down to my compiler? -- View this message in context: http://sqlite.1065341.n5

Re: [sqlite] Compiling spellfix for sqlite3

ay 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 curmudgeon >Sent: Friday, 25 August, 2017 07:41 >To: sqlite-users@mailinglists.s

Re: [sqlite] Compiling spellfix for sqlite3

While testing I appended the following code to the end of sqlite3.c. #include "csv.c" #include "stmt.c" #include "compress.c" #include "eval.c" #include "carray.c" int core_init(const char* dummy) { int nErr = 0; nErr += sqlite3_auto_extension((void(*)())sqlite3_compress_init);

Re: [sqlite] Compiling spellfix for sqlite3

On Thu, Aug 24, 2017 at 1:24 AM, Keith Medcalf wrote: > >On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf > wrote: > >Where's that pragma from Keith? Thanks, --DD > > They were added "experimentally" on July 7, 2017 Oh cool, that's great! thanks for the heads-up. > You will note that for examp

Re: [sqlite] Compiling spellfix for sqlite3

On Wednesday, 23 August, 2017 16:28, Dominique Devienne wrote: >On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf wrote: >> sqlite> pragma function_list; >> group_concat|1 >> group_concat|1 >> julianday|1 >> julianday|1 >> nullif|1 >> nullif|1 >> sqlite_compileoption_get|1 >> sqlite_compileoption

Re: [sqlite] Compiling spellfix for sqlite3

On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf wrote: > > sqlite> pragma function_list; > group_concat|1 > group_concat|1 > julianday|1 > julianday|1 > nullif|1 > nullif|1 > sqlite_compileoption_get|1 > sqlite_compileoption_get|1 > current_timestamp|1 > current_timestamp|1 > sqlite_compileoption_

Re: [sqlite] Compiling spellfix for sqlite3

Thanks for the explanation Keith and the help. I've learned a lot the last few days. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Compiling-spellfix-for-sqlite3-tp70656p97040.html Sent from the SQLite mailing list archive at Nabble.com. __

Re: [sqlite] Compiling spellfix for sqlite3

INTROSPECTION_PRAGMAS defined. --- 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...@mailinglists.sqlite.org] On Behalf Of curmudgeon >

Re: [sqlite] Compiling spellfix for sqlite3

Keith, I finally managed to use carray this morning. The C++ builder IDE had a facility for entering conditional defines in Project|Options. I had noticed this before asking the question on the c++ builder forum but hadn't realised the -D part of -DSQLITE_EXTRA_INIT=cor_init wasn't required. Thank

Re: [sqlite] Compiling spellfix for sqlite3

On Tuesday, 22 August, 2017 09:30, curmudgeon wrote: >Your cast did the trick Keith and it compiled fine once I removed the >'-DSQLITE_EXTRA_INIT=core_init' line but I have no idea how to get >that directive into the c++ builder application. I've put up a question >on the c++ builder forum but

Re: [sqlite] Compiling spellfix for sqlite3

Your cast did the trick Keith and it compiled fine once I removed the '-DSQLITE_EXTRA_INIT=core_init' line but I have no idea how to get that directive into the c++ builder application. I've put up a question on the c++ builder forum but unanswered as yet. -- View this message in context: http:

Re: [sqlite] Compiling spellfix for sqlite3

On Monday, 21 August, 2017 11:44, curmudgeon wrote: >Thanks Keith. I followed your instructions but I'm now getting the >following compiler errors >[bcc32 Error] carray.c(412): E2342 Type mismatch in parameter 'xInit' >(wanted 'void (*)()', got 'void *') >// on the 'nErr += >sqlite3_auto_extensi

Re: [sqlite] Compiling spellfix for sqlite3

Thanks Keith. I followed your instructions but I'm now getting the following compiler errors [bcc32 Error] carray.c(412): E2342 Type mismatch in parameter 'xInit' (wanted 'void (*)()', got 'void *') // on the 'nErr += sqlite3_auto_extension((void*)sqlite3_carray_init); line' [bcc32 Error] carray.

Re: [sqlite] Compiling spellfix for sqlite3

e-users- >boun...@mailinglists.sqlite.org] On Behalf Of curmudgeon >Sent: Monday, 21 August, 2017 09:13 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Compiling spellfix for sqlite3 > >Keith, I know this is an old post but it refers to something we >discussed

Re: [sqlite] Compiling spellfix for sqlite3

Keith, I know this is an old post but it refers to something we discussed recently. I tried the following I added the #include carray.c line to just above the bottom of the amalgamation such that the last few lines are #include carray.c #endif /* SQLITE_CORE */ #endif /* !defined(SQLITE_CORE) |

Re: [sqlite] Compiling spellfix for sqlite3

On Sun, Aug 25, 2013 at 6:25 AM, Mirat Bayrak wrote: > I needed wanted to build "did you mean this?" feature to my website. I'm > using sqlite3 and learned that i can use spellfix module to order tables > via levenstein. > > I downloaded source code of > sqlite3

Re: [sqlite] Compiling spellfix for sqlite3

> I downloaded source code of and compiled spellfix.c (it's inside /ext/misc/) > like this: > gcc -shared -fPIC -Wall -I/tmp/sqlite-src-3071700/ spellfix.c -o spellfix > It compiles successfuly but when i load it into sqlite: > sqlite> .load ./spellfix > I'm getting this error: > Error: .

[sqlite] Compiling spellfix for sqlite3

I needed wanted to build "did you mean this?" feature to my website. I'm using sqlite3 and learned that i can use spellfix module to order tables via levenstein. I downloaded source code of sqlite3 and compiled spellfix.c (it's inside /ext/misc/)