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

[Tom Cornilliac]

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