Re: [sqlite] Currency & SQLite

On Tue, Jul 5, 2016 at 3:59 PM, Ertan Küçükoğlu wrote: > Hi, > > I have following data to store: > > My currency values only has 2 decimal digits. (Sample: 1.23) > > My amount values goes around 5-6 decimal digits. (Sample: 1.123456) > > Will it be fine to store these

Re: [sqlite] Currency & SQLite

On Tue, Jul 5, 2016 at 5:14 PM, Darren Duncan wrote: > Ertan, > > You should read https://www.sqlite.org/datatype3.html#section_2 if you > haven't already. > > SQLite has exactly 1 floating-point type, which is what you get no matter > if you say float/double/etc, and it

Re: [sqlite] Currency & SQLite

Ertan, You should read https://www.sqlite.org/datatype3.html#section_2 if you haven't already. SQLite has exactly 1 floating-point type, which is what you get no matter if you say float/double/etc, and it is 8 bytes, which corresponds to a Double in most programming languages. You can't

Re: [sqlite] Currency & SQLite

Hardware that the application will run is ~1Ghz Atom CPU, ~1GB RAM, regular Laptop HDD (no SSD). Time to time, there will be calculations, Network file transfer, and DLL function calls (all three) will be simultaneously running. Application has Timers and Socket listening components on it. My

Re: [sqlite] max_page_count wont round-trip between shell and program

> On Jul 5, 2016, at 3:18 PM, David Empson wrote: > > >> On 6/07/2016, at 8:55 AM, Ward WIllats wrote: >> >>> I have noticed that when I set max_page_count programatically to 16384 and >>> read it back with the shell I get 1073741823. >>> If I

Re: [sqlite] Currency & SQLite

On 2016-07-05 3:02 PM, Ertan Küçükoğlu wrote: I am using Delphi 10 for programming. Current variables are defined as Double (8 bytes real), saved in Database using something "DataSet.FieldByName('Amount').AsFloat := My_double_variable" However, I am now considering to convert all Double

Re: [sqlite] max_page_count wont round-trip between shell and program

> On 6/07/2016, at 8:55 AM, Ward WIllats wrote: > >> I have noticed that when I set max_page_count programatically to 16384 and >> read it back with the shell I get 1073741823. >> If I set max_page_count with the shell to 16384 and read it back >> programmatically,

Re: [sqlite] Currency & SQLite

Hello Darren, Thanks for your suggestions. Sorry, my e-mail client is not capable of indenting messages the way yours does. Just bear with my e-mails, please. I am communicating with a device which actually prints commercial receipt. That device is already confirmed by Ministry of Finance.

Re: [sqlite] Currency & SQLite

Hello Ertan, On 2016-07-05 1:59 PM, Ertan Küçükoğlu wrote: I have following data to store: My currency values only has 2 decimal digits. (Sample: 1.23) My amount values goes around 5-6 decimal digits. (Sample: 1.123456) So what do the 2 fields actually represent? Are Amount and Money both

Re: [sqlite] max_page_count wont round-trip between shell and program

> On 2016/07/05 10:50 PM, R Smith wrote: > The page size of the DB doesn't actually change until you repack it (unless > it is new) - I think. > > Try the test running "VACUUM;" after setting the page size to repack the DB > in that page size and so make it stick outside of the current

[sqlite] Currency & SQLite

Hi, I read on the web, but cannot be sure about it. So, question goes here. I have following data to store: My currency values only has 2 decimal digits. (Sample: 1.23) My amount values goes around 5-6 decimal digits. (Sample: 1.123456) If I am to use below SQL command: CREATE

Re: [sqlite] max_page_count wont round-trip between shell and program

Actually - this looks more like a big-endian problem... 1073741823 is exactly 4-bytes left shifted from 16384. So you are setting/reading the high order bytes of a 64-bit field in stead of the low-order bytes. On 2016/07/05 10:50 PM, R Smith wrote: The page size of the DB doesn't actually

[sqlite] max_page_count wont round-trip between shell and program

> I have noticed that when I set max_page_count programatically to 16384 and > read it back with the shell I get 1073741823. > If I set max_page_count with the shell to 16384 and read it back > programmatically, the program gets back 1073741823. > Both the program and the shell can round-trip

Re: [sqlite] max_page_count wont round-trip between shell and program

