📄 dataenvironment1.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
ClientHeight = 6525
ClientLeft = 0
ClientTop = 0
ClientWidth = 7260
_ExtentX = 12806
_ExtentY = 11509
FolderFlags = 1
TypeLibGuid = "{8CBA3A49-309A-4DAB-B2E6-34081FC346AB}"
TypeInfoGuid = "{63673DE4-1230-4D5B-B1BA-7E55B4931AA1}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "Connection1"
ConnDispId = 1001
SourceOfData = 3
ConnectionSource= "Provider=MSDASQL.1;Persist Security Info=False;Data Source=relience"
Expanded = -1 'True
QuoteChar = 96
SeparatorChar = 46
EndProperty
NumRecordsets = 5
BeginProperty Recordset1
CommandName = "Command1"
CommDispId = 1002
RsDispId = 1005
CommandText = "select * from temp_accounts"
ActiveConnectionName= "Connection1"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 9
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Ac_no"
Caption = "Ac_no"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "AC_Name"
Caption = "AC_Name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field4
Precision = 0
Size = 250
Scale = 0
Type = 202
Name = "Address"
Caption = "Address"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Cont_no"
Caption = "Cont_no"
EndProperty
BeginProperty Field6
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "Cr"
Caption = "Cr"
EndProperty
BeginProperty Field7
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "Db"
Caption = "Db"
EndProperty
BeginProperty Field8
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "Balance"
Caption = "Balance"
EndProperty
BeginProperty Field9
Precision = 0
Size = 100
Scale = 0
Type = 202
Name = "Comp_name"
Caption = "Comp_name"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "Command2"
CommDispId = 1006
RsDispId = 1007
CommandText = "select * from temp_stock"
ActiveConnectionName= "Connection1"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command2_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 12
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "item_code"
Caption = "item_code"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "g_head"
Caption = "g_head"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "item"
Caption = "item"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "model"
Caption = "model"
EndProperty
BeginProperty Field5
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price"
Caption = "price"
EndProperty
BeginProperty Field6
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "MRP"
Caption = "MRP"
EndProperty
BeginProperty Field7
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "OB"
Caption = "OB"
EndProperty
BeginProperty Field8
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "location"
Caption = "location"
EndProperty
BeginProperty Field9
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Manu"
Caption = "Manu"
EndProperty
BeginProperty Field10
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Qoh"
Caption = "Qoh"
EndProperty
BeginProperty Field11
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "total_qty"
Caption = "total_qty"
EndProperty
BeginProperty Field12
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "iss_qty"
Caption = "iss_qty"
EndProperty
NumGroups = 2
BeginProperty Grouping1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "g_head"
Caption = "g_head"
EndProperty
BeginProperty Grouping2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "item"
Caption = "item"
EndProperty
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "Command4"
CommDispId = 1014
RsDispId = 1019
CommandText = "select * from temp_trans "
ActiveConnectionName= "Connection1"
CommandType = 1
Grouping = -1 'True
GroupingName = "Command4_Grouping"
SummaryExpanded = -1 'True
DetailExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 13
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Ac_Name"
Caption = "Ac_Name"
EndProperty
BeginProperty Field2
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "BillNo"
Caption = "BillNo"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Item_Code"
Caption = "Item_Code"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "G_Head"
Caption = "G_Head"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Item"
Caption = "Item"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Model"
Caption = "Model"
EndProperty
BeginProperty Field7
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Qty"
Caption = "Qty"
EndProperty
BeginProperty Field8
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "Rate"
Caption = "Rate"
EndProperty
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -