Hi,
I DBISAM there use to be a Currency field type which respect the Delphi's predefined variables (Windows regional settings) like:

CurrencyString, CurrencyDecimals, and ThousandSeparator.  How to implement that with EDB?  In other words, what field type should I use to
force that field to respect those variables?  Since nobody asked this question before I would expect the answer to be very simple but never
lucky to figure it out myself

Abdulaziz,

<< How to implement that with EDB? >>

Same way - nothing has changed in EDB with respect to how the Delphi TField
components are edited and/or displayed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Same way - nothing has changed in EDB with respect to how the Delphi TField
components are edited and/or displayed.>>

What do you mean?  After migrating a DBISAM3 to EDB database all the currency fields became FLOAT and they don't respect the currency
settings any more!

Tim,

Let me rephrase my question again.  How to make a currency field in a memory table that is created during run-time (CREATE TABLE...)?

Abdulaziz,

the difference is just the formatting of the edit-field or whatever you
use to display the currency value.
If you add the fields to a TEDBTable component e.g., you can set the
property "DisplayFormat" to

,0.00 ¤

That will format the float value properly.

Regards Uli

Uli

<<the difference is just the formatting of the edit-field or whatever you
use to display the currency value.
If you add the fields to a TEDBTable component e.g., you can set the
property "DisplayFormat" to>>

Thanks for the reply.  However, what if the field is connected to a component?

Abdulaziz


Something like

CREATE TABLE xxx ADD COLUMN Money DECIMAL(20,4)
or
CREATE TABLE xxx ADD COLUMN Money DECIMAL(20,2)

Roy Lambert [Team Elevate]

Roy,


<<Something like

CREATE TABLE xxx ADD COLUMN Money DECIMAL(20,4)
or
CREATE TABLE xxx ADD COLUMN Money DECIMAL(20,2)>>

Now this works fine.  It was much easier with DBISAM.  But at least this will solve the issue.  Big thanks to you.  

Roy,

Money is not a field type in EDB.  You probably mean:

CREATE TABLE xxx ADD COLUMN Float DECIMAL(20,4);

Aren't you?

Abdulaziz


I used Money as the field name DECIMAL is the type.

I'd really recommend against using column types as column names which is what you'd do with your example.

Roy Lambert [Team Elevate]