The page size of the DB doesn't actually change until you repack it (unless it is new) - I think. Try the test running "VACUUM;" after setting the page size to repack the DB in that page size and so make it stick outside of the current connection. On 2016/07/05 10:43 PM, Ward WIllats wrote:

[sqlite] max_page_count wont round-trip between shell and program

I have noticed that when I set max_page_count programatically to 16384 and read it back with the shell I get 1073741823. If I set max_page_count with the shell to 16384 and read it back programmatically, the program gets back 1073741823. Both the program and the shell can round-trip their own

Re: [sqlite] SQLite Logo

The current SQLite logo is several years old. The Apache Foundation's vertical feather logo is very new (less than a year, IIRC). Perviously the ASF logo was a horizontal feather. So the correct question is, "Why is the Apache logo basically the same as the SQLite logo?" -j On Tue, Jul 5,

Re: [sqlite] SQLite Logo

On 2016/07/05 9:30 PM, Zsbán Ambrus wrote: On Fri, Jun 24, 2016 at 2:03 PM, R.A. Nagy wrote: I am putting together a commercial training for SQLite. I would like to use the SQLite logo - as seen on the website - on the cover of the materials. SQLite has a logo... wow.

Re: [sqlite] SQLite Logo

On Fri, Jun 24, 2016 at 2:03 PM, R.A. Nagy wrote: > I am putting together a commercial training for SQLite. I would like to use > the SQLite logo - as seen on the website - on the cover of the materials. SQLite has a logo... wow. I didn't notice that before. I just

Re: [sqlite] replace "\n" with nothing

Thank you! Worked! Roman From: sqlite-users-boun...@mailinglists.sqlite.org [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of R Smith [rsm...@rsweb.co.za] Sent: Tuesday, July 05, 2016 3:13 PM To: sqlite-users@mailinglists.sqlite.org Subject:

Re: [sqlite] replace "\n" with nothing

replace(columname, char(10), ''); Sometimes, depending on your OS's interpretation of '\n', it might actually be char(13)+char(10) or such (that's hex 0x0D and 0x0A). Get the HEX() from such a line to be sure. On 2016/07/05 9:00 PM, Roman Fleysher wrote: Dear SQLiters, I made a mistake

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

On Tue, Jul 5, 2016 at 4:46 PM, Dobrean, Adrian wrote: > I am unable to turn off journal for vfs (I am using SQLite version 3.8.7.2). > I am not getting any error and the journal mode does not get set (i.e. to > PAGER_JOURNALMODE_OFF). > Any idea what am I doing wrong?

[sqlite] replace "\n" with nothing

Dear SQLiters, I made a mistake and inserted a new line char, "\n" in the middle of a text. I now would like to replace it with nothing. Something like: replace(columnName, '\n','') But this will interpret "\n" literally, as two symbols. How do I do it? Thank you, Roman

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

On 2016/07/05 5:18 PM, Dobrean, Adrian wrote: My understanding is that as result of this command " PRAGMA journal_mode = off" the journal mode should get set to "PAGER_JOURNALMODE_OFF". However in my case even though I get no error and the journal_mode stays set to "0" instead of

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

Please try https://www.sqlite.org/src/info/2683b375ad129117 and verify that the changes on trunk are working. Thanks. On 7/5/16, Nick Wellnhofer wrote: > On 05/07/2016 17:15, Richard Hipp wrote: >> On 7/5/16, Nick Wellnhofer wrote: >>> No, this doesn't

[sqlite] Extending Porter Tokenizer

Hi, I'm wondering if it is possible to extend the functionality of the porter tokenizer. I would like to use the functionality of the Porter tokenizer but before stemming the token, I want to decide whether the token should be stemmed or not. Do I need to copy the Porter tokenizer and modify it

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 05/07/2016 17:15, Richard Hipp wrote: On 7/5/16, Nick Wellnhofer wrote: No, this doesn't fix my problem. The check-in only changes the "#ifdef YYERRORSYMBOL" branch which I don't define. But if I add the change to the "YYERRORSYMBOL is not defined" branch as well,

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

I am not sure if this is relevant but sqlite3_prepare_v2 build a statement with 0 columns, i.e. pVm->nResColumn = 0; Also the operation code of the prepared statement shows OP_Init (153) instead of OP_JournalMode (12). Again here you have my exec statement: " sqlite3_exec(ddDB, "PRAGMA

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

