📄 dataenvironment1.dsr
字号:
CommandText = "SELECT MatricNumber, LastName, FirstName, Department, tblLevel, Sex FROM StudentInfo WHERE Sex = 'Female'"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command9_Grouping"
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "MatricNumber"
Caption = "MatricNumber"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "LastName"
Caption = "LastName"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "FirstName"
Caption = "FirstName"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "tblLevel"
Caption = "tblLevel"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Sex"
Caption = "Sex"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset11
CommandName = "Command10"
CommDispId = 1068
RsDispId = 1072
CommandText = "SELECT MatricNumber, LastName, FirstName, Department, tblLevel, Special FROM StudentInfo WHERE Special = -1"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command10_Grouping"
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "MatricNumber"
Caption = "MatricNumber"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "LastName"
Caption = "LastName"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "FirstName"
Caption = "FirstName"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "tblLevel"
Caption = "tblLevel"
EndProperty
BeginProperty Field6
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "Special"
Caption = "Special"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset12
CommandName = "Command11"
CommDispId = 1073
RsDispId = 1080
CommandText = $"DataEnvironment1.dsx":0096
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command11_Grouping"
Expanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "MatricNumber"
Caption = "MatricNumber"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "LastName"
Caption = "LastName"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "FirstName"
Caption = "FirstName"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
BeginProperty Field5
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "Allocated"
Caption = "Allocated"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Sex"
Caption = "Sex"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "tblLevel"
Caption = "tblLevel"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset13
CommandName = "Command12"
CommDispId = 1081
RsDispId = 1083
CommandText = "SELECT MatricNumber, LastName, FirstName, Department, tblLevel, Sex FROM StudentInfo WHERE Sex = 'Male'"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command12_Grouping"
Expanded = -1 'True
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "MatricNumber"
Caption = "MatricNumber"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "LastName"
Caption = "LastName"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "FirstName"
Caption = "FirstName"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "tblLevel"
Caption = "tblLevel"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Sex"
Caption = "Sex"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
End
Attribute VB_Name = "DataEnvironment1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -