📄 dataenvir.dsr
字号:
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "spzd"
CommDispId = 1026
RsDispId = 1031
CommandText = "spzd"
ActiveConnectionName= "deMain"
CommandType = 2
dbObjectType = 1
Grouping = -1 'True
GroupingName = "spzd_Grouping"
SummaryExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 5
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "spzd_key"
Caption = "spzd_key"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spdm"
Caption = "spdm"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spmc"
Caption = "spmc"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "scdd"
Caption = "scdd"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "gyszd_key"
Caption = "gyszd_key"
EndProperty
NumGroups = 4
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spdm"
Caption = "spdm"
EndProperty
BeginProperty Grouping2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spmc"
Caption = "spmc"
EndProperty
BeginProperty Grouping3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "scdd"
Caption = "scdd"
EndProperty
BeginProperty Grouping4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "gyszd_key"
Caption = "gyszd_key"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset5
CommandName = "xsck"
CommDispId = 1032
RsDispId = 1040
CommandText = "SELECT spzd.spdm,spzd.spmc,xsxx.* FROM spzd,spxx,xsxx WHERE spzd.spzd_key=spxx.spzd_key AND spxx.hh=xsxx.hh"
ActiveConnectionName= "deMain"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spdm"
Caption = "spdm"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spmc"
Caption = "spmc"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "xsxx_key"
Caption = "xsxx_key"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "hh"
Caption = "hh"
EndProperty
BeginProperty Field5
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "xsrq"
Caption = "xsrq"
EndProperty
BeginProperty Field6
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "xsdj"
Caption = "xsdj"
EndProperty
BeginProperty Field7
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "xssl"
Caption = "xssl"
EndProperty
BeginProperty Field8
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "khmc"
Caption = "khmc"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset6
CommandName = "kcck"
CommDispId = 1041
RsDispId = 1044
CommandText = "select spzd.spdm,spzd.spmc,spxx.* from spzd,spxx where spzd.spzd_key=spxx.spzd_key and spxx.kcsl>0"
ActiveConnectionName= "deMain"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 10
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spdm"
Caption = "spdm"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spmc"
Caption = "spmc"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "spxx_key"
Caption = "spxx_key"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "hh"
Caption = "hh"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "spzd_key"
Caption = "spzd_key"
EndProperty
BeginProperty Field6
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "jhrq"
Caption = "jhrq"
EndProperty
BeginProperty Field7
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "jhdj"
Caption = "jhdj"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "jhsl"
Caption = "jhsl"
EndProperty
BeginProperty Field9
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "xssl"
Caption = "xssl"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "kcsl"
Caption = "kcsl"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset7
CommandName = "Allqk"
CommDispId = 1045
RsDispId = 1048
CommandText = "select spzd.spdm,spzd.spmc,spxx.* from spzd,spxx where spzd.spzd_key=spxx.spzd_key"
ActiveConnectionName= "deMain"
CommandType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 10
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spdm"
Caption = "spdm"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "spmc"
Caption = "spmc"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "spxx_key"
Caption = "spxx_key"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "hh"
Caption = "hh"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "spzd_key"
Caption = "spzd_key"
EndProperty
BeginProperty Field6
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "jhrq"
Caption = "jhrq"
EndProperty
BeginProperty Field7
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "jhdj"
Caption = "jhdj"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "jhsl"
Caption = "jhsl"
EndProperty
BeginProperty Field9
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "xssl"
Caption = "xssl"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "kcsl"
Caption = "kcsl"
EndProperty
NumGroups = 0
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 + -