Reference for FORMAT command
in [Navision]
|
From: Dirk Biernat on 24 Jan 2006 03:03 Ok, thanks for copying the navision online help! But it seems, that it doesen't help me anymore! The only thing that I have read over, is the explanation of the Comma attribute. What's about the Overflow attribute? Any explanation? What's about my question, is it possible??? Example!?!?!? Thanks a lot! "H Ruiz (Savatage)" wrote: > Also, Format > > Use this property to define how the system formats the source expression for > various data types. > > Applies to > Text boxes, dataport fields > > Comments > The Format property can be set to a predefined format, or you can build a > format of your own. See also the FORMAT function. > > Basic Settings > To choose a predefined format, use the syntax: <Standard Format,X>, where X > is one of the entries in the Select... column of the following table: > > To use this format... Select... > Standard Display Format (the default for all data types) > 0 > > Standard Display Format 2 (edit) > 1 > > C/AL Code Constant Format > 2 > > Note you must enter the brackets < and >, as in <Standard Format,2>. > For a list of the predefined formats that are available, read the rest of > this Help topic. > > Building Formats > The Format property also lets you create your own formats. To create a > format, use the syntax described below and keep the following rules in mind: > > A format property consists of zero or more Chars, Fields or Attributes. > > Fields and Attributes are expressed with an identifier inside brackets (<>). > > Attributes must contain a comma (,) and a parameter after the identifier. > > Fields can optionally take a comma (,) and a FieldLen. > > The precise syntax is: > > FormatProperty := > [<Char> | <Field> | <Attribute>] > > <Char> := > character with ASCII value [32..255] > > <Field> := > '<' <FieldName> [',' <FieldLen>] '>' > > [, <Attribute>] > > <FieldName> := > literal name of field (format component) > > <FieldLen> := > length of field (0 or no entry means that the length is dynamic) > > <Attribute> := > ['<' <AttributeName> ',' <Char> '>'] > > <AttributeName> := > [Standard Format | Filler | 1000Character | Comma | Overflow | Filler > Character | Precision] > > Note > Comma is used to define the decimal symbol that is used, Filler and Filler > Character both mean the character that is used to fill empty spaces. > > The FieldName is a "component" that you can use to build a format > expression. Depending on the data type of the text box or dataport field, > FieldName can be chosen from this list: > > Data Type FieldNames > Decimal > Sign,Integer,Decimals,Integer Thousand > > Date > Day,Month,Month Text,Quarter,Year,Year4,Week, > > Week Year,Week Year4,Weekday,Weekday Text,Closing > > Time > Hours24,Hours12,Minutes,Seconds,Thousands,AM/PM,Second dec. > > Integer > Sign,Integer,Integer Thousand > > Boolean > Text,Number > > Option > Text,Number > > Code > Text > > Char > Char/Number,Char,Number > > Text > Text > > Example > Here are some examples of how to use the Format property: > > Choosing a standard format: > > Use the Standard Format attribute to select one of the standard formats > (these are listed at the end of this Help topic). > > For example, <Standard Format,5> will select Standard Format 5. > > Using a standard format with an attribute: > > <Precision,2:3><Standard Format,0> will use Standard Format 0 and will > format the data with a minimum of 2 and a maximum of 3 decimal places. See > also the DecimalPlaces property. If you do not specify any precision the form > will use the precision specified in the Decimal Places property of the > corresponding field in the table. > > Building a Format > > You can create your own formats by using Chars (which will be displayed > literally), Fields (to choose specific components of a value, for example the > year-part of a date) and Attributes (for example to select which character to > use as a filler). > > For example, a text box based on a source expression of the Date data type, > that uses the following format string: > > <Weekday Text>, <Month Text> <Day> > > will display the date as: Monday, April 15 > > In the following list of predefined formats, you can see many examples of > how to build formats. > > You must remember that the settings that are specified under the Regional > and Language Options in Windows determine how a number of the separators are > displayed. This applies to the time and decimal separators among others. > > The Standard Formats > The following tables list the predefined formats for each data type: > > Decimal Format Example > <Sign><Integer Thousand><Decimals> > 0 > -76,543.21 > > <Sign><Integer><Decimals> > 1 > -76543.21 > > <Sign><Integer><Decimals><1000Character,.> > 2 > -76543.21 > > <Integer Thousand><Decimals><Sign,1> > 3 > 76,543.21- > > <Integer><Decimals><Sign,1> > 4 > 761543.21- > > > For Dates, the Regional and Language Options in Windows is used to select > the actual format that is used. The table below shows the Fields that will be > used to build the various formats. This table, incidentally, corresponds to > the Regional setting for a European country. > > Date Format Example > <Closing><Day,2>-<Month,2>-<Year> > 0 > 05-04-03 > > <Closing><Day,2>-<Month,2>-<Year> > 1 > 05-04-03 > > <Day,2><Month,2><Year><Closing>D > 2 > 050403D > > <Closing><Year>-<Month,2>-<Day,2> > 3 > 03-04-05 > > <Closing><Day>. <Month Text> <Year4> > 4 > 5. April 2003 > > <Closing><Day,2><Month,2><Year> > 5 > 050403 > > <Closing><Year><Month,2><Day,2> > 6 > 6030405 > > <Day,2><Filler Character, >. <Month Text,3> <Year4> > 7 > 5. Apr 2003 > > > The table below shows how these formats will change if the Regional and > Language Options is "United States." > > US Date Format Example > <Closing><Month,2>/<Day,2>/<Year> > 0 > 04/05/03 > > <Closing><Month,2>/<Day,2>/<Year> > 1 > 04/05/03 > > <Month,2><Day,2><Year><Closing>D > 2 > 040503D > > <Closing><Year>/<Month,2>/<Day,2> > 3 > 03/04/05 > > <Month Text> <Closing><Day>, <Year4> > 4 > April 5, 2003 > > <Closing><Month,2><Day,2><Year> > 5 > 040503 > > <Closing><Year><Month,2><Day,2> > 6 > 030504 > > > For Times, the Regional and Language Options in Windows are used to select > the actual format used. The table below shows the Fields that will be used to > build the various formats. This table, incidentally, corresponds to the > Regional setting for a European country. > > Time Format Example > <Hours24,2>.<Minutes,2>.<Seconds,2> > 0 > 4.35.55 > > <Hours24>.<Minutes,2>.<Seconds,2><Second dec.> > 1 > 4.35.55.553 > > <Hours24,2><Filler Character,0><Minutes,2><Seconds,2> <Second dec.><Comma,.>T > 2 > 043555.553T > > > The next table shows how these time formats will appear if the Regional > setting is changed to "United States." > > US Time Format Example > <Hours12,2>:<Minutes,2>:<Seconds,2><Second dec.> <AM/PM> > 0 > 4:35:55 AM > > <Hours12>:<Minutes,2>:<Seconds,2><Second dec.> <AM/PM> > 1 > 4:35:55.553 AM > > <Hours24,2><Filler Character,0><Minutes,2><Seconds,2> <Second dec.><Comma,.>T > 2 > 043555 .553T > > > > > > Integer Format Example > <Sign><Integer> > 0 > -567 > > <Sign><Integer> > 1 > -567 > > <Sign><Integer> > 2 > -567 > > > > > > Boolean Format Example > <Text>
From: H Ruiz (Savatage) on 24 Jan 2006 16:16 I copied the online help because you would be surprised about how many people do not use that as a first reference.
From: Dirk Biernat on 25 Jan 2006 01:38 I'm not very surprised, but I did it of course! Any other ideas??? "H Ruiz (Savatage)" wrote: > I copied the online help because you would be surprised about how many people > do not use that as a first reference.
From: H Ruiz (Savatage) on 25 Jan 2006 11:38
As far as the "Overflow" is concerned all I know is <AttributeName> := [Standard Format | Filler | 1000Character | Comma | Overflow | Filler Character | Precision] 14 significant digits are supported. If a server returns a number with more digits, an overflow error will occur at runtime. Perhaps the Overflow allow you to set a different # other than 14 - Just a Guess Tho. |