My understanding is that as result of this command " PRAGMA journal_mode = off" the journal mode should get set to "PAGER_JOURNALMODE_OFF". However in my case even though I get no error and the journal_mode stays set to "0" instead of "PAGER_JOURNALMODE_OFF " (which is 2). Basically I need to

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 7/5/16, Nick Wellnhofer wrote: > No, this doesn't fix my problem. The check-in only changes the "#ifdef > YYERRORSYMBOL" branch which I don't define. But if I add the change to the > "YYERRORSYMBOL is not defined" branch as well, everything works as > expected. Can you

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

On 5 Jul 2016, at 4:05pm, Dobrean, Adrian wrote: > I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL. That indicates your command worked correctly. What makes you think your command is failing ? After executing PRAGMA journal_mode = off

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL. Also I forgot to mention that "/path/mysqfile" is an empty file. With best regards, Adrian Dobrean 905-315-4953 -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

Re: [sqlite] Opening a CEROD db using Python

On 7/5/16, David Lederkremer wrote: > I am trying to work with DBs and I find Python very convenient to do so, but > I could only open databases that are not encrypted/compressed. My company > has CEROD and some of the DBs were made using the CEROD extension. > Is there any

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

On 7/5/16, Dobrean, Adrian wrote: > Hi, > > I am unable to turn off journal for vfs (I am using SQLite version > 3.8.7.2). > I am not getting any error and the journal mode does not get set (i.e. to > PAGER_JOURNALMODE_OFF). Maybe you could tell us what the error is? >

[sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

Hi, I am unable to turn off journal for vfs (I am using SQLite version 3.8.7.2). I am not getting any error and the journal mode does not get set (i.e. to PAGER_JOURNALMODE_OFF). Any idea what am I doing wrong? (it used to work in 3.7.5) " sqlite3_open_v2("/path/mysqfile", ,

Re: [sqlite] Question about C# with SQLite

DEPENDS is designed for this, displaying dependencies. It is much easier to use. https://en.wikipedia.org/wiki/Dependency_Walker http://www.dependencywalker.com/ https://support.microsoft.com/en-us/kb/256872 > -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] Opening a CEROD db using Python

I am trying to work with DBs and I find Python very convenient to do so, but I could only open databases that are not encrypted/compressed. My company has CEROD and some of the DBs were made using the CEROD extension. Is there any way I can connect to such DBs and work with them using Python?

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

No, this doesn't fix my problem. The check-in only changes the "#ifdef YYERRORSYMBOL" branch which I don't define. But if I add the change to the "YYERRORSYMBOL is not defined" branch as well, everything works as expected. Thanks for the quick response! Nick On 05/07/2016 14:48, Richard Hipp

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

Please try the latest check-in (https://www.sqlite.org/src/info/91889fa30e84760e) and let me know whether or not it clears your problem. On 7/5/16, Nick Wellnhofer wrote: > Hello, > > I hope this is right place to report Lemon issues. I ran into a problem > after > upgrading

Re: [sqlite] Question about C# with SQLite

Hi, guys, Thank you very much for your reply. Just make a conclusion, I followed the solution provided in this link, and my program could be run on any PC now. https://rashimuddin.wordpress.com/tag/sqlite-interop-dll/ But another issue comes out now, I always get this warning when build the

[sqlite] Lemon doesn't reset `yyerrcnt` after error

Hello, I hope this is right place to report Lemon issues. I ran into a problem after upgrading to the latest version of the Lemon source code from `trunk`. The following commit removed the initialization of `yyerrcnt` from the `Parse` function:

Re: [sqlite] Question about C# with SQLite

You might need something like Microsofts Process Monitor. https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx?f=255=-2147217396 I was getting similar 'red herrings' when deploying my .exe and system.data.sqlite.dll - it was moaning that it couldn't load the DLL. Indeed it

Re: [sqlite] Trigger slowness even when it's not fired

Thanks very much indeed for this. SQLite is like an onion; just when I think I’ve got to the last layer and understood it, I find there’s another layer to peel back and understand… Best wishes, Hamish > On 4 Jul 2016, at 11:08 am, Hick Gunter wrote: > > Creating a trigger