صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
eric
/
Topspeed_JPI
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
شاخه: master
شاخه‌ها تگ‌ها
Topspeed_JPI
/
TS-V3
/
MODBASE
/
DBFIELDS.LST

DBFIELDS.LST 12 KB
لینک دائمی تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313 
  1. Listing:
    2. 

  2. 

  3.     1  IMPLEMENTATION MODULE DBFields;
    4. 

  4.     2  
    5. 

  5.     3  (*
    6. 

  6.     4   *  ModBase
    7. 

  7.     5   *  Release 3.0
    8. 

  8.     6   *  (c) Copyright 1986 - 1991 John McMonagle & Donald G. Fletcher
    9. 

  9.     7   *  (c) Copyright 1986 - 1991 PMI
    10. 

  10.     8   *  P.O. Box 8402
    11. 

  11.     9   *  Green Bay Wi 53308
    12. 

  12.    10   *  All Rights Reserved
    13. 

  13.    11   *
    14. 

  14.    12   *)
    15. 

  15.    13  IMPORT ModBase3;
    16. 

  16.    14  FROM ModBase3 IMPORT DBFile, GetField,FieldList,DBFieldPtr;
    17. 

  17. *****       ^ duplicate identifier
    18. 

  18.    15  FROM DateFunctions IMPORT Date;
    19. 

  19.    16  FROM StrConv  IMPORT RealToStr, StrToReal;
    20. 

  20.    17  FROM NumTypes IMPORT Real8;
    21. 

  21.    18  
    22. 

  22.    19  CONST MaxDigits = 18;
    23. 

  23.    20  
    24. 

  24.    21  PROCEDURE DataFormatToDate(dbstring: ARRAY OF CHAR; VAR d: Date);
    25. 

  25. *****                                                ^ not supported yet
    26. 

  26.    22  (* Converts a string from dbase data format (yyyymmdd) to Date *)
    27. 

  27.    23  VAR i: CARDINAL;
    28. 

  28.    24  BEGIN
    29. 

  29.    25    IF dbstring[0] = ' ' THEN
    30. 

  30. *****       ^ not supported yet
    31. 

  31. *****                 ^ not supported yet
    32. 

  32.    26      d.yr := 0; d.mo := 0; d.day := 0
    33. 

  33. *****      ^ not supported yet
    34. 

  34. *****        ^ not supported yet
    35. 

  35. *****                 ^ not supported yet
    36. 

  36. *****                   ^ not supported yet
    37. 

  37. *****                            ^ not supported yet
    38. 

  38. *****                              ^ not supported yet
    39. 

  39.    27    ELSE
    40. 

  40.    28      d.yr := 0;
    41. 

  41. *****      ^ not supported yet
    42. 

  42. *****        ^ not supported yet
    43. 

  43.    29      FOR i := 0 TO 3 DO
    44. 

  44.    30        d.yr := (d.yr * 10) + (ORD(dbstring[i])-60B)
    45. 

  45. *****        ^ not supported yet
    46. 

  46. *****          ^ not supported yet
    47. 

  47. *****                 ^ not supported yet
    48. 

  48. *****                   ^ not supported yet
    49. 

  49. *****                               ^ undeclared identifier
    50. 

  50. *****                                   ^ not supported yet
    51. 

  51. *****                                             ^ not supported yet
    52. 

  52.    31      END;
    53. 

  53.    32      d.mo  :=  (ORD(dbstring[4])-60B) * 10 + (ORD(dbstring[5])-60B);
    54. 

  54. *****      ^ not supported yet
    55. 

  55. *****        ^ not supported yet
    56. 

  56. *****                 ^ undeclared identifier
    57. 

  57. *****                     ^ not supported yet
    58. 

  58. *****                               ^ not supported yet
    59. 

  59. *****                                               ^ undeclared identifier
    60. 

  60. *****                                                   ^ not supported yet
    61. 

  61. *****                                                             ^ not supported yet
    62. 

  62.    33      d.day :=  (ORD(dbstring[6])-60B) * 10 + (ORD(dbstring[7])-60B);
    63. 

  63. *****      ^ not supported yet
    64. 

  64. *****        ^ not supported yet
    65. 

  65. *****                 ^ undeclared identifier
    66. 

  66. *****                     ^ not supported yet
    67. 

  67. *****                               ^ not supported yet
    68. 

  68. *****                                               ^ undeclared identifier
    69. 

  69. *****                                                   ^ not supported yet
    70. 

  70. *****                                                             ^ not supported yet
    71. 

  71.    34    END;
    72. 

  72.    35  END DataFormatToDate;
    73. 

  73. *****      ^ not supported yet
    74. 

  74.    36  
    75. 

  75.    37  PROCEDURE DateToDataFormat(d: Date; VAR datestring: ARRAY OF CHAR);
    76. 

  76. *****                                                               ^ not supported yet
    77. 

  77.    38  BEGIN
    78. 

  78.    39    datestring[0] := CHR(d.yr DIV 1000 + 60B);
    79. 

  79. *****    ^ not supported yet
    80. 

  80. *****                ^ not supported yet
    81. 

  81. *****                     ^ undeclared identifier
    82. 

  82. *****                         ^ not supported yet
    83. 

  83. *****                           ^ not supported yet
    84. 

  84. *****                                            ^ not supported yet
    85. 

  85.    40    d.yr := d.yr MOD 1000;
    86. 

  86. *****    ^ not supported yet
    87. 

  87. *****      ^ not supported yet
    88. 

  88. *****            ^ not supported yet
    89. 

  89. *****              ^ not supported yet
    90. 

  90.    41    datestring[1] := CHR(d.yr DIV 100 + 60B);
    91. 

  91. *****    ^ not supported yet
    92. 

  92. *****                ^ not supported yet
    93. 

  93. *****                     ^ undeclared identifier
    94. 

  94. *****                         ^ not supported yet
    95. 

  95. *****                           ^ not supported yet
    96. 

  96. *****                                           ^ not supported yet
    97. 

  97.    42    d.yr := d.yr MOD 100;
    98. 

  98. *****    ^ not supported yet
    99. 

  99. *****      ^ not supported yet
    100. 

  100. *****            ^ not supported yet
    101. 

  101. *****              ^ not supported yet
    102. 

  102.    43    datestring[2] := CHR(d.yr DIV 10 + 60B);
    103. 

  103. *****    ^ not supported yet
    104. 

  104. *****                ^ not supported yet
    105. 

  105. *****                     ^ undeclared identifier
    106. 

  106. *****                         ^ not supported yet
    107. 

  107. *****                           ^ not supported yet
    108. 

  108. *****                                          ^ not supported yet
    109. 

  109.    44    datestring[3] := CHR(d.yr MOD 10 + 60B);
    110. 

  110. *****    ^ not supported yet
    111. 

  111. *****                ^ not supported yet
    112. 

  112. *****                     ^ undeclared identifier
    113. 

  113. *****                         ^ not supported yet
    114. 

  114. *****                           ^ not supported yet
    115. 

  115. *****                                          ^ not supported yet
    116. 

  116.    45    datestring[4] := CHR(d.mo DIV 10 + 60B);
    117. 

  117. *****    ^ not supported yet
    118. 

  118. *****                ^ not supported yet
    119. 

  119. *****                     ^ undeclared identifier
    120. 

  120. *****                         ^ not supported yet
    121. 

  121. *****                           ^ not supported yet
    122. 

  122. *****                                          ^ not supported yet
    123. 

  123.    46    datestring[5] := CHR(d.mo MOD 10 + 60B);
    124. 

  124. *****    ^ not supported yet
    125. 

  125. *****                ^ not supported yet
    126. 

  126. *****                     ^ undeclared identifier
    127. 

  127. *****                         ^ not supported yet
    128. 

  128. *****                           ^ not supported yet
    129. 

  129. *****                                          ^ not supported yet
    130. 

  130.    47    datestring[6] := CHR(d.day DIV 10 + 60B);
    131. 

  131. *****    ^ not supported yet
    132. 

  132. *****                ^ not supported yet
    133. 

  133. *****                     ^ undeclared identifier
    134. 

  134. *****                         ^ not supported yet
    135. 

  135. *****                           ^ not supported yet
    136. 

  136. *****                                           ^ not supported yet
    137. 

  137.    48    datestring[7] := CHR(d.day MOD 10 + 60B);
    138. 

  138. *****    ^ not supported yet
    139. 

  139. *****                ^ not supported yet
    140. 

  140. *****                     ^ undeclared identifier
    141. 

  141. *****                         ^ not supported yet
    142. 

  142. *****                           ^ not supported yet
    143. 

  143. *****                                           ^ not supported yet
    144. 

  144.    49    IF HIGH(datestring) > 7 THEN
    145. 

  145. *****       ^ undeclared identifier
    146. 

  146. *****            ^ not supported yet
    147. 

  147.    50       datestring[8] := 0C;
    148. 

  148. *****       ^ not supported yet
    149. 

  149. *****                   ^ not supported yet
    150. 

  150.    51    END;
    151. 

  151.    52  END DateToDataFormat;
    152. 

  152. *****      ^ not supported yet
    153. 

  153.    53  
    154. 

  154.    54  PROCEDURE GetDateField(VAR alias: DBFile; fieldnum: CARDINAL;
    155. 

  155.    55      VAR d: Date);
    156. 

  156.    56  VAR datestr: ARRAY [0..7] OF CHAR;
    157. 

  157. *****                         ^ not supported yet
    158. 

  158. *****                               ^ not supported yet
    159. 

  159.    57  BEGIN
    160. 

  160.    58    GetField(alias, fieldnum, datestr);
    161. 

  161. *****    ^ not supported yet
    162. 

  162. *****             ^ not supported yet
    163. 

  163. *****                              ^ not supported yet
    164. 

  164.    59    DataFormatToDate(datestr, d);
    165. 

  165. *****    ^ not supported yet
    166. 

  166. *****                     ^ not supported yet
    167. 

  167. *****                              ^ not supported yet
    168. 

  168.    60  END GetDateField;
    169. 

  169. *****      ^ not supported yet
    170. 

  170.    61  
    171. 

  171.    62  PROCEDURE GetLogicalField(VAR alias: DBFile; fieldnum: CARDINAL;
    172. 

  172.    63      VAR l: BOOLEAN);
    173. 

  173.    64  VAR lstring: ARRAY [0..1] OF CHAR;
    174. 

  174. *****                         ^ not supported yet
    175. 

  175. *****                               ^ not supported yet
    176. 

  176.    65  BEGIN
    177. 

  177.    66    GetField(alias, fieldnum, lstring);
    178. 

  178. *****    ^ not supported yet
    179. 

  179. *****             ^ not supported yet
    180. 

  180. *****                              ^ not supported yet
    181. 

  181.    67    IF (CAP(lstring[0]) = 'Y') OR (CAP(lstring[0]) = 'T') THEN
    182. 

  182. *****        ^ undeclared identifier
    183. 

  183. *****            ^ not supported yet
    184. 

  184. *****                     ^ not supported yet
    185. 

  185. *****                                   ^ undeclared identifier
    186. 

  186. *****                                       ^ not supported yet
    187. 

  187. *****                                                ^ not supported yet
    188. 

  188.    68      l := TRUE
    189. 

  189.    69    ELSE
    190. 

  190.    70      l := FALSE
    191. 

  191.    71    END;
    192. 

  192.    72  END GetLogicalField;
    193. 

  193. *****      ^ not supported yet
    194. 

  194.    73  
    195. 

  195.    74  PROCEDURE GetNumField(VAR alias: DBFile; fieldnum: CARDINAL;  VAR
    196. 

  196.    75      n: Real8);
    197. 

  197.    76  VAR nstring: ARRAY [1..MaxDigits] OF CHAR;
    198. 

  198. *****                         ^ not supported yet
    199. 

  199. *****                                       ^ not supported yet
    200. 

  200.    77      ok: BOOLEAN;
    201. 

  201.    78  BEGIN
    202. 

  202.    79    GetField(alias, fieldnum, nstring);
    203. 

  203. *****    ^ not supported yet
    204. 

  204. *****             ^ not supported yet
    205. 

  205. *****                              ^ not supported yet
    206. 

  206.    80    ok:=StrToReal(nstring,0, n)
    207. 

  207. *****        ^ not supported yet
    208. 

  208. *****                  ^ not supported yet
    209. 

  209. *****                             ^ not supported yet
    210. 

  210.    81  END GetNumField;
    211. 

  211. *****      ^ not supported yet
    212. 

  212.    82  
    213. 

  213.    83  PROCEDURE Replace(VAR alias: DBFile; fieldnum: CARDINAL; s: ARRAY
    214. 

  214.    84      OF CHAR);
    215. 

  215. *****         ^ not supported yet
    216. 

  216.    85  BEGIN
    217. 

  217.    86    ModBase3.Replace(alias,fieldnum,s);
    218. 

  218. *****    ^ not supported yet
    219. 

  219. *****             ^ not supported yet
    220. 

  220. *****                     ^ not supported yet
    221. 

  221. *****                                    ^ not supported yet
    222. 

  222.    87  END Replace;
    223. 

  223. *****      ^ not supported yet
    224. 

  224.    88  
    225. 

  225.    89  PROCEDURE ReplaceD(VAR alias: DBFile; fieldnum: CARDINAL; d:
    226. 

  226.    90      Date);
    227. 

  227.    91  VAR dstring: ARRAY [0..9] OF CHAR;
    228. 

  228. *****                         ^ not supported yet
    229. 

  229. *****                               ^ not supported yet
    230. 

  230.    92  BEGIN
    231. 

  231.    93    DateToDataFormat(d, dstring);
    232. 

  232. *****    ^ not supported yet
    233. 

  233. *****                     ^ not supported yet
    234. 

  234. *****                        ^ not supported yet
    235. 

  235.    94    Replace(alias, fieldnum, dstring);
    236. 

  236. *****    ^ not supported yet
    237. 

  237. *****            ^ not supported yet
    238. 

  238. *****                             ^ not supported yet
    239. 

  239.    95  END ReplaceD;
    240. 

  240. *****      ^ not supported yet
    241. 

  241.    96  
    242. 

  242.    97  PROCEDURE ReplaceL(VAR alias: DBFile; fieldnum: CARDINAL; l:
    243. 

  243.    98      BOOLEAN);
    244. 

  244.    99  VAR lchar: ARRAY [0..0] OF CHAR;
    245. 

  245. *****                       ^ not supported yet
    246. 

  246. *****                             ^ not supported yet
    247. 

  247.   100  BEGIN
    248. 

  248.   101    IF l THEN
    249. 

  249.   102      lchar[0] := 'T'
    250. 

  250. *****      ^ not supported yet
    251. 

  251. *****             ^ not supported yet
    252. 

  252.   103    ELSE
    253. 

  253.   104      lchar[0] := 'F'
    254. 

  254. *****      ^ not supported yet
    255. 

  255. *****             ^ not supported yet
    256. 

  256.   105    END;
    257. 

  257.   106    Replace( alias, fieldnum, lchar );
    258. 

  258. *****    ^ not supported yet
    259. 

  259. *****             ^ not supported yet
    260. 

  260. *****                              ^ not supported yet
    261. 

  261.   107  END ReplaceL;
    262. 

  262. *****      ^ not supported yet
    263. 

  263.   108  
    264. 

  264.   109  PROCEDURE ReplaceN(VAR alias: DBFile; fieldnum: CARDINAL; n:
    265. 

  265.   110      Real8);
    266. 

  266.   111  VAR nstring: ARRAY [0..MaxDigits] OF CHAR;
    267. 

  267. *****                         ^ not supported yet
    268. 

  268. *****                                       ^ not supported yet
    269. 

  269.   112     fldptr:DBFieldPtr;
    270. 

  270.   113  BEGIN
    271. 

  271.   114    fldptr:=FieldList(alias);
    272. 

  272. *****    ^ not supported yet
    273. 

  273. *****            ^ not supported yet
    274. 

  274. *****                      ^ not supported yet
    275. 

  275.   115    WITH fldptr^[fieldnum] DO
    276. 

  276. *****         ^ not supported yet
    277. 

  277. *****                         ^ not supported yet
    278. 

  278.   116      IF decplaces=0 THEN
    279. 

  279. *****         ^ undeclared identifier
    280. 

  280.   117        RealToStr(n, decplaces,
    281. 

  281. *****        ^ not supported yet
    282. 

  282. *****                  ^ not supported yet
    283. 

  283. *****                     ^ undeclared identifier
    284. 

  284.   118          size+1, nstring);(* assumes that Real to str will insert '.' *)
    285. 

  285. *****          ^ undeclared identifier
    286. 

  286. *****                  ^ not supported yet
    287. 

  287.   119        nstring[size]:=0C;
    288. 

  288. *****        ^ not supported yet
    289. 

  289. *****                ^ undeclared identifier
    290. 

  290.   120      ELSE
    291. 

  291.   121        RealToStr(n, decplaces,
    292. 

  292. *****        ^ not supported yet
    293. 

  293. *****                  ^ not supported yet
    294. 

  294. *****                     ^ undeclared identifier
    295. 

  295.   122          size, nstring);
    296. 

  296. *****          ^ undeclared identifier
    297. 

  297. *****                ^ not supported yet
    298. 

  298.   123      END (* IF decplaces=0 *);
    299. 

  299.   124      Replace(alias, fieldnum, nstring);
    300. 

  300. *****      ^ not supported yet
    301. 

  301. *****              ^ not supported yet
    302. 

  302. *****                               ^ not supported yet
    303. 

  303.   125    END (* With *);
    304. 

  304. *****    ^ not supported yet
    305. 

  305.   126  END ReplaceN;
    306. 

  306. *****      ^ not supported yet
    307. 

  307.   127  
    308. 

  308.   128  END DBFields.
    309. 

  309. *****      ^ not supported yet
    310. 

  310. 

  311.   179 errors
    312. 

  312. 

  313.