r_HeuresSup2.bas 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. Operation =1
  2. Option =0
  3. Begin InputTables
  4. Name ="r_HeuresSup"
  5. End
  6. Begin OutputColumns
  7. Expression ="r_HeuresSup.CodeAgent"
  8. Expression ="r_HeuresSup.DateRH"
  9. Expression ="r_HeuresSup.JourRH"
  10. Expression ="r_HeuresSup.MoisRH"
  11. Expression ="r_HeuresSup.AnneeRH"
  12. Expression ="r_HeuresSup.HeureSup1"
  13. Expression ="r_HeuresSup.HeuresDep"
  14. Expression ="r_HeuresSup.HeuresDepNuit"
  15. Expression ="r_HeuresSup.HSNuit"
  16. Expression ="r_HeuresSup.HeureSupDimanche"
  17. Alias ="H<14"
  18. Expression ="HSinf14([HS],[CodeAgent],[DateRH])"
  19. Alias ="H>14"
  20. Expression ="HSsup14([HS],[CodeAgent],[DateRH])"
  21. Expression ="r_HeuresSup.HS_VHCanal"
  22. Expression ="r_HeuresSup.HS_Chantier"
  23. End
  24. dbBoolean "ReturnsRecords" ="-1"
  25. dbInteger "ODBCTimeout" ="60"
  26. dbByte "RecordsetType" ="0"
  27. dbBoolean "OrderByOn" ="0"
  28. dbByte "Orientation" ="0"
  29. dbByte "DefaultView" ="2"
  30. dbBoolean "FilterOnLoad" ="0"
  31. dbBoolean "OrderByOnLoad" ="-1"
  32. dbBoolean "TotalsRow" ="0"
  33. Begin
  34. Begin
  35. dbText "Name" ="H>14"
  36. dbLong "AggregateType" ="-1"
  37. End
  38. Begin
  39. dbText "Name" ="H<14"
  40. dbInteger "ColumnWidth" ="3165"
  41. dbBoolean "ColumnHidden" ="0"
  42. dbLong "AggregateType" ="-1"
  43. End
  44. Begin
  45. dbText "Name" ="r_HeuresSup.AnneeRH"
  46. dbLong "AggregateType" ="-1"
  47. End
  48. Begin
  49. dbText "Name" ="r_HeuresSup.CodeAgent"
  50. dbLong "AggregateType" ="-1"
  51. End
  52. Begin
  53. dbText "Name" ="r_HeuresSup.JourRH"
  54. dbLong "AggregateType" ="-1"
  55. End
  56. Begin
  57. dbText "Name" ="r_HeuresSup.HSNuit"
  58. dbLong "AggregateType" ="-1"
  59. End
  60. Begin
  61. dbText "Name" ="r_HeuresSup.MoisRH"
  62. dbLong "AggregateType" ="-1"
  63. End
  64. Begin
  65. dbText "Name" ="r_HeuresSup.HeureSupDimanche"
  66. dbLong "AggregateType" ="-1"
  67. End
  68. Begin
  69. dbText "Name" ="r_HeuresSup.DateRH"
  70. dbLong "AggregateType" ="-1"
  71. End
  72. Begin
  73. dbText "Name" ="r_HeuresSup.HeuresDep"
  74. dbLong "AggregateType" ="-1"
  75. dbInteger "ColumnWidth" ="1455"
  76. dbBoolean "ColumnHidden" ="0"
  77. End
  78. Begin
  79. dbText "Name" ="r_HeuresSup.HeuresDepNuit"
  80. dbLong "AggregateType" ="-1"
  81. End
  82. Begin
  83. dbText "Name" ="r_HeuresSup.HeureSup1"
  84. dbLong "AggregateType" ="-1"
  85. End
  86. Begin
  87. dbText "Name" ="r_HeuresSup.HS_VHCanal"
  88. dbLong "AggregateType" ="-1"
  89. End
  90. Begin
  91. dbText "Name" ="r_HeuresSup.HS_Chantier"
  92. dbLong "AggregateType" ="-1"
  93. End
  94. End
  95. Begin
  96. State =0
  97. Left =0
  98. Top =0
  99. Right =1125
  100. Bottom =545
  101. Left =-1
  102. Top =-1
  103. Right =781
  104. Bottom =204
  105. Left =0
  106. Top =0
  107. ColumnsShown =539
  108. Begin
  109. Left =48
  110. Top =12
  111. Right =319
  112. Bottom =160
  113. Top =0
  114. Name ="r_HeuresSup"
  115. Name =""
  116. End
  117. End