📄 dataenvironment1.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
ClientHeight = 10935
ClientLeft = 0
ClientTop = 0
ClientWidth = 11775
_ExtentX = 20770
_ExtentY = 19288
FolderFlags = 5
TypeLibGuid = "{A066A881-651E-490F-B277-AA3B3EF039E4}"
TypeInfoGuid = "{B30D94EC-9A7B-4520-B8BD-DC65CABE1917}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "Connection1"
ConnDispId = 1023
SourceOfData = 3
ConnectionSource= $"DataEnvironment1.dsx":0000
Expanded = -1 'True
QuoteChar = 96
SeparatorChar = 46
EndProperty
NumRecordsets = 17
BeginProperty Recordset1
CommandName = "Command1"
CommDispId = 1024
RsDispId = 1029
CommandText = "items"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 14
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "code"
Caption = "code"
EndProperty
BeginProperty Field2
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "description"
Caption = "description"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "A_price"
Caption = "A_price"
EndProperty
BeginProperty Field4
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "B_price"
Caption = "B_price"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "index"
Caption = "index"
EndProperty
BeginProperty Field6
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "CatCode"
Caption = "CatCode"
EndProperty
BeginProperty Field7
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Inhand"
Caption = "Inhand"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "RLevel"
Caption = "RLevel"
EndProperty
BeginProperty Field9
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "CLevel"
Caption = "CLevel"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "minMarkupP"
Caption = "minMarkupP"
EndProperty
BeginProperty Field11
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "CanSellAtCost"
Caption = "CanSellAtCost"
EndProperty
BeginProperty Field12
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "CanSellBelowCost"
Caption = "CanSellBelowCost"
EndProperty
BeginProperty Field13
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "CostPrice"
Caption = "CostPrice"
EndProperty
BeginProperty Field14
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "maxDiscountP"
Caption = "maxDiscountP"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "Command2"
CommDispId = 1030
RsDispId = 1033
CommandText = "Customers"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "index"
Caption = "index"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "code"
Caption = "code"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Contact"
Caption = "Contact"
EndProperty
BeginProperty Field5
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "CrValue"
Caption = "CrValue"
EndProperty
BeginProperty Field6
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "AmntDue"
Caption = "AmntDue"
EndProperty
BeginProperty Field7
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "Active"
Caption = "Active"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "brands"
CommDispId = 1034
RsDispId = 1068
CommandText = "SELECT brand FROM brands ORDER BY brand"
ActiveConnectionName= "Connection1"
CommandType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "brand"
Caption = "brand"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "colors"
CommDispId = 1038
RsDispId = 1071
CommandText = "SELECT color FROM colors ORDER BY color"
ActiveConnectionName= "Connection1"
CommandType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "color"
Caption = "color"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset5
CommandName = "origins"
CommDispId = 1044
RsDispId = 1073
CommandText = "SELECT origin FROM origins ORDER BY origin"
ActiveConnectionName= "Connection1"
CommandType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "origin"
Caption = "origin"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset6
CommandName = "types"
CommDispId = 1050
RsDispId = 1057
CommandText = "types"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Type"
Caption = "Type"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset7
CommandName = "property"
CommDispId = 1058
RsDispId = 1061
CommandText = "property"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "property"
Caption = "property"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset8
CommandName = "catogory"
CommDispId = 1062
RsDispId = 1067
CommandText = "Catogory"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 1
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Catogory"
Caption = "Catogory"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset9
CommandName = "Command3"
CommDispId = 1074
RsDispId = 1078
CommandText = "SELECT types.* FROM types"
ActiveConnectionName= "Connection1"
CommandType = 1
Locktype = 3
IsRSReturning = -1 'True
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -