DW how RMB symbol-CodePudding

I want to show in the unit price and amount in the DW RMB symbols, and in accordance with the 000000000.00 such format, could you tell me how to set the can?

CodePudding user response:

The format Settings \ $000000000.00

CodePudding user response:

Show Settings, enter 1,

CodePudding user response:

The column that will be the unit price controls width widened a bit, it is left aligned so most the right side shows don't come out

CodePudding user response:

Pull some wide, and he can set the right alignment, but input after 20 or so,

CodePudding user response:

Very strange, didn't meet you of that kind of situation

CodePudding user response:

reference 4 floor vipkevin003 response:

pull some wide, and he can set the right alignment, but input after 20 or so,

Your unit price and amount of the two string/char type of column?

CodePudding user response:

Is the Char type

And what I want is, if the input 1, then it is converted to RMB 1.00, enter 1000, converted into RMB 1000.00, such effect,

CodePudding user response:

refer to 7th floor vipkevin003 response:

is the Char type

And what I want is, if the input 1, then it is converted to RMB 1.00, enter 1000, to $1000.00, such effect,

Are less likely to get the char type
First of all input may not be the correct numerical format;
If the format is correct then turn dec first, and then the format

Simple way to change the type to dec type, then directly set the format to \ $#, # # 0.00

CodePudding user response:

refer to the eighth floor SDHP response:

Quote: refer to 7th floor vipkevin003 response:

Is the Char type

And what I want is, if the input 1, then it is converted to RMB 1.00, enter 1000, to $1000.00, such effect,

Are less likely to get the char type
First of all input may not be the correct numerical format;
If the format is correct then turn dec first, and then the format

Simple way to change the type to dec type, then directly set the format to \ $#, # # 0.00 line

I try to this change, but not changed the value type to a decimal type:

CodePudding user response:

references 9 f vipkevin003 response:

Quote: refer to the eighth floor SDHP response:

Quote: refer to 7th floor vipkevin003 response:

Is the Char type

And what I want is, if the input 1, then it is converted to RMB 1.00, enter 1000, to $1000.00, such effect,

Are less likely to get the char type
First of all input may not be the correct numerical format;
If the format is correct then turn dec first, and then the format

Simple way to change the type to dec type, then directly set the format to \ $#, # # 0.00 line

I try to this change, but not changed the value type to a decimal type:

Change the database field in the first, and then regenerate the data window

CodePudding user response:

Cannot use the char types, this format for numeric effectively

CodePudding user response:

11 references laoer_2002 response:

cannot use the char types, this format for numeric effective

After I put that into a Decimal, suggesting there is an error, this can be how to change?

CodePudding user response:

To regenerate the dw

CodePudding user response:

Create a new, is still the same Char types,

CodePudding user response:

Can try the following two methods:
1. The table fields into a decimal data type, and then in the datawindow set format='$0.00' # # # # # # #
2. Do not change the field of the Char types, directly set the format in the datawindow='$@ @ @ @ @ @'

CodePudding user response:

reference 15 floor xiajinxian response:

can try the following two methods:
1. The table fields into a decimal data type, and then in the datawindow set format='$0.00' # # # # # # #
2. Do not change the field of the Char types, directly set the format in the datawindow='$@ @ @ @ @ @

The first method don't know how to change, the second method with the Update, will change the data submitted to the database, after may not submit them,