[farcry-dev] Re: Extended dmProfile to include aObjectIDs for new custom type

[Tom Cornilliac]

Ah...Well that would be a problem. You need at least a scale of 2.  It looks like there may be an issue with the way numeric is being deployed in Fourq. Let me take a look at the code and I'll get back to ya.   -----Original Message----- From: Chris Kent [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 2:44 AM To: FarCry Developers Subject: [farcry-dev] Re: Extended dmProfile to include aObjectIDs for- new custom type   If i create a new field as numeric within Farcry the length for the column is 9,  in the detail panel the precision is 18 and scale is 0 allowing integers of upto 18 digits. 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 type when creating custom types or extending a core type, I need to add a currency field.       Just use type="numeric"   For MSSQL, Fourq will user the MSSQL Numeric data type. Numeric is functionally 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 --- 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