If i change a firld from to a numeric within Farcry the length for the column is 5, in the detail panel the precision is 4 and scale is 0 allowing integers of upto 4 digits.
There is a difference when creating or changing a field type.
What i need to do create a field that can contain a currency value, with at least 2 decimal places. Can I set up this data type from Farcry? MS SQL. MS SQL has a data type of "currency" or "float", but i can not set these datatype from withing Farcry.
Chris.
Tom Cornilliac wrote:
Hmmm....What you want (and should have) is numeric(5). Take a look at the suspect table in design view. What is the length for the column in question?
~tom
-----Original Message-----
From: Chris Kent [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 13, 2004 3:25 PM
To: FarCry Developers
Subject: [farcry-dev] Re: Extended dmProfile to include aObjectIDs for- new custom type
Tom,
Thanks, but this does not appear to work for me. It gives me a db field that will accept a 9 digit number. If amending a field this is a 4 digit number. No decimals.
What I need is to be able to enter a currencry value, +ve and -ve with at least 2 decimal places.
Chris.
Tom Cornilliac wrote:
One thing I have not been able to do is add a decimal/float data typewhen creating custom types or extending a core type, I need to add acurrency field.Just use type="numeric"For MSSQL, Fourq will user the MSSQL Numeric data type. Numeric isfunctionally equivalent to Decimal in MSSQL. Valid values are from - 10^38+1 through 10^38 - 1---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
