n is the precision. It is important to know how many digits store else the db does not know how long the field should be. Are you going to handle more than one trillion?
On Nov 3, 9:41 pm, Pystar <[email protected]> wrote: > I would like some clarification on the Decimal type field in DAL. From > the book, in the complete signature for Decimal type is "decimal(n,m)" > where; > n -- total number of digits > m -- total number of digits after the decimal point > if I am to specify a decimal type field that has 4 digits after the > decimal place how would I specify that? since I cant really determine > before hand how many digits in total the decimal number would contain. > > Would specifying the field as "decimal(, 4)" work i.e. leave out the > "n" value ? or is there something I am not getting? > > Thanks for your swift response. > Pystar
