dataenvironment1.dsr

来自「vb数据库编程资料」· DSR 代码 · 共 78 行

VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1 
   ClientHeight    =   2970
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   4230
   _ExtentX        =   7461
   _ExtentY        =   5239
   FolderFlags     =   1
   TypeLibGuid     =   "{E35ECF34-3CDA-498A-9CCB-B55817E391ED}"
   TypeInfoGuid    =   "{5A1C8A62-220F-41FB-89ED-3F7466AC31BD}"
   TypeInfoCookie  =   0
   Version         =   4
   NumConnections  =   1
   BeginProperty Connection1 
      ConnectionName  =   "JiaoXuesjk"
      ConnDispId      =   1001
      SourceOfData    =   3
      ConnectionSource=   $"DataEnvironment1.dsx":0000
      Expanded        =   -1  'True
      QuoteChar       =   96
      SeparatorChar   =   46
   EndProperty
   NumRecordsets   =   1
   BeginProperty Recordset1 
      CommandName     =   "Tax"
      CommDispId      =   1002
      RsDispId        =   1010
      CommandText     =   "Select 教师编号,姓名,工资,(工资-1000)*0.10 AS 交税 From 教师表"
      ActiveConnectionName=   "JiaoXuesjk"
      CommandType     =   1
      Expanded        =   -1  'True
      IsRSReturning   =   -1  'True
      NumFields       =   4
      BeginProperty Field1 
         Precision       =   0
         Size            =   5
         Scale           =   0
         Type            =   202
         Name            =   "教师编号"
         Caption         =   "教师编号"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   8
         Scale           =   0
         Type            =   202
         Name            =   "姓名"
         Caption         =   "姓名"
      EndProperty
      BeginProperty Field3 
         Precision       =   7
         Size            =   4
         Scale           =   0
         Type            =   4
         Name            =   "工资"
         Caption         =   "工资"
      EndProperty
      BeginProperty Field4 
         Precision       =   15
         Size            =   8
         Scale           =   0
         Type            =   5
         Name            =   "交税"
         Caption         =   "交税"
      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