📄 dataenvironment1.dsr
字号:
Name = "HostelName"
Caption = "HostelName"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "Command4"
CommDispId = 1033
RsDispId = 1037
CommandText = "SELECT HostelName, RoomNumber, Capacity, Allocated FROM Hostels WHERE (Allocated = 0)"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command4_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "RoomNumber"
Caption = "RoomNumber"
EndProperty
BeginProperty Field3
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Capacity"
Caption = "Capacity"
EndProperty
BeginProperty Field4
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Allocated"
Caption = "Allocated"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset5
CommandName = "Command5"
CommDispId = 1038
RsDispId = 1042
CommandText = "SELECT HostelName, RoomNumber, Capacity, Allocated FROM Hostels WHERE (Allocated = Capacity)"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command5_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "RoomNumber"
Caption = "RoomNumber"
EndProperty
BeginProperty Field3
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Capacity"
Caption = "Capacity"
EndProperty
BeginProperty Field4
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Allocated"
Caption = "Allocated"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset6
CommandName = "Command6"
CommDispId = 1043
RsDispId = -1
CommandText = $"DataEnvironment1.dsx":0000
ActiveConnectionName= "conYCT"
CommandType = 1
NumFields = 0
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset7
CommandName = "Command7"
CommDispId = 1045
RsDispId = 1048
CommandText = "SELECT HostelName, RoomNumber, Capacity, Allocated FROM Hostels WHERE Allocated <> 0"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command7_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "RoomNumber"
Caption = "RoomNumber"
EndProperty
BeginProperty Field3
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Capacity"
Caption = "Capacity"
EndProperty
BeginProperty Field4
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "Allocated"
Caption = "Allocated"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "HostelName"
Caption = "HostelName"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset8
CommandName = "Command8"
CommDispId = 1049
RsDispId = 1050
CommandText = "Departments"
ActiveConnectionName= "conYCT"
CommandType = 2
dbObjectType = 1
Grouping = -1 'True
GroupingName = "Command8_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 2
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "School"
Caption = "School"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Department"
Caption = "Department"
EndProperty
NumGroups = 1
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "School"
Caption = "School"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset9
CommandName = "byDept"
CommDispId = 1051
RsDispId = 1062
CommandText = "SELECT MatricNumber, LastName, FirstName, Department, tblLevel FROM StudentInfo"
ActiveConnectionName= "conYCT"
CommandType = 1
Grouping = -1 'True
GroupingName = "byDept_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 5
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
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 Recordset10
CommandName = "Command9"
CommDispId = 1063
RsDispId = 1067
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -