[sqlite] Compile error with certain compile time options

e them compiled in, but cannot be sure what option I can use to disable. Any help is appreciated. Thanks & regards, Ertan Küçükoğlu ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 on WinCE platform

>From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >Behalf Of Simon Slavin >Sent: Monday, December 11, 2017 12:50 PM >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: Re: [sqlite] SQLite3 on WinCE platform > >On 11

[sqlite] SQLite3 on WinCE platform

he problem is/might can help me out. Thanks & regards, Ertan Küçükoğlu ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Searching sqlite3dll for WinCE 5.2 aka Windows Embedded Handheld 6.5 Classic

y help is appreciated. Thanks. Regards, Ertan Küçükoğlu ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] running queries on attached database tables

is it enough to call below SQL? Select * from Table3 Or, even if there is no table names that overlap on each other, Do I still need to run something as follows: Select * from source.Table3 Thanks. Ertan Küçükoğlu ___ sqlite-users mailing list

[sqlite] SQL help on preparing a report

It doesn't need to be a single SQL. Running several SQL statements is not a problem at all. However, I do not want to deal with 10s of SQL statements if it can be done for example with only 3. It will be something as 10s of statements If I am to deal with it using my own kno

Re: [sqlite] insert into not inserting float values as expected

Of Ertan Küçükoğlu Sent: Saturday, July 16, 2016 12:32 PM To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] insert into not inserting float values as expected Hello, I have below table definitons: CREATE TABLE IF NOT EXISTS FIS( ID I

[sqlite] insert into not inserting float values as expected

t,IndirimliBirimFiyat, PromosyonBirimFiyat,BirimFiyat, Kasiyer,OturumID Result in fisyazdir is something like: Barkod Miktar BirimFiyat Tutar 1005 2 6.5 13 1005 -1 6 -6.5 I expected BirimFiyat to be 6.5, but it is not. Is it me doing something wrong? I cannot understan

Re: [sqlite] Currency & SQLite

al Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Darren Duncan Sent: Wednesday, July 6, 2016 1:20 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Currency & SQLite On 2016-

Re: [sqlite] Currency & SQLite

something wrong with SQLite field definitions, today. Application is about 95% complete as to interaction with database. Unfortunately, converting everything in the application code to use Cents instead of Dollars might introduce me quite a good number of bugs. Regards, Ertan Küçükoğlu ---

[sqlite] Currency & SQLite

. One thing I cannot do in my case is to store money values as integers multiplied by 100. I appreciate all advises. Thanks. Ertan Küçükoğlu ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org

Re: [sqlite] Finding a single row

Hi Simon, Two or more rows return is an error on user definition. I will popup a message in this case. Thanks for the example, I didn't know <= can be used also for strings. Regards, Ertan Küçükoğlu -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sql

[sqlite] Finding a single row

SBDE 8694 125 Complete card number may be something like: SB1 SA25 SA325 SB1054 SAA23 86941005 12504 Below didn't work for me because complete card number is longer, and I do lack SQL knowledge: select * from FIYATKODLARI where Kodu like 'SB1%' Any help is appreciated. Thanks. Ertan Küçükoğlu

[sqlite] WITHOUT ROWID

Hello, I wonder if there are any drawbacks/things to be aware of, etc. for tables created "WITHOUT ROWID". I am considering using such tables in another project. Thanks. Regards, Ertan K???ko?lu

[sqlite] Is it faster with descending index

I prepared a test application on Windows. Used sqlite 3.12.2 32bit DLL. - Just one table in a database. - Database1, Table created with below SQL and second database I included WITHOUT ROWID at the end when creating the test table. - Application filled in 500.000 random value generated records

[sqlite] Is it faster with descending index

Hi, I am using SQLite version 3.9.2 on WinCE devices. I have below table in one of my databases. Table sometimes holds 1.5 to 3 million records in it. That database is reached for read-only purposes and created from scratch in a PC if its contents needs to be updated. All database files,