Re: [sqlite] Currency & SQLite

2016-07-05 Thread Cory Nelson
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 values, and I will retrieve e

Re: [sqlite] Currency & SQLite

2016-07-05 Thread J Decker
racy to use >> Currency (8 bytes fixed-point data type) in my application for Price and >> Total fields, leave Amount field as Double? >> >> Thanks. >> >> -Original Message- >> From: sqlite-users-boun...@mailinglists.sqlite.org [mailto: >> sqlit

Re: [sqlite] Currency & SQLite

2016-07-05 Thread Darren Duncan
ite mailing list Subject: 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_do

Re: [sqlite] Currency & SQLite

2016-07-05 Thread Ertan Küçükoğlu
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 Subject: Re: [sqlite] Currency & SQLite On 2016-07-05 3:02 PM, Ertan Küçükoğlu wrote: >

Re: [sqlite] Currency & SQLite

2016-07-05 Thread Darren Duncan
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 datatyp

Re: [sqlite] Currency & SQLite

2016-07-05 Thread Ertan Küçükoğlu
rds, Ertan Küçükoğlu -Original 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 12:21 AM To: SQLite mailing list Subject: Re: [sqlite] Currency & SQLite Hel

Re: [sqlite] Currency & SQLite

2016-07-05 Thread Darren Duncan
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 a

[sqlite] Currency & SQLite

2016-07-05 Thread Ertan Küçükoğlu
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 TABLE