rules.html

来自「《VB6数据库开发指南》所有的例程的源码」· HTML 代码 · 共 56 行

HTML
56
字号
<html>
<head>
<title>Rules for Tables in the School Database</title>
<body bgcolor="#FFFFEE">
<h1>Business Rules</h1>
<pre>
Advisors
  AdvGradeLevel
    Required
    Rule
      IN ('Freshman', 'Sophomore', 'Junior', 'Senior')
    Text
      Grade level must be Freshman, Sophomore, Junior, or Senior

Courses
  CourseDesc
    Required

Faculty
  FacFirst
    Required
  FacLast
    Required

Instructors
  n/a

Students
  StFirst
    Required
  StLast
    Required
  Table
    Rule
      IIf(
          (
            (Not IsNull(StAddress)) Or 
            (Not IsNull(StCity)) Or 
            (Not IsNull(StState)) Or 
            (Not IsNull(StZIP))
          ), 
          (
            (Not IsNull(StAddress)) And 
            (Not IsNull(StCity)) And 
            (Not IsNull(StState)) And 
            (Not IsNull(StZIP))
          ), 
          True
        )
    Text
      If provided, the address must be complete.
    Note: Because you can enter only a single expression, this must be 
          constructed using IIf statements.
</pre>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?