home *** CD-ROM | disk | FTP | other *** search
/ Planet Source Code Jumbo …e CD Visual Basic 1 to 7 / 5_2007-2008.ISO / data / Zips / airline_re204714292007.psc / DataEnvironment1.Dsr < prev    next >
Text File  |  2003-04-12  |  19KB  |  570 lines
  1. VERSION 5.00
  2. Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1 
  3.    ClientHeight    =   10020
  4.    ClientLeft      =   0
  5.    ClientTop       =   0
  6.    ClientWidth     =   8775
  7.    _ExtentX        =   15478
  8.    _ExtentY        =   17674
  9.    FolderFlags     =   1
  10.    TypeLibGuid     =   "{C49769AE-874E-4D0C-A946-F7BF1DABDF7A}"
  11.    TypeInfoGuid    =   "{FBDBA83D-0F85-4103-B99F-7023ABFE92C5}"
  12.    TypeInfoCookie  =   0
  13.    Version         =   4
  14.    NumConnections  =   1
  15.    BeginProperty Connection1 
  16.       ConnectionName  =   "Connection1"
  17.       ConnDispId      =   1001
  18.       SourceOfData    =   3
  19.       ConnectionSource=   $"DataEnvironment1.dsx":0000
  20.       QuoteChar       =   96
  21.       SeparatorChar   =   46
  22.    EndProperty
  23.    NumRecordsets   =   3
  24.    BeginProperty Recordset1 
  25.       CommandName     =   "Command1"
  26.       CommDispId      =   1002
  27.       RsDispId        =   1011
  28.       CommandText     =   "SELECT * FROM PaySlipGenerated WHERE (PAYSLIPID = ?)"
  29.       ActiveConnectionName=   "Connection1"
  30.       CommandType     =   1
  31.       IsRSReturning   =   -1  'True
  32.       NumFields       =   23
  33.       BeginProperty Field1 
  34.          Precision       =   0
  35.          Size            =   50
  36.          Scale           =   0
  37.          Type            =   202
  38.          Name            =   "empno"
  39.          Caption         =   "empno"
  40.       EndProperty
  41.       BeginProperty Field2 
  42.          Precision       =   15
  43.          Size            =   8
  44.          Scale           =   0
  45.          Type            =   5
  46.          Name            =   "basic"
  47.          Caption         =   "basic"
  48.       EndProperty
  49.       BeginProperty Field3 
  50.          Precision       =   15
  51.          Size            =   8
  52.          Scale           =   0
  53.          Type            =   5
  54.          Name            =   "pay_trans.taxdedn"
  55.          Caption         =   "pay_trans.taxdedn"
  56.       EndProperty
  57.       BeginProperty Field4 
  58.          Precision       =   15
  59.          Size            =   8
  60.          Scale           =   0
  61.          Type            =   5
  62.          Name            =   "pay_trans.pfdedn"
  63.          Caption         =   "pay_trans.pfdedn"
  64.       EndProperty
  65.       BeginProperty Field5 
  66.          Precision       =   15
  67.          Size            =   8
  68.          Scale           =   0
  69.          Type            =   5
  70.          Name            =   "addall"
  71.          Caption         =   "addall"
  72.       EndProperty
  73.       BeginProperty Field6 
  74.          Precision       =   0
  75.          Size            =   50
  76.          Scale           =   0
  77.          Type            =   202
  78.          Name            =   "addall_description"
  79.          Caption         =   "addall_description"
  80.       EndProperty
  81.       BeginProperty Field7 
  82.          Precision       =   15
  83.          Size            =   8
  84.          Scale           =   0
  85.          Type            =   5
  86.          Name            =   "lwp"
  87.          Caption         =   "lwp"
  88.       EndProperty
  89.       BeginProperty Field8 
  90.          Precision       =   10
  91.          Size            =   4
  92.          Scale           =   0
  93.          Type            =   3
  94.          Name            =   "totleave"
  95.          Caption         =   "totleave"
  96.       EndProperty
  97.       BeginProperty Field9 
  98.          Precision       =   15
  99.          Size            =   8
  100.          Scale           =   0
  101.          Type            =   5
  102.          Name            =   "lwp_amt"
  103.          Caption         =   "lwp_amt"
  104.       EndProperty
  105.       BeginProperty Field10 
  106.          Precision       =   10
  107.          Size            =   4
  108.          Scale           =   0
  109.          Type            =   3
  110.          Name            =   "netpay"
  111.          Caption         =   "netpay"
  112.       EndProperty
  113.       BeginProperty Field11 
  114.          Precision       =   0
  115.          Size            =   50
  116.          Scale           =   0
  117.          Type            =   202
  118.          Name            =   "month"
  119.          Caption         =   "month"
  120.       EndProperty
  121.       BeginProperty Field12 
  122.          Precision       =   0
  123.          Size            =   50
  124.          Scale           =   0
  125.          Type            =   202
  126.          Name            =   "PAYSLIPID"
  127.          Caption         =   "PAYSLIPID"
  128.       EndProperty
  129.       BeginProperty Field13 
  130.          Precision       =   0
  131.          Size            =   255
  132.          Scale           =   0
  133.          Type            =   202
  134.          Name            =   "name"
  135.          Caption         =   "name"
  136.       EndProperty
  137.       BeginProperty Field14 
  138.          Precision       =   0
  139.          Size            =   8
  140.          Scale           =   0
  141.          Type            =   7
  142.          Name            =   "doj"
  143.          Caption         =   "doj"
  144.       EndProperty
  145.       BeginProperty Field15 
  146.          Precision       =   0
  147.          Size            =   50
  148.          Scale           =   0
  149.          Type            =   202
  150.          Name            =   "Address"
  151.          Caption         =   "Address"
  152.       EndProperty
  153.       BeginProperty Field16 
  154.          Precision       =   15
  155.          Size            =   8
  156.          Scale           =   0
  157.          Type            =   5
  158.          Name            =   "tax.taxdedn"
  159.          Caption         =   "tax.taxdedn"
  160.       EndProperty
  161.       BeginProperty Field17 
  162.          Precision       =   15
  163.          Size            =   8
  164.          Scale           =   0
  165.          Type            =   5
  166.          Name            =   "tax.pfdedn"
  167.          Caption         =   "tax.pfdedn"
  168.       EndProperty
  169.       BeginProperty Field18 
  170.          Precision       =   15
  171.          Size            =   8
  172.          Scale           =   0
  173.          Type            =   5
  174.          Name            =   "TaxPer"
  175.          Caption         =   "TaxPer"
  176.       EndProperty
  177.       BeginProperty Field19 
  178.          Precision       =   15
  179.          Size            =   8
  180.          Scale           =   0
  181.          Type            =   5
  182.          Name            =   "PFPer"
  183.          Caption         =   "PFPer"
  184.       EndProperty
  185.       BeginProperty Field20 
  186.          Precision       =   0
  187.          Size            =   50
  188.          Scale           =   0
  189.          Type            =   202
  190.          Name            =   "desig"
  191.          Caption         =   "desig"
  192.       EndProperty
  193.       BeginProperty Field21 
  194.          Precision       =   0
  195.          Size            =   50
  196.          Scale           =   0
  197.          Type            =   202
  198.          Name            =   "dept"
  199.          Caption         =   "dept"
  200.       EndProperty
  201.       BeginProperty Field22 
  202.          Precision       =   0
  203.          Size            =   50
  204.          Scale           =   0
  205.          Type            =   202
  206.          Name            =   "Desig_Description"
  207.          Caption         =   "Desig_Description"
  208.       EndProperty
  209.       BeginProperty Field23 
  210.          Precision       =   0
  211.          Size            =   50
  212.          Scale           =   0
  213.          Type            =   202
  214.          Name            =   "Dept_Desc"
  215.          Caption         =   "Dept_Desc"
  216.       EndProperty
  217.       NumGroups       =   0
  218.       ParamCount      =   1
  219.       BeginProperty P1 
  220.          RealName        =   "?"
  221.          Direction       =   1
  222.          Precision       =   255
  223.          Scale           =   255
  224.          Size            =   510
  225.          DataType        =   202
  226.          HostType        =   8
  227.          Required        =   -1  'True
  228.       EndProperty
  229.       RelationCount   =   0
  230.       AggregateCount  =   0
  231.    EndProperty
  232.    BeginProperty Recordset2 
  233.       CommandName     =   "Command2"
  234.       CommDispId      =   1012
  235.       RsDispId        =   1015
  236.       CommandText     =   "SELECT * FROM PaySlipGenerated WHERE (empno = ?)"
  237.       ActiveConnectionName=   "Connection1"
  238.       CommandType     =   1
  239.       IsRSReturning   =   -1  'True
  240.       NumFields       =   23
  241.       BeginProperty Field1 
  242.          Precision       =   0
  243.          Size            =   50
  244.          Scale           =   0
  245.          Type            =   202
  246.          Name            =   "empno"
  247.          Caption         =   "empno"
  248.       EndProperty
  249.       BeginProperty Field2 
  250.          Precision       =   15
  251.          Size            =   8
  252.          Scale           =   0
  253.          Type            =   5
  254.          Name            =   "basic"
  255.          Caption         =   "basic"
  256.       EndProperty
  257.       BeginProperty Field3 
  258.          Precision       =   15
  259.          Size            =   8
  260.          Scale           =   0
  261.          Type            =   5
  262.          Name            =   "pay_trans.taxdedn"
  263.          Caption         =   "pay_trans.taxdedn"
  264.       EndProperty
  265.       BeginProperty Field4 
  266.          Precision       =   15
  267.          Size            =   8
  268.          Scale           =   0
  269.          Type            =   5
  270.          Name            =   "pay_trans.pfdedn"
  271.          Caption         =   "pay_trans.pfdedn"
  272.       EndProperty
  273.       BeginProperty Field5 
  274.          Precision       =   15
  275.          Size            =   8
  276.          Scale           =   0
  277.          Type            =   5
  278.          Name            =   "addall"
  279.          Caption         =   "addall"
  280.       EndProperty
  281.       BeginProperty Field6 
  282.          Precision       =   0
  283.          Size            =   50
  284.          Scale           =   0
  285.          Type            =   202
  286.          Name            =   "addall_description"
  287.          Caption         =   "addall_description"
  288.       EndProperty
  289.       BeginProperty Field7 
  290.          Precision       =   15
  291.          Size            =   8
  292.          Scale           =   0
  293.          Type            =   5
  294.          Name            =   "lwp"
  295.          Caption         =   "lwp"
  296.       EndProperty
  297.       BeginProperty Field8 
  298.          Precision       =   10
  299.          Size            =   4
  300.          Scale           =   0
  301.          Type            =   3
  302.          Name            =   "totleave"
  303.          Caption         =   "totleave"
  304.       EndProperty
  305.       BeginProperty Field9 
  306.          Precision       =   15
  307.          Size            =   8
  308.          Scale           =   0
  309.          Type            =   5
  310.          Name            =   "lwp_amt"
  311.          Caption         =   "lwp_amt"
  312.       EndProperty
  313.       BeginProperty Field10 
  314.          Precision       =   10
  315.          Size            =   4
  316.          Scale           =   0
  317.          Type            =   3
  318.          Name            =   "netpay"
  319.          Caption         =   "netpay"
  320.       EndProperty
  321.       BeginProperty Field11 
  322.          Precision       =   0
  323.          Size            =   50
  324.          Scale           =   0
  325.          Type            =   202
  326.          Name            =   "month"
  327.          Caption         =   "month"
  328.       EndProperty
  329.       BeginProperty Field12 
  330.          Precision       =   0
  331.          Size            =   50
  332.          Scale           =   0
  333.          Type            =   202
  334.          Name            =   "PAYSLIPID"
  335.          Caption         =   "PAYSLIPID"
  336.       EndProperty
  337.       BeginProperty Field13 
  338.          Precision       =   0
  339.          Size            =   255
  340.          Scale           =   0
  341.          Type            =   202
  342.          Name            =   "name"
  343.          Caption         =   "name"
  344.       EndProperty
  345.       BeginProperty Field14 
  346.          Precision       =   0
  347.          Size            =   8
  348.          Scale           =   0
  349.          Type            =   7
  350.          Name            =   "doj"
  351.          Caption         =   "doj"
  352.       EndProperty
  353.       BeginProperty Field15 
  354.          Precision       =   0
  355.          Size            =   50
  356.          Scale           =   0
  357.          Type            =   202
  358.          Name            =   "Address"
  359.          Caption         =   "Address"
  360.       EndProperty
  361.       BeginProperty Field16 
  362.          Precision       =   15
  363.          Size            =   8
  364.          Scale           =   0
  365.          Type            =   5
  366.          Name            =   "tax.taxdedn"
  367.          Caption         =   "tax.taxdedn"
  368.       EndProperty
  369.       BeginProperty Field17 
  370.          Precision       =   15
  371.          Size            =   8
  372.          Scale           =   0
  373.          Type            =   5
  374.          Name            =   "tax.pfdedn"
  375.          Caption         =   "tax.pfdedn"
  376.       EndProperty
  377.       BeginProperty Field18 
  378.          Precision       =   15
  379.          Size            =   8
  380.          Scale           =   0
  381.          Type            =   5
  382.          Name            =   "TaxPer"
  383.          Caption         =   "TaxPer"
  384.       EndProperty
  385.       BeginProperty Field19 
  386.          Precision       =   15
  387.          Size            =   8
  388.          Scale           =   0
  389.          Type            =   5
  390.          Name            =   "PFPer"
  391.          Caption         =   "PFPer"
  392.       EndProperty
  393.       BeginProperty Field20 
  394.          Precision       =   0
  395.          Size            =   50
  396.          Scale           =   0
  397.          Type            =   202
  398.          Name            =   "desig"
  399.          Caption         =   "desig"
  400.       EndProperty
  401.       BeginProperty Field21 
  402.          Precision       =   0
  403.          Size            =   50
  404.          Scale           =   0
  405.          Type            =   202
  406.          Name            =   "dept"
  407.          Caption         =   "dept"
  408.       EndProperty
  409.       BeginProperty Field22 
  410.          Precision       =   0
  411.          Size            =   50
  412.          Scale           =   0
  413.          Type            =   202
  414.          Name            =   "Desig_Description"
  415.          Caption         =   "Desig_Description"
  416.       EndProperty
  417.       BeginProperty Field23 
  418.          Precision       =   0
  419.          Size            =   50
  420.          Scale           =   0
  421.          Type            =   202
  422.          Name            =   "Dept_Desc"
  423.          Caption         =   "Dept_Desc"
  424.       EndProperty
  425.       NumGroups       =   0
  426.       ParamCount      =   1
  427.       BeginProperty P1 
  428.          RealName        =   "?"
  429.          Direction       =   1
  430.          Precision       =   255
  431.          Scale           =   255
  432.          Size            =   510
  433.          DataType        =   202
  434.          HostType        =   8
  435.          Required        =   -1  'True
  436.       EndProperty
  437.       RelationCount   =   0
  438.       AggregateCount  =   0
  439.    EndProperty
  440.    BeginProperty Recordset3 
  441.       CommandName     =   "comALL"
  442.       CommDispId      =   1016
  443.       RsDispId        =   1023
  444.       CommandText     =   $"DataEnvironment1.dsx":0090
  445.       ActiveConnectionName=   "Connection1"
  446.       CommandType     =   1
  447.       IsRSReturning   =   -1  'True
  448.       NumFields       =   11
  449.       BeginProperty Field1 
  450.          Precision       =   0
  451.          Size            =   50
  452.          Scale           =   0
  453.          Type            =   202
  454.          Name            =   "Employee_ID"
  455.          Caption         =   "Employee_ID"
  456.       EndProperty
  457.       BeginProperty Field2 
  458.          Precision       =   0
  459.          Size            =   255
  460.          Scale           =   0
  461.          Type            =   202
  462.          Name            =   "Name"
  463.          Caption         =   "Name"
  464.       EndProperty
  465.       BeginProperty Field3 
  466.          Precision       =   0
  467.          Size            =   8
  468.          Scale           =   0
  469.          Type            =   7
  470.          Name            =   "Date_of_Joining"
  471.          Caption         =   "Date_of_Joining"
  472.       EndProperty
  473.       BeginProperty Field4 
  474.          Precision       =   0
  475.          Size            =   50
  476.          Scale           =   0
  477.          Type            =   202
  478.          Name            =   "Department"
  479.          Caption         =   "Department"
  480.       EndProperty
  481.       BeginProperty Field5 
  482.          Precision       =   0
  483.          Size            =   50
  484.          Scale           =   0
  485.          Type            =   202
  486.          Name            =   "Designation"
  487.          Caption         =   "Designation"
  488.       EndProperty
  489.       BeginProperty Field6 
  490.          Precision       =   0
  491.          Size            =   8
  492.          Scale           =   0
  493.          Type            =   7
  494.          Name            =   "MonthOfPay"
  495.          Caption         =   "MonthOfPay"
  496.       EndProperty
  497.       BeginProperty Field7 
  498.          Precision       =   15
  499.          Size            =   8
  500.          Scale           =   0
  501.          Type            =   5
  502.          Name            =   "Basic"
  503.          Caption         =   "Basic"
  504.       EndProperty
  505.       BeginProperty Field8 
  506.          Precision       =   15
  507.          Size            =   8
  508.          Scale           =   0
  509.          Type            =   5
  510.          Name            =   "PF_Deduction"
  511.          Caption         =   "PF_Deduction"
  512.       EndProperty
  513.       BeginProperty Field9 
  514.          Precision       =   15
  515.          Size            =   8
  516.          Scale           =   0
  517.          Type            =   5
  518.          Name            =   "LeaveDeduction"
  519.          Caption         =   "LeaveDeduction"
  520.       EndProperty
  521.       BeginProperty Field10 
  522.          Precision       =   15
  523.          Size            =   8
  524.          Scale           =   0
  525.          Type            =   5
  526.          Name            =   "Tax_Deduction"
  527.          Caption         =   "Tax_Deduction"
  528.       EndProperty
  529.       BeginProperty Field11 
  530.          Precision       =   10
  531.          Size            =   4
  532.          Scale           =   0
  533.          Type            =   3
  534.          Name            =   "Net_Pay"
  535.          Caption         =   "Net_Pay"
  536.       EndProperty
  537.       NumGroups       =   0
  538.       ParamCount      =   2
  539.       BeginProperty P1 
  540.          RealName        =   "?"
  541.          Direction       =   1
  542.          Precision       =   255
  543.          Scale           =   255
  544.          Size            =   510
  545.          DataType        =   202
  546.          HostType        =   8
  547.          Required        =   -1  'True
  548.       EndProperty
  549.       BeginProperty P2 
  550.          RealName        =   "?"
  551.          Direction       =   1
  552.          Precision       =   255
  553.          Scale           =   255
  554.          Size            =   510
  555.          DataType        =   202
  556.          HostType        =   8
  557.          Required        =   -1  'True
  558.       EndProperty
  559.       RelationCount   =   0
  560.       AggregateCount  =   0
  561.    EndProperty
  562. End
  563. Attribute VB_Name = "DataEnvironment1"
  564. Attribute VB_GlobalNameSpace = False
  565. Attribute VB_Creatable = True
  566. Attribute VB_PredeclaredId = True
  567. Attribute VB_Exposed = False
  568. Option Explicit
  569.  
  570.