[sqlite] No such column error

I have been developing a c++ program in windows. In this program, in a loop, I open database, query and update the records then close it. I am encountering randomly with "No such column error". Query looks like that (but there are more columns than this STATUS table): "select a.BIRTH_DATE,

Re: [sqlite] No such column

2019 at 12:45 PM Darren Duncan wrote: > On 2019-12-22 10:48 p.m., Keith Medcalf wrote: > > On Sunday, 22 December, 2019 23:20, Aydin Ozgur Yagmur < > ayagmu...@gmail.com> wrote: > >> I have experienced a weird problem. I have been using sqlite database in > >>

Re: [sqlite] No such column

Thank you very much Simon, it is quite explicative. On Mon, Dec 23, 2019 at 11:38 AM Simon Slavin wrote: > On 23 Dec 2019, at 6:19am, Aydin Ozgur Yagmur wrote: > > > I have been using sqlite database in linux by mounting. > > Nearly all times it works well. But when testin

[sqlite] No such column

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] Multiple files for a single SQLite database

Oh, I found the answer. SQLITE_MAX_ATTACH should be changed. On Thu, Oct 31, 2019 at 2:40 PM Aydin Ozgur Yagmur wrote: > How can it be raised to 125? > I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED, > 125)" but there is no effect. > I still

Re: [sqlite] Multiple files for a single SQLite database

How can it be raised to 125? I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED, 125)" but there is no effect. I still get "too many attached databases" exception. On Wed, Oct 30, 2019 at 5:01 PM David Raymond wrote: > "There's a limit, somewhere around ten, I think.

[sqlite] Multiple files for a single SQLite database

SQLite stores a single database in a single file. According to the specific project requirements and due to the performance concerns; When working with large databases, is it possible to explicitly tell SQLite not to store the whole DB in a single file and store different tables in different

[sqlite] LIKE operator and collations

Hello, I want to use custom collations for "like" and "not equals" queries. *select * from tbl_internal where col_internal like 'ç%' collate TURKISH_CI;* it is ok for "equals" operator. *select * from tbl_internal where col_internal = 'çç' collate TURKISH_CI;* but not ok, for "like" and "not

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

ht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Aydin Ozgur Yagmur > Gesendet: Dienstag, 11. Dezember 2018 14:20 > An: SQLite mailing list > Betreff: Re: [sqlite] [EXTERNAL] Transaction commits hangs up > > *Ist hat always the

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

No, I did not use it. On Tue, Dec 11, 2018 at 3:59 PM Simon Slavin wrote: > On 11 Dec 2018, at 12:42pm, Aydin Ozgur Yagmur > wrote: > > > I am trying to edit the database using command shell. > > for instance i try to execute analyze commad i get "database is locked

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

t about the thread? Can you check what the > thread is doing with a debugger? Ist hat always the same location or is it > maybe running in a loop? Is it always the same statement that "hangs"? > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

at it is hanging and that the database is locked? > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Aydin Ozgur Yagmur > Gesendet: Dienstag, 11. Dezember 2018 11:31 > An: SQLite mailing list > Betreff: Re: [sqlite]

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

] > Im Auftrag von Aydin Ozgur Yagmur > Gesendet: Dienstag, 11. Dezember 2018 09:53 > An: SQLite mailing list > Betreff: [EXTERNAL] [sqlite] Transaction commits hangs up > > I have been using sqlite3.8.11 on fat32 file system. Sometimes, while > committing a transaction commit pro

[sqlite] Transaction commits hangs up

I have been using sqlite3.8.11 on fat32 file system. Sometimes, while committing a transaction commit process hangs up and database became locked. I am trying to find a cause or a solution for this problem. Does anyone encounter with similar problem before? Do you have any suggestion or any idea

Re: [sqlite] Sqlite delete slow in 4GB

tive effects of "autovacuum=incremental" solution? I did not see too much positive comment on it. Thanks for your help, On Wed, Jun 6, 2018 at 1:10 PM, Eduardo wrote: > On Wed, 6 Jun 2018 12:06:15 +0300 > Aydin Ozgur Yagmur escribió: > > > Thank you very quick response. &g

Re: [sqlite] Sqlite delete slow in 4GB

te cascade deferrable initially deferred) CREATE UNIQUE INDEX UQC_ANH_TYPE on ANHXT( ANH_TYPE)CREATE UNIQUE INDEX UQC_ANP_SEGMENTNO_ANAHTARID on PRCXT( ANP_SEGMENTNO,ANH_PRC_id)CREATE INDEX findex on PRCXT( ANH_PRC_id) On Wed, Jun 6, 2018 at 11:42 AM, Karl Billeter wrote: > On Wed, Jun 06, 2018 a

[sqlite] Sqlite delete slow in 4GB

I have been using fat32 file system. I have a database which has 4 GB size. Database consist of 1 parent table and 1 child table. Parent table has 10 rows and child table has 4000 rows. 1 row of child table has 1 MB size. There are unique indexes on the tables. When I delete a row in parent