我有一个计算字段,其格式指定如下 -
#,##0.00;[RED](#,##0.00);#
按格式,我的意思是我们可以从计算字段的属性设置的格式值(在格式选项卡中)。
这种格式是什么意思?
I have a computed field, whose format is specified as follows -
#,##0.00;[RED](#,##0.00);#
By format, I meant the format value that we can set from the property of the computed field(in the format tab).
What does this format mean?
最满意答案
format属性最多可包含4个单独的格式字符串,以分号分隔。 只需要一个。 这些格式适用于数字:
正格式;负数格式;零格式;零格式
对于其他数据类型(字符串,日期,时间......):
非无效格式;零格式
我假设这是分开的分号列表,它会让你失望。 如果您需要有关每个单独格式字符串元素的帮助,请回复评论并将其编辑,但我怀疑您会在帮助文件(.HLP)中更快地找到所需内容。 (本主题位于用户指南中,它应作为CHM文件在您的系统上,在PowerBuilder程序组中作为“编译的HTML帮助文件”,这实际上是另一个单独的格式字符串被很好地覆盖的地方。它也可以在线获得来自Sybase 。)
祝你好运,
特里
The format property can contain up to 4 individual format strings, separated by semicolons. Only one is required. These formats are for numbers:
Positive-format;negative-format;zero-format;null-format
For other data types (string, date, time...):
Non-null-format;null-format
I'm assuming it's the semi-colon separated list that's throwing you off. If you need help with the elements of each individual format string, comment back and I'll edit it in, but I suspect you'll find what you need faster in the help file (.HLP). (This topic is in the Users Guide, which should be on your system as a CHM file, in the PowerBuilder program group as "Compiled HTML help file", which actually is another place individual format strings are covered pretty well. It's also available online from Sybase.)
Good luck,
Terry
更多推荐
发布评论