Web 兼容性检查：支持的表达式

Access > Access Services

 

Web 兼容性检查：支持的表达式

通过替换兼容性检查器在 Web 兼容性问题表中标识为问题的表达式，您可以解决与表达式相关的兼容性检查器错误。

在 Web 数据库中，有十种可在其中使用表达式的不同上下文。并非所有表达式都适用于每一种上下文。

本文列出了 Web 数据库的各种上下文中支持的表达式。这些表达式按照上下文和每种上下文中的函数类型来分组。使用这些表达式可以替换兼容性检查器标识的表达式。

表达式上下文

hrefIcon_ZA10069439 常规访问

hrefIcon_ZA10069439 计算列

hrefIcon_ZA10069439 限制

hrefIcon_ZA10069439 查询列

hrefIcon_ZA10069439 UI 宏

hrefIcon_ZA10069439 数据宏

hrefIcon_ZA10069439 默认

hrefIcon_ZA10069439 有效性验证

hrefIcon_ZA10069439 表单

hrefIcon_ZA10069439 报表

常规访问

Web 数据库的常规访问上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

计算列

Web 数据库的计算列上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

限制

Web 数据库的限制上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

查询列

Web 数据库的查询列上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

UI 宏

Web 数据库的 UI 宏上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

数据宏

Web 数据库的数据宏上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

默认

Web 数据库的默认上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

有效性验证

Web 数据库的有效性验证上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

表单

Web 数据库的表单上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍Datevalue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

嵌套函数

✍Log(Cos(1)+Exp(1))
✍Log(Sqr(Fix(1)))
✍Log(Sqr(Fix(Sgn(1))))
✍Log(Sqr(Fix(Sgn(Sqr(1)))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))
✍Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))
✍Round(Exp(1),Exp(2))
✍Round(Exp(Abs(1)),Exp(Abs(2)))
✍Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))
✍Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))
✍Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))
✍Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

 

TopPageIcon_CLV 返回页首

报表

Web 数据库的报表上下文中允许下列表达式。

日期/时间

✍Date
✍Date$
✍Dateserial
✍DateValue
✍Day
✍Minute
✍Hour
✍Month
✍MonthName
✍Now
✍Second
✍Time
✍Time$
✍Timeserial
✍WeekdayName
✍Weekday
✍Year
✍Timevalue

财务

✍Ddb
✍Fv
✍Ipmt
✍Nper
✍Pmt
✍Ppmt
✍Pv
✍Rate
✍Sin
✍Syd
✍NPV

 

检查

✍Isnull
✍Isempty
✍Isnumeric
✍Null
✍Nz
✍Updated

 

数学

✍Abs
✍Atn
✍Cos
✍Exp
✍Fix
✍Int
✍Log
✍Round
✍Sgn
✍Sin
✍Sqr
✍Tan

 

运算符

✍-
✍*
✍/
✍^
✍+
✍<
✍<=
✍<>
✍=
✍>=
✍And
✍Or
✍Mod
✍Not
✍&

 

程序流程

✍Choose
✍Iif

 

文本

✍Asc
✍Lcase
✍Lcase$
✍Left
✍Left$
✍Len
✍Mid
✍Mid$
✍Right
✍Right$
✍Space
✍Space$
✍Ucase
✍Ucase$
✍Trim
✍Trim$
✍String
✍String$
✍Replace
✍PlainText
✍Instr

 

转换

✍Str
✍Str$
✍Hex
✍Hex$
✍Oct
✍Oct$

 

聚合函数

✍Avg
✍Count
✍Max
✍Min
✍StDev
✍StDevP
✍Sum
✍Var
✍VarP

 

域聚合函数

✍DAvg
✍DCount
✍DFirst
✍DLast
✍DLookup
✍DMax
✍DMin
✍DStDev
✍DStDevP
✍DSum
✍DVar
✍DVarP

 

文字

✍System.Title
✍System.Size
✍System.IsFlagged

 

自定义

✍CurrentWebUser
✍CurrentWebUserGroups
✍IsCurrentWebUserInGroup
✍Like
✍In

 

TopPageIcon_CLV 返回页首

 

索引页    专业培训与服务: Access中级培训 | Access高级培训 | Access顶级培训 | 软件定制开发 | 通用开 发平台 | Office插件 © by Office中国