Re: [sqlite] [EXTERNAL] Compiling SQLite without the database storage?

2019-12-22 Thread Hick Gunter
No. You need the BTree and table code to handle the sqlite3_master table. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Jens Alfke Gesendet: Samstag, 21. Dezember 2019 19:50 An: SQLite mailing list Betreff: [EXTERNAL]

Re: [sqlite] No such column

2019-12-22 Thread Keith Medcalf
On Sunday, 22 December, 2019 23:20, Aydin Ozgur Yagmur wrote: >I have experienced a weird problem. I have been using sqlite database in >linux by mounting. >Nearly all times it works well. But when testing with customer, I >encounter >"No such column" error. After restarting system, it works

[sqlite] No such column

2019-12-22 Thread Aydin Ozgur Yagmur
Hello, I have experienced a weird problem. I have been using sqlite database in linux by mounting. Nearly all times it works well. But when testing with customer, I encounter "No such column" error. After restarting system, it works again well. I wonder why I get such an error? Could you please

Re: [sqlite] Can one uses the avg(X) function to calculate a few results of View's?

2019-12-22 Thread Simon Slavin
On 22 Dec 2019, at 8:43pm, Csanyi Pal wrote: > I can easily create a View to see my expenses between two dates, but how > could I create such a View in which I can see the average of my expenses by > using my Views that I earlier created? A view acts like a tablee. If you can figure out a

[sqlite] Can one uses the avg(X) function to calculate a few results of View's?

2019-12-22 Thread Csanyi Pal
Hi, I have a small sqlite database in which I enter my expenses and incomes,for a couple of months now. So I want to do some calculations during this period of time, like how many spend I between two dates in a month, or in a two consecutive months. I can easily create a View to see my

Re: [sqlite] RBU fails as of checkin f84a1539 - fixed

2019-12-22 Thread Keith Medcalf
I get: RBU error: near ")": syntax error ERROR 1, expected 101 Done - Press ENTER to exit. with the current trunk ... -- 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 On

[sqlite] RBU fails as of checkin f84a1539 - fixed

2019-12-22 Thread Ralf Junker
Replying to myself just to confirm that https://www.sqlite.org/src/info/0b9d8a1202c4220f fixes the problem. Thank you, Dan! Ralf On 20.12.2019 17:48, Ralf Junker wrote: As of Fossil checkin f84a1539, the RBU code in the following C example is no longer executed to completion. Instead, an