UpdateTest.bas 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. Operation =4
  2. Option =0
  3. Where ="(((TableWithData.param)=\"param3\"))"
  4. Begin InputTables
  5. Name ="TableWithData"
  6. End
  7. Begin OutputColumns
  8. Name ="TableWithData.key"
  9. Expression ="\"key3_up\""
  10. End
  11. dbBoolean "ReturnsRecords" ="-1"
  12. dbInteger "ODBCTimeout" ="60"
  13. dbByte "RecordsetType" ="0"
  14. dbBoolean "OrderByOn" ="0"
  15. dbByte "Orientation" ="0"
  16. dbByte "DefaultView" ="2"
  17. dbBoolean "FilterOnLoad" ="0"
  18. dbBoolean "OrderByOnLoad" ="-1"
  19. dbBoolean "TotalsRow" ="0"
  20. dbBoolean "UseTransaction" ="-1"
  21. dbBoolean "FailOnError" ="0"
  22. Begin
  23. Begin
  24. dbText "Name" ="TableTestBaseFields.auto_number"
  25. dbLong "AggregateType" ="-1"
  26. End
  27. Begin
  28. dbText "Name" ="TableTestBaseFields.string"
  29. dbLong "AggregateType" ="-1"
  30. End
  31. Begin
  32. dbText "Name" ="TableTestBaseFields.long_string"
  33. dbLong "AggregateType" ="-1"
  34. End
  35. Begin
  36. dbText "Name" ="TableTestBaseFields.integer"
  37. dbLong "AggregateType" ="-1"
  38. End
  39. Begin
  40. dbText "Name" ="TableTestBaseFields.long_int"
  41. dbLong "AggregateType" ="-1"
  42. End
  43. Begin
  44. dbText "Name" ="TableTestBaseFields.real"
  45. dbLong "AggregateType" ="-1"
  46. End
  47. Begin
  48. dbText "Name" ="TableTestBaseFields.real_one_decimal"
  49. dbLong "AggregateType" ="-1"
  50. End
  51. Begin
  52. dbText "Name" ="TableTestBaseFields.real_double"
  53. dbLong "AggregateType" ="-1"
  54. End
  55. Begin
  56. dbText "Name" ="TableTestBaseFields.decimal"
  57. dbLong "AggregateType" ="-1"
  58. End
  59. Begin
  60. dbText "Name" ="TableTestBaseFields.datetime"
  61. dbLong "AggregateType" ="-1"
  62. End
  63. Begin
  64. dbText "Name" ="TableTestBaseFields.boolean"
  65. dbLong "AggregateType" ="-1"
  66. End
  67. Begin
  68. dbText "Name" ="TableTestBaseFields.string_with_default"
  69. dbLong "AggregateType" ="-1"
  70. End
  71. Begin
  72. dbText "Name" ="TableTestBaseFields.numeric_with_condition"
  73. dbLong "AggregateType" ="-1"
  74. End
  75. Begin
  76. dbText "Name" ="TableTestBaseFields.nonnull_date"
  77. dbLong "AggregateType" ="-1"
  78. End
  79. Begin
  80. dbText "Name" ="TableTestBaseFields.indexed_integer_no_decimal"
  81. dbLong "AggregateType" ="-1"
  82. End
  83. Begin
  84. dbText "Name" ="TableWithData.param"
  85. dbLong "AggregateType" ="-1"
  86. End
  87. Begin
  88. dbText "Name" ="TableWithData.key"
  89. dbLong "AggregateType" ="-1"
  90. End
  91. End
  92. Begin
  93. State =0
  94. Left =0
  95. Top =0
  96. Right =1336
  97. Bottom =866
  98. Left =-1
  99. Top =-1
  100. Right =1320
  101. Bottom =553
  102. Left =0
  103. Top =0
  104. ColumnsShown =579
  105. Begin
  106. Left =48
  107. Top =12
  108. Right =192
  109. Bottom =156
  110. Top =0
  111. Name ="TableWithData"
  112. Name =""
  113. End
  114. End