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
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
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
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:
>
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
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
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
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
8 matches
Mail list logo