Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a084 / 2.ddi / CKSAMPLE / BQUERY.SCT < prev next >
Unknown | 1993-05-25 | 18.5 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`66%`	dexvert	Sound Control Module `(music/soundControl)`	ext	Supported
`100%`	file	Adobe Photoshop Color swatch, version 0, 575 colors; 1st RGB space (0), w 0x21, x 0, y 0, z 0 ; 2nd RGB space (0), w 0, x 0, y 0, z 0	default (weak)
`99%`	file	data	default
`100%`	TrID	MacBinary 1	default (weak)
`100%`	siegfried	x-fmt/342 Microsoft FoxPro Memo	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 02 3f 00 00 00 21 | 00 00 00 00 00 00 00 00 |...?...!|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000210| 00 00 00 01 00 00 00 0a | 42 75 69 6c 64 51 75 65 |........|BuildQue|
|00000220| 72 79 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ry......|........|
|00000230| 00 00 00 00 01 00 00 00 | 0d 4d 53 20 53 61 6e 73 |........|.MS Sans|
|00000240| 20 53 65 72 69 66 00 00 | 00 00 00 00 00 00 00 00 | Serif..|........|
|00000250| 00 00 00 00 00 01 00 00 | 00 0f 22 20 42 75 69 6c |........|.." Buil|
|00000260| 64 20 51 75 65 72 79 20 | 22 00 00 00 00 00 00 00 |d Query |".......|
|00000270| 00 00 00 00 00 00 01 00 | 00 01 b6 44 4f 20 62 75 |........|...DO bu|
|00000280| 69 6c 64 73 6c 69 73 74 | 0d 0a 44 4f 20 62 75 69 |ildslist|..DO bui|
|00000290| 6c 64 73 70 6f 70 0d 0a | 0d 0a 73 71 6c 73 65 6c |ldspop..|..sqlsel|
|000002a0| 65 63 74 20 3d 20 62 75 | 69 6c 64 73 71 6c 28 29 |ect = bu|ildsql()|
|000002b0| 0d 0a 0d 0a 49 46 20 28 | 65 78 69 74 61 63 74 69 |....IF (|exitacti|
|000002c0| 6f 6e 20 3d 3d 20 31 29 | 0d 0a 09 44 4f 20 78 71 |on == 1)|...DO xq|
|000002d0| 75 65 72 79 20 57 49 54 | 48 20 73 71 6c 73 65 6c |uery WIT|H sqlsel|
|000002e0| 65 63 74 0d 0a 09 52 45 | 54 55 52 4e 20 2e 46 2e |ect...RE|TURN .F.|
|000002f0| 0d 0a 45 4c 53 45 0d 0a | 09 49 46 20 28 65 78 69 |..ELSE..|.IF (exi|
|00000300| 74 61 63 74 69 6f 6e 20 | 3d 3d 20 32 29 0d 0a 09 |taction |== 2)...|
|00000310| 09 48 49 44 45 20 57 49 | 4e 44 4f 57 20 62 75 69 |.HIDE WI|NDOW bui|
|00000320| 6c 64 71 75 65 72 79 0d | 0a 09 09 44 4f 20 65 64 |ldquery.|...DO ed|
|00000330| 69 74 71 75 65 72 2e 73 | 70 72 0d 0a 09 09 52 45 |itquer.s|pr....RE|
|00000340| 54 55 52 4e 20 2e 54 2e | 0d 0a 09 45 4c 53 45 0d |TURN .T.|...ELSE.|
|00000350| 0a 09 09 49 46 20 28 65 | 78 69 74 61 63 74 69 6f |...IF (e|xitactio|
|00000360| 6e 20 3d 3d 20 33 29 0d | 0a 09 09 09 44 49 4d 45 |n == 3).|....DIME|
|00000370| 4e 53 49 4f 4e 20 66 72 | 6f 6d 6c 69 73 74 5b 31 |NSION fr|omlist[1|
|00000380| 5d 0d 0a 09 09 09 44 49 | 4d 45 4e 53 49 4f 4e 20 |].....DI|MENSION |
|00000390| 73 65 6c 65 63 74 6c 69 | 73 74 5b 31 5d 0d 0a 09 |selectli|st[1]...|
|000003a0| 09 09 44 49 4d 45 4e 53 | 49 4f 4e 20 77 68 65 72 |..DIMENS|ION wher|
|000003b0| 65 6c 69 73 74 5b 31 5d | 0d 0a 09 09 09 44 4f 20 |elist[1]|.....DO |
|000003c0| 62 75 69 6c 64 66 70 6f | 70 0d 0a 09 09 09 44 4f |buildfpo|p.....DO|
|000003d0| 20 62 75 69 6c 64 73 70 | 6f 70 0d 0a 09 09 09 53 | buildsp|op.....S|
|000003e0| 48 4f 57 20 47 45 54 20 | 65 64 69 74 77 68 65 72 |HOW GET |editwher|
|000003f0| 65 0d 0a 09 09 09 52 45 | 54 55 52 4e 20 2e 46 2e |e.....RE|TURN .F.|
|00000400| 0d 0a 09 09 45 4c 53 45 | 0d 0a 09 09 09 52 45 54 |....ELSE|.....RET|
|00000410| 55 52 4e 20 2e 54 2e 0d | 0a 09 09 45 4e 44 49 46 |URN .T..|...ENDIF|
|00000420| 0d 0a 09 45 4e 44 49 46 | 0d 0a 45 4e 44 49 46 0d |...ENDIF|..ENDIF.|
|00000430| 0a 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 01 00 00 00 | b2 69 66 20 61 6c 65 6e |........|.if alen|
|00000450| 28 66 72 6f 6d 6c 69 73 | 74 29 20 3c 20 33 0d 0a |(fromlis|t) < 3..|
|00000460| 09 73 68 6f 77 20 67 65 | 74 20 64 75 6d 6d 79 20 |.show ge|t dummy |
|00000470| 64 69 73 61 62 6c 65 64 | 0d 0a 65 6c 73 65 0d 0a |disabled|..else..|
|00000480| 09 73 68 6f 77 20 67 65 | 74 20 64 75 6d 6d 79 20 |.show ge|t dummy |
|00000490| 65 6e 61 62 6c 65 64 0d | 0a 65 6e 64 69 66 0d 0a |enabled.|.endif..|
|000004a0| 69 66 20 61 6c 65 6e 28 | 66 72 6f 6d 6c 69 73 74 |if alen(|fromlist|
|000004b0| 29 20 3c 20 32 0d 0a 09 | 73 68 6f 77 20 67 65 74 |) < 2...|show get|
|000004c0| 20 77 68 65 72 65 62 75 | 74 20 64 69 73 61 62 6c | wherebu|t disabl|
|000004d0| 65 64 0d 0a 65 6c 73 65 | 0d 0a 09 73 68 6f 77 20 |ed..else|...show |
|000004e0| 67 65 74 20 77 68 65 72 | 65 62 75 74 20 65 6e 61 |get wher|ebut ena|
|000004f0| 62 6c 65 64 0d 0a 65 6e | 64 69 66 00 00 00 00 00 |bled..en|dif.....|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 f5 44 |........|.......D|
|00000510| 4f 20 62 75 69 6c 64 74 | 6c 69 73 74 0d 0a 0d 0a |O buildt|list....|
|00000520| 49 46 20 28 41 4c 45 4e | 28 74 61 62 6c 65 6c 69 |IF (ALEN|(tableli|
|00000530| 73 74 29 20 3c 20 32 29 | 0d 0a 09 3f 3f 20 43 48 |st) < 2)|...?? CH|
|00000540| 52 28 37 29 0d 0a 09 57 | 41 49 54 20 57 49 4e 44 |R(7)...W|AIT WIND|
|00000550| 4f 57 20 22 4e 6f 20 74 | 61 62 6c 65 73 20 69 6e |OW "No t|ables in|
|00000560| 20 64 61 74 61 62 61 73 | 65 22 0d 0a 09 52 45 54 | databas|e"...RET|
|00000570| 55 52 4e 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 44 45 |URN..END|IF....DE|
|00000580| 46 49 4e 45 20 50 4f 50 | 55 50 20 62 71 73 65 6c |FINE POP|UP bqsel|
|00000590| 65 63 74 70 6f 70 20 53 | 43 52 4f 4c 4c 20 4d 41 |ectpop S|CROLL MA|
|000005a0| 52 47 49 4e 20 4d 41 52 | 4b 20 22 20 22 20 4d 4f |RGIN MAR|K " " MO|
|000005b0| 56 45 52 0d 0a 44 45 46 | 49 4e 45 20 50 4f 50 55 |VER..DEF|INE POPU|
|000005c0| 50 20 62 71 66 72 6f 6d | 70 6f 70 20 20 20 53 43 |P bqfrom|pop   SC|
|000005d0| 52 4f 4c 4c 20 4d 41 52 | 47 49 4e 20 4d 41 52 4b |ROLL MAR|GIN MARK|
|000005e0| 20 22 20 22 0d 0a 0d 0a | 44 4f 20 62 75 69 6c 64 | " "....|DO build|
|000005f0| 66 70 6f 70 0d 0a 44 4f | 20 62 75 69 6c 64 73 70 |fpop..DO| buildsp|
|00000600| 6f 70 0d 0a 00 00 00 00 | 00 00 00 00 00 00 00 00 |op......|........|
|00000610| 00 00 01 00 00 09 77 52 | 45 4c 45 41 53 45 20 50 |......wR|ELEASE P|
|00000620| 4f 50 55 50 20 62 71 73 | 65 6c 65 63 74 70 6f 70 |OPUP bqs|electpop|
|00000630| 0d 0a 52 45 4c 45 41 53 | 45 20 50 4f 50 55 50 20 |..RELEAS|E POPUP |
|00000640| 62 71 66 72 6f 6d 70 6f | 70 0d 0a 52 45 54 55 52 |bqfrompo|p..RETUR|
|00000650| 4e 0d 0a 0d 0a 0d 0a 46 | 55 4e 43 54 49 4f 4e 20 |N......F|UNCTION |
|00000660| 69 6e 66 72 6f 6d 6c 69 | 73 74 0d 0a 50 41 52 41 |infromli|st..PARA|
|00000670| 4d 45 54 45 52 20 74 61 | 62 6c 65 6e 61 6d 65 0d |METER ta|blename.|
|00000680| 0a 50 52 49 56 41 54 45 | 20 6e 66 72 6f 6d 73 2c |.PRIVATE| nfroms,|
|00000690| 20 69 0d 0a 6e 66 72 6f | 6d 73 20 3d 20 41 4c 45 | i..nfro|ms = ALE|
|000006a0| 4e 28 66 72 6f 6d 6c 69 | 73 74 29 0d 0a 46 4f 52 |N(fromli|st)..FOR|
|000006b0| 20 69 20 3d 20 31 20 54 | 4f 20 6e 66 72 6f 6d 73 | i = 1 T|O nfroms|
|000006c0| 20 2d 20 31 0d 0a 09 49 | 46 20 28 74 61 62 6c 65 | - 1...I|F (table|
|000006d0| 6e 61 6d 65 20 3d 3d 20 | 66 72 6f 6d 6c 69 73 74 |name == |fromlist|
|000006e0| 5b 69 5d 29 0d 0a 09 09 | 52 45 54 55 52 4e 20 2e |[i])....|RETURN .|
|000006f0| 54 2e 0d 0a 09 45 4e 44 | 49 46 0d 0a 45 4e 44 46 |T....END|IF..ENDF|
|00000700| 4f 52 0d 0a 52 45 54 55 | 52 4e 20 2e 46 2e 0d 0a |OR..RETU|RN .F...|
|00000710| 0d 0a 50 52 4f 43 45 44 | 55 52 45 20 64 65 6c 77 |..PROCED|URE delw|
|00000720| 68 65 72 65 0d 0a 50 41 | 52 41 4d 45 54 45 52 20 |here..PA|RAMETER |
|00000730| 69 0d 0a 50 52 49 56 41 | 54 45 20 6c 65 6e 6c 69 |i..PRIVA|TE lenli|
|00000740| 73 74 0d 0a 3d 20 41 44 | 45 4c 28 77 68 65 72 65 |st..= AD|EL(where|
|00000750| 6c 69 73 74 2c 20 69 29 | 0d 0a 6c 65 6e 6c 69 73 |list, i)|..lenlis|
|00000760| 74 20 3d 20 41 4c 45 4e | 28 77 68 65 72 65 6c 69 |t = ALEN|(whereli|
|00000770| 73 74 29 0d 0a 49 46 20 | 28 69 20 21 3d 20 31 29 |st)..IF |(i != 1)|
|00000780| 0d 0a 09 3d 20 41 44 45 | 4c 28 77 68 65 72 65 6c |...= ADE|L(wherel|
|00000790| 69 73 74 2c 20 69 20 2d | 20 31 29 0d 0a 09 6c 65 |ist, i -| 1)...le|
|000007a0| 6e 6c 69 73 74 20 3d 20 | 6c 65 6e 6c 69 73 74 20 |nlist = |lenlist |
|000007b0| 2d 20 31 0d 0a 45 4c 53 | 45 09 09 09 20 20 26 26 |- 1..ELS|E...  &&|
|000007c0| 20 69 20 3d 3d 20 31 2c | 20 73 6f 20 6c 6f 67 69 | i == 1,| so logi|
|000007d0| 63 61 6c 20 63 6f 6e 6e | 65 63 74 6f 72 20 66 6f |cal conn|ector fo|
|000007e0| 6c 6c 6f 77 73 0d 0a 09 | 49 46 20 28 6c 65 6e 6c |llows...|IF (lenl|
|000007f0| 69 73 74 20 3e 20 31 29 | 20 20 26 26 20 69 66 20 |ist > 1)|  && if |
|00000800| 74 68 65 72 65 20 69 73 | 20 6f 6e 65 0d 0a 09 09 |there is| one....|
|00000810| 3d 20 41 44 45 4c 28 77 | 68 65 72 65 6c 69 73 74 |= ADEL(w|herelist|
|00000820| 2c 20 69 29 0d 0a 09 09 | 6c 65 6e 6c 69 73 74 20 |, i)....|lenlist |
|00000830| 3d 20 6c 65 6e 6c 69 73 | 74 20 2d 20 31 0d 0a 09 |= lenlis|t - 1...|
|00000840| 45 4e 44 49 46 0d 0a 45 | 4e 44 49 46 0d 0a 44 49 |ENDIF..E|NDIF..DI|
|00000850| 4d 45 4e 53 49 4f 4e 20 | 77 68 65 72 65 6c 69 73 |MENSION |wherelis|
|00000860| 74 5b 4d 41 58 28 6c 65 | 6e 4c 69 73 74 20 2d 20 |t[MAX(le|nList - |
|00000870| 31 2c 20 31 29 5d 0d 0a | 52 45 54 55 52 4e 0d 0a |1, 1)]..|RETURN..|
|00000880| 0d 0a 50 52 4f 43 45 44 | 55 52 45 20 62 75 69 6c |..PROCED|URE buil|
|00000890| 64 73 6c 69 73 74 0d 0a | 50 52 49 56 41 54 45 20 |dslist..|PRIVATE |
|000008a0| 6c 65 6e 6c 69 73 74 2c | 20 69 2c 20 43 4f 55 4e |lenlist,| i, COUN|
|000008b0| 54 2c 20 6e 65 77 6f 72 | 64 65 72 2c 20 74 61 62 |T, newor|der, tab|
|000008c0| 6c 65 6e 61 6d 65 0d 0a | 2a 0d 0a 2a 09 47 65 74 |lename..|*..*.Get|
|000008d0| 20 63 75 72 72 65 6e 74 | 20 6f 72 64 65 72 20 6f | current| order o|
|000008e0| 6e 20 70 6f 70 75 70 0d | 0a 2a 0d 0a 6c 65 6e 6c |n popup.|.*..lenl|
|000008f0| 69 73 74 20 3d 20 41 4c | 45 4e 28 73 65 6c 65 63 |ist = AL|EN(selec|
|00000900| 74 6c 69 73 74 29 20 2d | 20 31 0d 0a 44 49 4d 45 |tlist) -| 1..DIME|
|00000910| 4e 53 49 4f 4e 20 6e 65 | 77 6f 72 64 65 72 5b 6c |NSION ne|worder[l|
|00000920| 65 6e 4c 69 73 74 20 2b | 20 31 5d 0d 0a 46 4f 52 |enList +| 1]..FOR|
|00000930| 20 69 20 3d 20 31 20 54 | 4f 20 6c 65 6e 6c 69 73 | i = 1 T|O lenlis|
|00000940| 74 0d 0a 09 6e 65 77 6f | 72 64 65 72 5b 69 5d 20 |t...newo|rder[i] |
|00000950| 3d 20 73 65 6c 65 63 74 | 6c 69 73 74 5b 47 45 54 |= select|list[GET|
|00000960| 42 41 52 28 22 42 51 53 | 65 6c 65 63 74 50 6f 22 |BAR("BQS|electPo"|
|00000970| 2c 20 69 29 5d 0d 0a 45 | 4e 44 46 4f 52 0d 0a 46 |, i)]..E|NDFOR..F|
|00000980| 4f 52 20 69 20 3d 20 31 | 20 54 4f 20 6c 65 6e 6c |OR i = 1| TO lenl|
|00000990| 69 73 74 0d 0a 09 73 65 | 6c 65 63 74 6c 69 73 74 |ist...se|lectlist|
|000009a0| 5b 69 5d 20 3d 20 6e 65 | 77 6f 72 64 65 72 5b 69 |[i] = ne|worder[i|
|000009b0| 5d 0d 0a 45 4e 44 46 4f | 52 0d 0a 2a 0d 0a 2a 09 |]..ENDFO|R..*..*.|
|000009c0| 43 68 65 63 6b 20 61 67 | 61 69 6e 73 74 20 46 52 |Check ag|ainst FR|
|000009d0| 4f 4d 20 6c 69 73 74 0d | 0a 2a 0d 0a 69 20 3d 20 |OM list.|.*..i = |
|000009e0| 31 20 26 26 20 61 63 63 | 6f 75 6e 74 20 66 6f 72 |1 && acc|ount for|
|000009f0| 20 64 65 6c 65 74 65 73 | 20 66 72 6f 6d 20 61 72 | deletes| from ar|
|00000a00| 72 61 79 20 53 65 6c 65 | 63 74 4c 69 73 74 20 77 |ray Sele|ctList w|
|00000a10| 68 69 63 68 20 6d 6f 76 | 65 73 20 65 76 65 72 79 |hich mov|es every|
|00000a20| 74 68 69 6e 67 20 75 70 | 0d 0a 46 4f 52 20 43 4f |thing up|..FOR CO|
|00000a30| 55 4e 54 20 3d 20 31 20 | 54 4f 20 6c 65 6e 6c 69 |UNT = 1 |TO lenli|
|00000a40| 73 74 0d 0a 09 2a 0d 0a | 09 2a 09 09 45 78 74 72 |st...*..|.*..Extr|
|00000a50| 61 63 74 20 74 61 62 6c | 65 20 6e 61 6d 65 20 66 |act tabl|e name f|
|00000a60| 72 6f 6d 20 63 6f 6c 75 | 6d 6e 20 6e 61 6d 65 0d |rom colu|mn name.|
|00000a70| 0a 09 2a 0d 0a 09 74 61 | 62 6c 65 6e 61 6d 65 20 |..*...ta|blename |
|00000a80| 3d 20 53 55 42 53 54 52 | 28 73 65 6c 65 63 74 6c |= SUBSTR|(selectl|
|00000a90| 69 73 74 5b 69 5d 2c 20 | 31 2c 20 41 54 28 22 2e |ist[i], |1, AT(".|
|00000aa0| 22 2c 20 73 65 6c 65 63 | 74 6c 69 73 74 5b 69 5d |", selec|tlist[i]|
|00000ab0| 29 20 2d 20 31 29 0d 0a | 09 49 46 20 28 20 2e 4e |) - 1)..|.IF ( .N|
|00000ac0| 4f 54 2e 20 69 6e 66 72 | 6f 6d 6c 69 73 74 28 74 |OT. infr|omlist(t|
|00000ad0| 61 62 6c 65 6e 61 6d 65 | 29 29 0d 0a 09 09 3d 20 |ablename|))....= |
|00000ae0| 41 44 45 4c 28 73 65 6c | 65 63 74 6c 69 73 74 2c |ADEL(sel|ectlist,|
|00000af0| 20 69 29 0d 0a 09 45 4c | 53 45 0d 0a 09 09 69 20 | i)...EL|SE....i |
|00000b00| 3d 20 69 20 2b 20 31 0d | 0a 09 45 4e 44 49 46 0d |= i + 1.|..ENDIF.|
|00000b10| 0a 45 4e 44 46 4f 52 0d | 0a 44 49 4d 45 4e 53 49 |.ENDFOR.|.DIMENSI|
|00000b20| 4f 4e 20 73 65 6c 65 63 | 74 6c 69 73 74 5b 69 5d |ON selec|tlist[i]|
|00000b30| 0d 0a 52 45 54 55 52 4e | 20 20 26 26 20 50 52 4f |..RETURN|  && PRO|
|00000b40| 43 45 44 55 52 45 20 42 | 75 69 6c 64 53 4c 69 73 |CEDURE B|uildSLis|
|00000b50| 74 0d 0a 0d 0a 0d 0a 50 | 52 4f 43 45 44 55 52 45 |t......P|ROCEDURE|
|00000b60| 20 62 75 69 6c 64 73 70 | 6f 70 0d 0a 50 52 49 56 | buildsp|op..PRIV|
|00000b70| 41 54 45 20 6c 65 6e 6c | 69 73 74 2c 20 69 0d 0a |ATE lenl|ist, i..|
|00000b80| 52 45 4c 45 41 53 45 20 | 42 41 52 20 41 4c 4c 20 |RELEASE |BAR ALL |
|00000b90| 4f 46 20 62 71 73 65 6c | 65 63 74 70 6f 70 0d 0a |OF bqsel|ectpop..|
|00000ba0| 6c 65 6e 6c 69 73 74 20 | 3d 20 41 4c 45 4e 28 73 |lenlist |= ALEN(s|
|00000bb0| 65 6c 65 63 74 6c 69 73 | 74 29 20 2d 20 31 0d 0a |electlis|t) - 1..|
|00000bc0| 46 4f 52 20 69 20 3d 20 | 31 20 54 4f 20 6c 65 6e |FOR i = |1 TO len|
|00000bd0| 6c 69 73 74 0d 0a 09 44 | 45 46 49 4e 45 20 42 41 |list...D|EFINE BA|
|00000be0| 52 20 28 69 29 20 4f 46 | 20 62 71 73 65 6c 65 63 |R (i) OF| bqselec|
|00000bf0| 74 70 6f 70 20 50 52 4f | 4d 50 54 20 73 65 6c 65 |tpop PRO|MPT sele|
|00000c00| 63 74 6c 69 73 74 5b 69 | 5d 0d 0a 45 4e 44 46 4f |ctlist[i|]..ENDFO|
|00000c10| 52 0d 0a 53 48 4f 57 20 | 47 45 54 20 73 65 6c 65 |R..SHOW |GET sele|
|00000c20| 63 74 70 6f 70 0d 0a 52 | 45 54 55 52 4e 0d 0a 0d |ctpop..R|ETURN...|
|00000c30| 0a 0d 0a 50 52 4f 43 45 | 44 55 52 45 20 62 75 69 |...PROCE|DURE bui|
|00000c40| 6c 64 66 70 6f 70 0d 0a | 50 52 49 56 41 54 45 20 |ldfpop..|PRIVATE |
|00000c50| 6c 65 6e 6c 69 73 74 0d | 0a 52 45 4c 45 41 53 45 |lenlist.|.RELEASE|
|00000c60| 20 42 41 52 20 41 4c 4c | 20 4f 46 20 62 71 66 72 | BAR ALL| OF bqfr|
|00000c70| 6f 6d 70 6f 70 0d 0a 6c | 65 6e 6c 69 73 74 20 3d |ompop..l|enlist =|
|00000c80| 20 41 4c 45 4e 28 66 72 | 6f 6d 6c 69 73 74 29 20 | ALEN(fr|omlist) |
|00000c90| 2d 20 31 0d 0a 46 4f 52 | 20 69 20 3d 20 31 20 54 |- 1..FOR| i = 1 T|
|00000ca0| 4f 20 6c 65 6e 6c 69 73 | 74 0d 0a 09 44 45 46 49 |O lenlis|t...DEFI|
|00000cb0| 4e 45 20 42 41 52 20 28 | 69 29 20 4f 46 20 62 71 |NE BAR (|i) OF bq|
|00000cc0| 66 72 6f 6d 70 6f 70 20 | 50 52 4f 4d 50 54 20 66 |frompop |PROMPT f|
|00000cd0| 72 6f 6d 6c 69 73 74 5b | 69 5d 0d 0a 45 4e 44 46 |romlist[|i]..ENDF|
|00000ce0| 4f 52 0d 0a 53 48 4f 57 | 20 47 45 54 20 66 70 6f |OR..SHOW| GET fpo|
|00000cf0| 70 64 75 6d 6d 79 0d 0a | 52 45 54 55 52 4e 0d 0a |pdummy..|RETURN..|
|00000d00| 0d 0a 0d 0a 50 52 4f 43 | 45 44 55 52 45 20 62 75 |....PROC|EDURE bu|
|00000d10| 69 6c 64 63 6c 69 73 74 | 0d 0a 44 49 4d 45 4e 53 |ildclist|..DIMENS|
|00000d20| 49 4f 4e 20 63 6f 6c 75 | 6d 6e 6c 69 73 74 5b 31 |ION colu|mnlist[1|
|00000d30| 5d 0d 0a 6e 66 72 6f 6d | 20 3d 20 41 4c 45 4e 28 |]..nfrom| = ALEN(|
|00000d40| 66 72 6f 6d 6c 69 73 74 | 29 0d 0a 46 4f 52 20 69 |fromlist|)..FOR i|
|00000d50| 20 3d 20 31 20 54 4f 20 | 6e 66 72 6f 6d 20 2d 20 | = 1 TO |nfrom - |
|00000d60| 31 0d 0a 09 44 4f 20 61 | 64 64 63 6f 6c 75 6d 6e |1...DO a|ddcolumn|
|00000d70| 73 20 57 49 54 48 20 66 | 72 6f 6d 6c 69 73 74 5b |s WITH f|romlist[|
|00000d80| 69 5d 0d 0a 45 4e 44 46 | 4f 52 0d 0a 52 45 54 55 |i]..ENDF|OR..RETU|
|00000d90| 52 4e 0d 0a 0d 0a 0d 0a | 50 52 4f 43 45 44 55 52 |RN......|PROCEDUR|
|00000da0| 45 20 61 64 64 63 6f 6c | 75 6d 6e 73 0d 0a 50 41 |E addcol|umns..PA|
|00000db0| 52 41 4d 45 54 45 52 20 | 74 61 62 6c 65 6e 61 6d |RAMETER |tablenam|
|00000dc0| 65 0d 0a 50 52 49 56 41 | 54 45 20 6c 65 6e 6c 69 |e..PRIVA|TE lenli|
|00000dd0| 73 74 0d 0a 49 46 20 28 | 63 6b 68 61 6e 64 6c 65 |st..IF (|ckhandle|
|00000de0| 20 3d 3d 20 30 29 0d 0a | 09 53 45 4c 45 43 54 20 | == 0)..|.SELECT |
|00000df0| 30 0d 0a 09 55 53 45 20 | 63 6f 6c 75 6d 6e 73 0d |0...USE |columns.|
|00000e00| 0a 45 4c 53 45 0d 0a 09 | 49 46 20 28 6d 2e 61 73 |.ELSE...|IF (m.as|
|00000e10| 79 6e 63 68 20 3d 3d 20 | 31 29 20 26 26 20 41 73 |ynch == |1) && As|
|00000e20| 79 6e 63 68 0d 0a 09 09 | 72 65 74 63 6f 64 65 20 |ynch....|retcode |
|00000e30| 3d 20 30 0d 0a 09 09 44 | 4f 20 57 48 49 4c 45 20 |= 0....D|O WHILE |
|00000e40| 28 72 65 74 63 6f 64 65 | 20 3d 3d 20 30 29 0d 0a |(retcode| == 0)..|
|00000e50| 09 09 09 72 65 74 63 6f | 64 65 20 3d 20 64 62 63 |...retco|de = dbc|
|00000e60| 6f 6c 73 28 63 6b 68 61 | 6e 64 6c 65 2c 20 74 61 |ols(ckha|ndle, ta|
|00000e70| 62 6c 65 6e 61 6d 65 2c | 20 22 4e 61 74 69 76 65 |blename,| "Native|
|00000e80| 22 29 0d 0a 09 09 45 4e | 44 44 4f 0d 0a 09 45 4c |")....EN|DDO...EL|
|00000e90| 53 45 0d 0a 09 09 72 65 | 74 63 6f 64 65 20 3d 20 |SE....re|tcode = |
|00000ea0| 20 64 62 63 6f 6c 73 28 | 63 6b 68 61 6e 64 6c 65 | dbcols(|ckhandle|
|00000eb0| 2c 20 74 61 62 6c 65 6e | 61 6d 65 2c 20 22 4e 61 |, tablen|ame, "Na|
|00000ec0| 74 69 76 65 22 29 0d 0a | 09 45 4e 44 49 46 0d 0a |tive")..|.ENDIF..|
|00000ed0| 45 4e 44 49 46 0d 0a 6c | 65 6e 6c 69 73 74 20 3d |ENDIF..l|enlist =|
|00000ee0| 20 41 4c 45 4e 28 63 6f | 6c 75 6d 6e 6c 69 73 74 | ALEN(co|lumnlist|
|00000ef0| 29 0d 0a 44 49 4d 45 4e | 53 49 4f 4e 20 63 6f 6c |)..DIMEN|SION col|
|00000f00| 75 6d 6e 6c 69 73 74 5b | 6c 65 6e 4c 69 73 74 20 |umnlist[|lenList |
|00000f10| 2b 20 52 45 43 43 4f 28 | 29 5d 0d 0a 53 43 41 4e |+ RECCO(|)]..SCAN|
|00000f20| 0d 0a 09 63 6f 6c 75 6d | 6e 6c 69 73 74 5b 6c 65 |...colum|nlist[le|
|00000f30| 6e 4c 69 73 74 5d 20 3d | 20 74 61 62 6c 65 6e 61 |nList] =| tablena|
|00000f40| 6d 65 20 2b 20 22 2e 22 | 20 2b 20 41 4c 4c 54 52 |me + "."| + ALLTR|
|00000f50| 49 4d 28 63 6f 6c 75 6d | 6e 5f 6e 61 6d 29 0d 0a |IM(colum|n_nam)..|
|00000f60| 09 6c 65 6e 6c 69 73 74 | 20 3d 20 6c 65 6e 6c 69 |.lenlist| = lenli|
|00000f70| 73 74 20 2b 20 31 0d 0a | 45 4e 44 53 43 41 4e 0d |st + 1..|ENDSCAN.|
|00000f80| 0a 55 53 45 0d 0a 52 45 | 54 55 52 4e 0d 0a 00 00 |.USE..RE|TURN....|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000fa0| 0d 4d 53 20 53 61 6e 73 | 20 53 65 72 69 66 00 00 |.MS Sans| Serif..|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000fc0| 00 0a 45 78 69 74 41 63 | 74 69 6f 6e 00 00 00 00 |..ExitAc|tion....|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000fe0| 00 00 2e 22 40 2a 56 54 | 20 5c 21 20 45 5c 3c 78 |..."@*VT| \! E\<x|
|00000ff0| 65 63 75 74 65 20 3b 5c | 3c 45 64 69 74 2e 2e 2e |ecute ;\|<Edit...|
|00001000| 3b 43 5c 3c 6c 65 61 72 | 3b 5c 3f 43 6c 6f 73 65 |;C\<lear|;\?Close|
|00001010| 22 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |".......|........|
|00001020| 01 00 00 00 0b 22 20 45 | 78 65 63 75 74 65 20 22 |....." E|xecute "|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|00001050| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|00001060| 00 00 01 00 00 00 0a 46 | 72 6f 6d 42 75 74 74 6f |.......F|romButto|
|00001070| 6e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |n.......|........|
|00001080| 00 00 00 01 00 00 00 10 | 22 40 2a 56 4e 20 5c 3c |........|"@*VN \<|
|00001090| 46 72 6f 6d 2e 2e 2e 22 | 00 00 00 00 00 00 00 00 |From..."|........|
|000010a0| 00 00 00 00 01 00 00 04 | 4a 50 52 49 56 41 54 45 |........|JPRIVATE|
|000010b0| 20 69 2c 20 74 61 62 6c | 65 6e 61 6d 65 2c 20 43 | i, tabl|ename, C|
|000010c0| 4f 55 4e 54 2c 20 49 4e | 4c 49 53 54 0d 0a 0d 0a |OUNT, IN|LIST....|
|000010d0| 44 4f 20 66 72 6f 6d 2e | 73 70 72 0d 0a 44 4f 20 |DO from.|spr..DO |
|000010e0| 62 75 69 6c 64 66 70 6f | 70 0d 0a 0d 0a 44 4f 20 |buildfpo|p....DO |
|000010f0| 62 75 69 6c 64 73 6c 69 | 73 74 0d 0a 44 4f 20 62 |buildsli|st..DO b|
|00001100| 75 69 6c 64 73 70 6f 70 | 0d 0a 0d 0a 44 4f 20 62 |uildspop|....DO b|
|00001110| 75 69 6c 64 63 6c 69 73 | 74 0d 0a 2a 0d 0a 2a 09 |uildclis|t..*..*.|
|00001120| 52 65 62 75 69 6c 64 20 | 57 48 45 52 45 20 6c 69 |Rebuild |WHERE li|
|00001130| 73 74 2e 20 4d 75 73 74 | 20 64 6f 20 74 68 69 73 |st. Must| do this|
|00001140| 2c 20 62 65 63 61 75 73 | 65 20 74 68 65 20 72 65 |, becaus|e the re|
|00001150| 6d 6f 76 61 6c 20 6f 66 | 20 61 0d 0a 2a 09 74 61 |moval of| a..*.ta|
|00001160| 62 6c 65 20 63 6f 75 6c | 64 20 6d 65 61 6e 20 73 |ble coul|d mean s|
|00001170| 6f 6d 65 20 6f 66 20 74 | 68 65 73 65 20 63 6f 6c |ome of t|hese col|
|00001180| 75 6d 6e 73 20 63 61 6e | 20 6e 6f 20 6c 6f 6e 67 |umns can| no long|
|00001190| 65 72 20 62 65 0d 0a 2a | 09 53 45 4c 45 43 54 65 |er be..*|.SELECTe|
|000011a0| 64 2e 0d 0a 2a 0d 0a 69 | 20 3d 20 31 20 26 26 20 |d...*..i| = 1 && |
|000011b0| 61 63 63 6f 75 6e 74 20 | 66 6f 72 20 64 65 6c 65 |account |for dele|
|000011c0| 74 65 73 20 66 72 6f 6d | 20 61 72 72 61 79 20 77 |tes from| array w|
|000011d0| 68 69 63 68 20 6d 6f 76 | 65 73 20 65 76 65 72 79 |hich mov|es every|
|000011e0| 74 68 69 6e 67 20 75 70 | 0d 0a 44 4f 20 57 48 49 |thing up|..DO WHI|
|000011f0| 4c 45 20 28 69 20 3c 20 | 41 4c 45 4e 28 77 68 65 |LE (i < |ALEN(whe|
|00001200| 72 65 6c 69 73 74 29 29 | 0d 0a 09 2a 0d 0a 09 2a |relist))|...*...*|
|00001210| 09 09 45 78 74 72 61 63 | 74 20 74 61 62 6c 65 20 |..Extrac|t table |
|00001220| 6e 61 6d 65 73 20 66 72 | 6f 6d 20 57 48 45 52 45 |names fr|om WHERE|
|00001230| 20 63 6f 6e 64 69 74 69 | 6f 6e 0d 0a 09 2a 0d 0a | conditi|on...*..|
|00001240| 09 72 65 73 74 6f 66 77 | 68 65 72 65 20 3d 20 77 |.restofw|here = w|
|00001250| 68 65 72 65 6c 69 73 74 | 5b 69 5d 0d 0a 09 44 49 |herelist|[i]...DI|
|00001260| 4d 45 4e 53 49 4f 4e 20 | 74 61 62 6c 65 6e 61 6d |MENSION |tablenam|
|00001270| 65 5b 31 5d 0d 0a 09 44 | 4f 20 57 48 49 4c 45 20 |e[1]...D|O WHILE |
|00001280| 2e 54 2e 0d 0a 09 09 65 | 6e 64 73 65 70 20 3d 20 |.T.....e|ndsep = |
|00001290| 41 54 28 22 2e 22 2c 20 | 72 65 73 74 6f 66 77 68 |AT(".", |restofwh|
|000012a0| 65 72 65 29 0d 0a 09 09 | 49 46 20 28 65 6e 64 73 |ere)....|IF (ends|
|000012b0| 65 70 20 3e 20 30 29 0d | 0a 09 09 09 62 65 67 73 |ep > 0).|....begs|
|000012c0| 65 70 20 3d 20 52 41 54 | 28 22 20 22 2c 20 53 55 |ep = RAT|(" ", SU|
|000012d0| 42 53 54 52 28 72 65 73 | 74 6f 66 77 68 65 72 65 |BSTR(res|tofwhere|
|000012e0| 2c 20 31 2c 20 65 6e 64 | 73 65 70 20 2d 20 31 29 |, 1, end|sep - 1)|
|000012f0| 29 0d 0a 09 09 09 49 4e | 4c 49 53 54 20 3d 20 41 |).....IN|LIST = A|
|00001300| 4c 45 4e 28 74 61 62 6c | 65 6e 61 6d 65 29 0d 0a |LEN(tabl|ename)..|
|00001310| 09 09 09 44 49 4d 45 4e | 53 49 4f 4e 20 74 61 62 |...DIMEN|SION tab|
|00001320| 6c 65 6e 61 6d 65 5b 49 | 4e 4c 49 53 54 20 2b 20 |lename[I|NLIST + |
|00001330| 31 5d 0d 0a 09 09 09 74 | 61 62 6c 65 6e 61 6d 65 |1].....t|ablename|
|00001340| 5b 49 4e 4c 49 53 54 5d | 20 3d 20 53 55 42 53 54 |[INLIST]| = SUBST|
|00001350| 52 28 72 65 73 74 6f 66 | 77 68 65 72 65 2c 20 62 |R(restof|where, b|
|00001360| 65 67 73 65 70 20 2b 20 | 31 2c 3b 0d 0a 09 09 09 |egsep + |1,;.....|
|00001370| 09 65 6e 64 73 65 70 20 | 2d 20 62 65 67 73 65 70 |.endsep |- begsep|
|00001380| 20 2d 20 31 29 0d 0a 09 | 09 09 72 65 73 74 6f 66 | - 1)...|..restof|
|00001390| 77 68 65 72 65 20 3d 20 | 53 55 42 53 54 52 28 72 |where = |SUBSTR(r|
|000013a0| 65 73 74 6f 66 77 68 65 | 72 65 2c 20 65 6e 64 73 |estofwhe|re, ends|
|000013b0| 65 70 20 2b 20 31 29 0d | 0a 09 09 45 4c 53 45 0d |ep + 1).|...ELSE.|
|000013c0| 0a 09 09 09 45 58 49 54 | 0d 0a 09 09 45 4e 44 49 |....EXIT|....ENDI|
|000013d0| 46 0d 0a 09 45 4e 44 44 | 4f 0d 0a 0d 0a 09 64 65 |F...ENDD|O.....de|
|000013e0| 6c 65 74 65 66 6c 61 67 | 20 3d 20 2e 46 2e 0d 0a |leteflag| = .F...|
|000013f0| 09 49 4e 4c 49 53 54 20 | 3d 20 41 4c 45 4e 28 74 |.INLIST |= ALEN(t|
|00001400| 61 62 6c 65 6e 61 6d 65 | 29 20 2d 20 31 0d 0a 09 |ablename|) - 1...|
|00001410| 46 4f 52 20 6a 20 3d 20 | 31 20 54 4f 20 49 4e 4c |FOR j = |1 TO INL|
|00001420| 49 53 54 0d 0a 0d 0a 09 | 09 49 46 20 28 20 2e 4e |IST.....|.IF ( .N|
|00001430| 4f 54 2e 20 69 6e 66 72 | 6f 6d 6c 69 73 74 28 74 |OT. infr|omlist(t|
|00001440| 61 62 6c 65 6e 61 6d 65 | 5b 6a 5d 29 29 0d 0a 09 |ablename|[j]))...|
|00001450| 09 09 44 4f 20 64 65 6c | 77 68 65 72 65 20 57 49 |..DO del|where WI|
|00001460| 54 48 20 69 0d 0a 09 09 | 09 64 65 6c 65 74 65 66 |TH i....|.deletef|
|00001470| 6c 61 67 20 3d 20 2e 54 | 2e 0d 0a 09 09 09 45 58 |lag = .T|......EX|
|00001480| 49 54 0d 0a 09 09 45 4e | 44 49 46 0d 0a 0d 0a 09 |IT....EN|DIF.....|
|00001490| 45 4e 44 46 4f 52 0d 0a | 0d 0a 09 49 46 20 28 20 |ENDFOR..|...IF ( |
|000014a0| 2e 4e 4f 54 2e 20 64 65 | 6c 65 74 65 66 6c 61 67 |.NOT. de|leteflag|
|000014b0| 29 0d 0a 09 09 69 20 3d | 20 69 20 2b 20 31 0d 0a |)....i =| i + 1..|
|000014c0| 09 45 4e 44 49 46 0d 0a | 0d 0a 45 4e 44 44 4f 0d |.ENDIF..|..ENDDO.|
|000014d0| 0a 53 48 4f 57 20 47 45 | 54 20 65 64 69 74 77 68 |.SHOW GE|T editwh|
|000014e0| 65 72 65 0d 0a 0d 0a 52 | 45 54 55 52 4e 20 2e 54 |ere....R|ETURN .T|
|000014f0| 2e 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001500| 00 00 00 00 00 00 01 00 | 00 00 09 22 46 72 6f 6d |........|..."From|
|00001510| 2e 2e 2e 22 00 00 00 00 | 00 00 00 00 00 00 00 00 |..."....|........|
|00001520| 00 00 00 00 00 00 00 01 | 00 00 00 07 46 72 6f 6d |........|....From|
|00001530| 50 6f 70 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |Pop.....|........|
|00001540| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 42 51 46 |........|.....BQF|
|00001550| 72 6f 6d 50 6f 70 00 00 | 00 00 00 00 00 00 00 00 |romPop..|........|
|00001560| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 22 40 |........|......"@|
|00001570| 26 4e 22 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |&N".....|........|
|00001580| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0d 4d |........|.......M|
|00001590| 53 20 53 61 6e 73 20 53 | 65 72 69 66 00 00 00 00 |S Sans S|erif....|
|000015a0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 01 |........|........|
|000015b0| 31 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|000015c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000015d0| 12 41 4c 45 4e 28 46 72 | 6f 6d 4c 69 73 74 29 20 |.ALEN(Fr|omList) |
|000015e0| 2d 20 31 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |- 1.....|........|
|000015f0| 00 09 53 65 6c 65 63 74 | 50 6f 70 00 00 00 00 00 |..Select|Pop.....|
|00001600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00001610| 00 00 0a 42 51 53 65 6c | 65 63 74 50 6f 00 00 00 |...BQSel|ectPo...|
|00001620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001630| 00 00 00 05 22 40 26 4e | 22 00 00 00 00 00 00 00 |...."@&N|".......|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001650| 01 00 00 00 0d 4d 53 20 | 53 61 6e 73 20 53 65 72 |.....MS |Sans Ser|
|00001660| 69 66 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |if......|........|
|00001670| 00 01 00 00 00 01 31 00 | 00 00 00 00 00 00 00 00 |......1.|........|
|00001680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001690| 00 00 01 00 00 00 14 41 | 4c 45 4e 28 53 65 6c 65 |.......A|LEN(Sele|
|000016a0| 63 74 4c 69 73 74 29 20 | 2d 20 31 00 00 00 00 00 |ctList) |- 1.....|
|000016b0| 00 00 00 01 00 00 00 2b | 44 4f 20 62 75 69 6c 64 |.......+|DO build|
|000016c0| 73 6c 69 73 74 0d 0a 44 | 4f 20 62 75 69 6c 64 73 |slist..D|O builds|
|000016d0| 70 6f 70 0d 0a 0d 0a 52 | 45 54 55 52 4e 20 2e 54 |pop....R|ETURN .T|
|000016e0| 2e 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 01 00 00 | 00 0d 4d 53 20 53 61 6e |........|..MS San|
|00001700| 73 20 53 65 72 69 66 00 | 00 00 00 00 00 00 00 00 |s Serif.|........|
|00001710| 00 00 00 00 00 00 01 00 | 00 00 0c 53 65 6c 65 63 |........|...Selec|
|00001720| 74 42 75 74 74 6f 6e 00 | 00 00 00 00 00 00 00 00 |tButton.|........|
|00001730| 00 00 00 00 00 00 00 01 | 00 00 00 12 22 40 2a 56 |........|...."@*V|
|00001740| 4e 20 5c 3c 53 65 6c 65 | 63 74 2e 2e 2e 22 00 00 |N \<Sele|ct..."..|
|00001750| 00 00 00 00 00 00 00 00 | 01 00 00 00 3a 44 4f 20 |........|....:DO |
|00001760| 62 75 69 6c 64 73 6c 69 | 73 74 0d 0a 44 4f 20 73 |buildsli|st..DO s|
|00001770| 65 6c 65 63 74 2e 73 70 | 72 0d 0a 44 4f 20 62 75 |elect.sp|r..DO bu|
|00001780| 69 6c 64 73 70 6f 70 0d | 0a 0d 0a 52 45 54 55 52 |ildspop.|...RETUR|
|00001790| 4e 20 2e 54 2e 0d 0a 00 | 00 00 01 00 00 00 0b 22 |N .T....|......."|
|000017a0| 53 65 6c 65 63 74 2e 2e | 2e 22 00 00 00 00 00 00 |Select..|."......|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0d |........|........|
|000017c0| 4d 53 20 53 61 6e 73 20 | 53 65 72 69 66 00 00 00 |MS Sans |Serif...|
|000017d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000017e0| 05 44 75 6d 6d 79 00 00 | 00 00 00 00 00 00 00 00 |.Dummy..|........|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00001800| 00 10 22 40 2a 56 4e 20 | 5c 3c 4a 6f 69 6e 2e 2e |.."@*VN |\<Join..|
|00001810| 2e 22 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |."......|........|
|00001820| 00 00 2d 44 4f 20 6a 6f | 69 6e 2e 73 70 72 0d 0a |..-DO jo|in.spr..|
|00001830| 53 48 4f 57 20 47 45 54 | 20 65 64 69 74 77 68 65 |SHOW GET| editwhe|
|00001840| 72 65 0d 0a 52 45 54 55 | 52 4e 20 2e 54 2e 0d 0a |re..RETU|RN .T...|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 01 00 00 00 09 22 4a 6f | 69 6e 2e 2e 2e 22 00 00 |....."Jo|in..."..|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|00001890| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|000018a0| 00 00 01 00 00 00 08 77 | 68 65 72 65 62 75 74 00 |.......w|herebut.|
|000018b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018c0| 00 00 00 01 00 00 00 11 | 22 40 2a 56 4e 20 5c 3c |........|"@*VN \<|
|000018d0| 57 68 65 72 65 2e 2e 2e | 22 00 00 00 00 00 00 00 |Where...|".......|
|000018e0| 00 00 00 00 01 00 00 00 | 2e 44 4f 20 77 68 65 72 |........|.DO wher|
|000018f0| 65 2e 73 70 72 0d 0a 53 | 48 4f 57 20 47 45 54 20 |e.spr..S|HOW GET |
|00001900| 65 64 69 74 77 68 65 72 | 65 0d 0a 52 45 54 55 52 |editwher|e..RETUR|
|00001910| 4e 20 2e 54 2e 0d 0a 00 | 00 00 00 00 00 00 00 00 |N .T....|........|
|00001920| 00 00 00 00 00 00 01 00 | 00 00 0a 22 57 68 65 72 |........|..."Wher|
|00001930| 65 2e 2e 2e 22 00 00 00 | 00 00 00 00 00 00 00 00 |e..."...|........|
|00001940| 00 00 00 00 00 00 00 01 | 00 00 00 09 45 64 69 74 |........|....Edit|
|00001950| 57 68 65 72 65 00 00 00 | 00 00 00 00 00 00 00 00 |Where...|........|
|00001960| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 57 68 65 |........|.....Whe|
|00001970| 72 65 4c 69 73 74 00 00 | 00 00 00 00 00 00 00 00 |reList..|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 22 40 |........|......"@|
|00001990| 26 4e 22 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |&N".....|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0d 4d |........|.......M|
|000019b0| 53 20 53 61 6e 73 20 53 | 65 72 69 66 00 00 00 00 |S Sans S|erif....|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 01 |........|........|
|000019d0| 31 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000019f0| 13 41 4c 45 4e 28 57 68 | 65 72 65 4c 69 73 74 29 |.ALEN(Wh|ereList)|
|00001a00| 20 2d 20 31 00 00 00 00 | 00 00 00 00 00 01 00 00 | - 1....|........|
|00001a10| 00 7d 44 4f 20 65 64 69 | 74 77 68 65 72 2e 73 70 |.}DO edi|twher.sp|
|00001a20| 72 0d 0a 0d 0a 49 46 20 | 28 45 4d 50 54 59 28 77 |r....IF |(EMPTY(w|
|00001a30| 68 65 72 65 6c 69 73 74 | 5b 45 64 69 74 57 68 65 |herelist|[EditWhe|
|00001a40| 72 65 5d 29 29 0d 0a 09 | 44 4f 20 64 65 6c 77 68 |re]))...|DO delwh|
|00001a50| 65 72 65 20 57 49 54 48 | 20 65 64 69 74 77 68 65 |ere WITH| editwhe|
|00001a60| 72 65 0d 0a 45 4e 44 49 | 46 0d 0a 0d 0a 53 48 4f |re..ENDI|F....SHO|
|00001a70| 57 20 47 45 54 20 65 64 | 69 74 77 68 65 72 65 0d |W GET ed|itwhere.|
|00001a80| 0a 0d 0a 52 45 54 55 52 | 4e 20 2e 54 2e 0d 0a 00 |...RETUR|N .T....|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 01 00 00 00 0d 4d | 53 20 53 61 6e 73 20 53 |.......M|S Sans S|
|00001ac0| 65 72 69 66 00 00 00 00 | 00 00 00 00 00 00 00 00 |erif....|........|
|00001ad0| 00 00 00 01 00 00 00 0d | 4d 53 20 53 61 6e 73 20 |........|MS Sans |
|00001ae0| 53 65 72 69 66 00 00 00 | 00 00 00 00 00 00 00 00 |Serif...|........|
|00001af0| 00 00 00 00 01 00 00 00 | 0a 42 75 69 6c 64 51 75 |........|.BuildQu|
|00001b00| 65 72 79 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ery.....|........|
|00001b10| 00 00 00 00 00 01 00 00 | 00 0f 22 20 42 75 69 6c |........|.." Buil|
|00001b20| 64 20 51 75 65 72 79 20 | 22 00 00 00 00 00 00 00 |d Query |".......|
|00001b30| 00 00 00 00 00 00 01 00 | 00 00 0d 4d 53 20 53 61 |........|...MS Sa|
|00001b40| 6e 73 20 53 65 72 69 66 | 00 00 00 00 00 00 00 00 |ns Serif|........|
|00001b50| 00 00 00 00 00 00 00 01 | 00 00 01 b6 44 4f 20 62 |........|....DO b|
|00001b60| 75 69 6c 64 73 6c 69 73 | 74 0d 0a 44 4f 20 62 75 |uildslis|t..DO bu|
|00001b70| 69 6c 64 73 70 6f 70 0d | 0a 0d 0a 73 71 6c 73 65 |ildspop.|...sqlse|
|00001b80| 6c 65 63 74 20 3d 20 62 | 75 69 6c 64 73 71 6c 28 |lect = b|uildsql(|
|00001b90| 29 0d 0a 0d 0a 49 46 20 | 28 65 78 69 74 61 63 74 |)....IF |(exitact|
|00001ba0| 69 6f 6e 20 3d 3d 20 31 | 29 0d 0a 09 44 4f 20 78 |ion == 1|)...DO x|
|00001bb0| 71 75 65 72 79 20 57 49 | 54 48 20 73 71 6c 73 65 |query WI|TH sqlse|
|00001bc0| 6c 65 63 74 0d 0a 09 52 | 45 54 55 52 4e 20 2e 46 |lect...R|ETURN .F|
|00001bd0| 2e 0d 0a 45 4c 53 45 0d | 0a 09 49 46 20 28 65 78 |...ELSE.|..IF (ex|
|00001be0| 69 74 61 63 74 69 6f 6e | 20 3d 3d 20 32 29 0d 0a |itaction| == 2)..|
|00001bf0| 09 09 48 49 44 45 20 57 | 49 4e 44 4f 57 20 62 75 |..HIDE W|INDOW bu|
|00001c00| 69 6c 64 71 75 65 72 79 | 0d 0a 09 09 44 4f 20 65 |ildquery|....DO e|
|00001c10| 64 69 74 71 75 65 72 2e | 73 70 72 0d 0a 09 09 52 |ditquer.|spr....R|
|00001c20| 45 54 55 52 4e 20 2e 54 | 2e 0d 0a 09 45 4c 53 45 |ETURN .T|....ELSE|
|00001c30| 0d 0a 09 09 49 46 20 28 | 65 78 69 74 61 63 74 69 |....IF (|exitacti|
|00001c40| 6f 6e 20 3d 3d 20 33 29 | 0d 0a 09 09 09 44 49 4d |on == 3)|.....DIM|
|00001c50| 45 4e 53 49 4f 4e 20 66 | 72 6f 6d 6c 69 73 74 5b |ENSION f|romlist[|
|00001c60| 31 5d 0d 0a 09 09 09 44 | 49 4d 45 4e 53 49 4f 4e |1].....D|IMENSION|
|00001c70| 20 73 65 6c 65 63 74 6c | 69 73 74 5b 31 5d 0d 0a | selectl|ist[1]..|
|00001c80| 09 09 09 44 49 4d 45 4e | 53 49 4f 4e 20 77 68 65 |...DIMEN|SION whe|
|00001c90| 72 65 6c 69 73 74 5b 31 | 5d 0d 0a 09 09 09 44 4f |relist[1|].....DO|
|00001ca0| 20 62 75 69 6c 64 66 70 | 6f 70 0d 0a 09 09 09 44 | buildfp|op.....D|
|00001cb0| 4f 20 62 75 69 6c 64 73 | 70 6f 70 0d 0a 09 09 09 |O builds|pop.....|
|00001cc0| 53 48 4f 57 20 47 45 54 | 20 65 64 69 74 77 68 65 |SHOW GET| editwhe|
|00001cd0| 72 65 0d 0a 09 09 09 52 | 45 54 55 52 4e 20 2e 46 |re.....R|ETURN .F|
|00001ce0| 2e 0d 0a 09 09 45 4c 53 | 45 0d 0a 09 09 09 52 45 |.....ELS|E.....RE|
|00001cf0| 54 55 52 4e 20 2e 54 2e | 0d 0a 09 09 45 4e 44 49 |TURN .T.|....ENDI|
|00001d00| 46 0d 0a 09 45 4e 44 49 | 46 0d 0a 45 4e 44 49 46 |F...ENDI|F..ENDIF|
|00001d10| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d20| 00 00 00 00 00 01 00 00 | 00 b2 69 66 20 61 6c 65 |........|..if ale|
|00001d30| 6e 28 66 72 6f 6d 6c 69 | 73 74 29 20 3c 20 33 0d |n(fromli|st) < 3.|
|00001d40| 0a 09 73 68 6f 77 20 67 | 65 74 20 64 75 6d 6d 79 |..show g|et dummy|
|00001d50| 20 64 69 73 61 62 6c 65 | 64 0d 0a 65 6c 73 65 0d | disable|d..else.|
|00001d60| 0a 09 73 68 6f 77 20 67 | 65 74 20 64 75 6d 6d 79 |..show g|et dummy|
|00001d70| 20 65 6e 61 62 6c 65 64 | 0d 0a 65 6e 64 69 66 0d | enabled|..endif.|
|00001d80| 0a 69 66 20 61 6c 65 6e | 28 66 72 6f 6d 6c 69 73 |.if alen|(fromlis|
|00001d90| 74 29 20 3c 20 32 0d 0a | 09 73 68 6f 77 20 67 65 |t) < 2..|.show ge|
|00001da0| 74 20 77 68 65 72 65 62 | 75 74 20 64 69 73 61 62 |t whereb|ut disab|
|00001db0| 6c 65 64 0d 0a 65 6c 73 | 65 0d 0a 09 73 68 6f 77 |led..els|e...show|
|00001dc0| 20 67 65 74 20 77 68 65 | 72 65 62 75 74 20 65 6e | get whe|rebut en|
|00001dd0| 61 62 6c 65 64 0d 0a 65 | 6e 64 69 66 00 00 00 00 |abled..e|ndif....|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 08 d8 |........|........|
|00001df0| 52 45 4c 45 41 53 45 20 | 50 4f 50 55 50 20 62 71 |RELEASE |POPUP bq|
|00001e00| 73 65 6c 65 63 74 70 6f | 70 0d 0a 52 45 4c 45 41 |selectpo|p..RELEA|
|00001e10| 53 45 20 50 4f 50 55 50 | 20 62 71 66 72 6f 6d 70 |SE POPUP| bqfromp|
|00001e20| 6f 70 0d 0a 52 45 54 55 | 52 4e 0d 0a 0d 0a 0d 0a |op..RETU|RN......|
|00001e30| 46 55 4e 43 54 49 4f 4e | 20 69 6e 66 72 6f 6d 6c |FUNCTION| infroml|
|00001e40| 69 73 74 0d 0a 50 41 52 | 41 4d 45 54 45 52 20 74 |ist..PAR|AMETER t|
|00001e50| 61 62 6c 65 6e 61 6d 65 | 0d 0a 50 52 49 56 41 54 |ablename|..PRIVAT|
|00001e60| 45 20 6e 66 72 6f 6d 73 | 2c 20 69 0d 0a 6e 66 72 |E nfroms|, i..nfr|
|00001e70| 6f 6d 73 20 3d 20 41 4c | 45 4e 28 66 72 6f 6d 6c |oms = AL|EN(froml|
|00001e80| 69 73 74 29 0d 0a 46 4f | 52 20 69 20 3d 20 31 20 |ist)..FO|R i = 1 |
|00001e90| 54 4f 20 6e 66 72 6f 6d | 73 20 2d 20 31 0d 0a 09 |TO nfrom|s - 1...|
|00001ea0| 49 46 20 28 74 61 62 6c | 65 6e 61 6d 65 20 3d 3d |IF (tabl|ename ==|
|00001eb0| 20 66 72 6f 6d 6c 69 73 | 74 5b 69 5d 29 0d 0a 09 | fromlis|t[i])...|
|00001ec0| 09 52 45 54 55 52 4e 20 | 2e 54 2e 0d 0a 09 45 4e |.RETURN |.T....EN|
|00001ed0| 44 49 46 0d 0a 45 4e 44 | 46 4f 52 0d 0a 52 45 54 |DIF..END|FOR..RET|
|00001ee0| 55 52 4e 20 2e 46 2e 0d | 0a 0d 0a 50 52 4f 43 45 |URN .F..|...PROCE|
|00001ef0| 44 55 52 45 20 64 65 6c | 77 68 65 72 65 0d 0a 50 |DURE del|where..P|
|00001f00| 41 52 41 4d 45 54 45 52 | 20 69 0d 0a 50 52 49 56 |ARAMETER| i..PRIV|
|00001f10| 41 54 45 20 6c 65 6e 6c | 69 73 74 0d 0a 3d 20 41 |ATE lenl|ist..= A|
|00001f20| 44 45 4c 28 77 68 65 72 | 65 6c 69 73 74 2c 20 69 |DEL(wher|elist, i|
|00001f30| 29 0d 0a 6c 65 6e 6c 69 | 73 74 20 3d 20 41 4c 45 |)..lenli|st = ALE|
|00001f40| 4e 28 77 68 65 72 65 6c | 69 73 74 29 0d 0a 49 46 |N(wherel|ist)..IF|
|00001f50| 20 28 69 20 21 3d 20 31 | 29 0d 0a 09 3d 20 41 44 | (i != 1|)...= AD|
|00001f60| 45 4c 28 77 68 65 72 65 | 6c 69 73 74 2c 20 69 20 |EL(where|list, i |
|00001f70| 2d 20 31 29 0d 0a 09 6c | 65 6e 6c 69 73 74 20 3d |- 1)...l|enlist =|
|00001f80| 20 6c 65 6e 6c 69 73 74 | 20 2d 20 31 0d 0a 45 4c | lenlist| - 1..EL|
|00001f90| 53 45 09 09 09 20 20 26 | 26 20 69 20 3d 3d 20 31 |SE...  &|& i == 1|
|00001fa0| 2c 20 73 6f 20 6c 6f 67 | 69 63 61 6c 20 63 6f 6e |, so log|ical con|
|00001fb0| 6e 65 63 74 6f 72 20 66 | 6f 6c 6c 6f 77 73 0d 0a |nector f|ollows..|
|00001fc0| 09 49 46 20 28 6c 65 6e | 6c 69 73 74 20 3e 20 31 |.IF (len|list > 1|
|00001fd0| 29 20 20 26 26 20 69 66 | 20 74 68 65 72 65 20 69 |)  && if| there i|
|00001fe0| 73 20 6f 6e 65 0d 0a 09 | 09 3d 20 41 44 45 4c 28 |s one...|.= ADEL(|
|00001ff0| 77 68 65 72 65 6c 69 73 | 74 2c 20 69 29 0d 0a 09 |wherelis|t, i)...|
|00002000| 09 6c 65 6e 6c 69 73 74 | 20 3d 20 6c 65 6e 6c 69 |.lenlist| = lenli|
|00002010| 73 74 20 2d 20 31 0d 0a | 09 45 4e 44 49 46 0d 0a |st - 1..|.ENDIF..|
|00002020| 45 4e 44 49 46 0d 0a 44 | 49 4d 45 4e 53 49 4f 4e |ENDIF..D|IMENSION|
|00002030| 20 77 68 65 72 65 6c 69 | 73 74 5b 4d 41 58 28 6c | whereli|st[MAX(l|
|00002040| 65 6e 4c 69 73 74 20 2d | 20 31 2c 20 31 29 5d 0d |enList -| 1, 1)].|
|00002050| 0a 52 45 54 55 52 4e 0d | 0a 0d 0a 50 52 4f 43 45 |.RETURN.|...PROCE|
|00002060| 44 55 52 45 20 62 75 69 | 6c 64 73 6c 69 73 74 0d |DURE bui|ldslist.|
|00002070| 0a 50 52 49 56 41 54 45 | 20 6c 65 6e 6c 69 73 74 |.PRIVATE| lenlist|
|00002080| 2c 20 69 2c 20 43 4f 55 | 4e 54 2c 20 6e 65 77 6f |, i, COU|NT, newo|
|00002090| 72 64 65 72 2c 20 74 61 | 62 6c 65 6e 61 6d 65 0d |rder, ta|blename.|
|000020a0| 0a 2a 0d 0a 2a 09 47 65 | 74 20 63 75 72 72 65 6e |.*..*.Ge|t curren|
|000020b0| 74 20 6f 72 64 65 72 20 | 6f 6e 20 70 6f 70 75 70 |t order |on popup|
|000020c0| 0d 0a 2a 0d 0a 6c 65 6e | 6c 69 73 74 20 3d 20 41 |..*..len|list = A|
|000020d0| 4c 45 4e 28 73 65 6c 65 | 63 74 6c 69 73 74 29 20 |LEN(sele|ctlist) |
|000020e0| 2d 20 31 0d 0a 44 49 4d | 45 4e 53 49 4f 4e 20 6e |- 1..DIM|ENSION n|
|000020f0| 65 77 6f 72 64 65 72 5b | 6c 65 6e 4c 69 73 74 20 |eworder[|lenList |
|00002100| 2b 20 31 5d 0d 0a 46 4f | 52 20 69 20 3d 20 31 20 |+ 1]..FO|R i = 1 |
|00002110| 54 4f 20 6c 65 6e 6c 69 | 73 74 0d 0a 09 6e 65 77 |TO lenli|st...new|
|00002120| 6f 72 64 65 72 5b 69 5d | 20 3d 20 73 65 6c 65 63 |order[i]| = selec|
|00002130| 74 6c 69 73 74 5b 47 45 | 54 42 41 52 28 22 42 51 |tlist[GE|TBAR("BQ|
|00002140| 53 65 6c 65 63 74 50 6f | 22 2c 20 69 29 5d 0d 0a |SelectPo|", i)]..|
|00002150| 45 4e 44 46 4f 52 0d 0a | 46 4f 52 20 69 20 3d 20 |ENDFOR..|FOR i = |
|00002160| 31 20 54 4f 20 6c 65 6e | 6c 69 73 74 0d 0a 09 73 |1 TO len|list...s|
|00002170| 65 6c 65 63 74 6c 69 73 | 74 5b 69 5d 20 3d 20 6e |electlis|t[i] = n|
|00002180| 65 77 6f 72 64 65 72 5b | 69 5d 0d 0a 45 4e 44 46 |eworder[|i]..ENDF|
|00002190| 4f 52 0d 0a 2a 0d 0a 2a | 09 43 68 65 63 6b 20 61 |OR..*..*|.Check a|
|000021a0| 67 61 69 6e 73 74 20 46 | 52 4f 4d 20 6c 69 73 74 |gainst F|ROM list|
|000021b0| 0d 0a 2a 0d 0a 69 20 3d | 20 31 20 26 26 20 61 63 |..*..i =| 1 && ac|
|000021c0| 63 6f 75 6e 74 20 66 6f | 72 20 64 65 6c 65 74 65 |count fo|r delete|
|000021d0| 73 20 66 72 6f 6d 20 61 | 72 72 61 79 20 53 65 6c |s from a|rray Sel|
|000021e0| 65 63 74 4c 69 73 74 20 | 77 68 69 63 68 20 6d 6f |ectList |which mo|
|000021f0| 76 65 73 20 65 76 65 72 | 79 74 68 69 6e 67 20 75 |ves ever|ything u|
|00002200| 70 0d 0a 46 4f 52 20 43 | 4f 55 4e 54 20 3d 20 31 |p..FOR C|OUNT = 1|
|00002210| 20 54 4f 20 6c 65 6e 6c | 69 73 74 0d 0a 09 2a 0d | TO lenl|ist...*.|
|00002220| 0a 09 2a 09 09 45 78 74 | 72 61 63 74 20 74 61 62 |..*..Ext|ract tab|
|00002230| 6c 65 20 6e 61 6d 65 20 | 66 72 6f 6d 20 63 6f 6c |le name |from col|
|00002240| 75 6d 6e 20 6e 61 6d 65 | 0d 0a 09 2a 0d 0a 09 74 |umn name|...*...t|
|00002250| 61 62 6c 65 6e 61 6d 65 | 20 3d 20 53 55 42 53 54 |ablename| = SUBST|
|00002260| 52 28 73 65 6c 65 63 74 | 6c 69 73 74 5b 69 5d 2c |R(select|list[i],|
|00002270| 20 31 2c 20 41 54 28 22 | 2e 22 2c 20 73 65 6c 65 | 1, AT("|.", sele|
|00002280| 63 74 6c 69 73 74 5b 69 | 5d 29 20 2d 20 31 29 0d |ctlist[i|]) - 1).|
|00002290| 0a 09 49 46 20 28 20 2e | 4e 4f 54 2e 20 69 6e 66 |..IF ( .|NOT. inf|
|000022a0| 72 6f 6d 6c 69 73 74 28 | 74 61 62 6c 65 6e 61 6d |romlist(|tablenam|
|000022b0| 65 29 29 0d 0a 09 09 3d | 20 41 44 45 4c 28 73 65 |e))....=| ADEL(se|
|000022c0| 6c 65 63 74 6c 69 73 74 | 2c 20 69 29 0d 0a 09 45 |lectlist|, i)...E|
|000022d0| 4c 53 45 0d 0a 09 09 69 | 20 3d 20 69 20 2b 20 31 |LSE....i| = i + 1|
|000022e0| 0d 0a 09 45 4e 44 49 46 | 0d 0a 45 4e 44 46 4f 52 |...ENDIF|..ENDFOR|
|000022f0| 0d 0a 44 49 4d 45 4e 53 | 49 4f 4e 20 73 65 6c 65 |..DIMENS|ION sele|
|00002300| 63 74 6c 69 73 74 5b 69 | 5d 0d 0a 52 45 54 55 52 |ctlist[i|]..RETUR|
|00002310| 4e 20 20 26 26 20 50 52 | 4f 43 45 44 55 52 45 20 |N  && PR|OCEDURE |
|00002320| 42 75 69 6c 64 53 4c 69 | 73 74 0d 0a 0d 0a 0d 0a |BuildSLi|st......|
|00002330| 50 52 4f 43 45 44 55 52 | 45 20 62 75 69 6c 64 73 |PROCEDUR|E builds|
|00002340| 70 6f 70 0d 0a 50 52 49 | 56 41 54 45 20 6c 65 6e |pop..PRI|VATE len|
|00002350| 6c 69 73 74 2c 20 69 0d | 0a 52 45 4c 45 41 53 45 |list, i.|.RELEASE|
|00002360| 20 42 41 52 20 41 4c 4c | 20 4f 46 20 62 71 73 65 | BAR ALL| OF bqse|
|00002370| 6c 65 63 74 70 6f 70 0d | 0a 6c 65 6e 6c 69 73 74 |lectpop.|.lenlist|
|00002380| 20 3d 20 41 4c 45 4e 28 | 73 65 6c 65 63 74 6c 69 | = ALEN(|selectli|
|00002390| 73 74 29 20 2d 20 31 0d | 0a 46 4f 52 20 69 20 3d |st) - 1.|.FOR i =|
|000023a0| 20 31 20 54 4f 20 6c 65 | 6e 6c 69 73 74 0d 0a 09 | 1 TO le|nlist...|
|000023b0| 44 45 46 49 4e 45 20 42 | 41 52 20 28 69 29 20 4f |DEFINE B|AR (i) O|
|000023c0| 46 20 62 71 73 65 6c 65 | 63 74 70 6f 70 20 50 52 |F bqsele|ctpop PR|
|000023d0| 4f 4d 50 54 20 73 65 6c | 65 63 74 6c 69 73 74 5b |OMPT sel|ectlist[|
|000023e0| 69 5d 0d 0a 45 4e 44 46 | 4f 52 0d 0a 53 48 4f 57 |i]..ENDF|OR..SHOW|
|000023f0| 20 47 45 54 20 73 65 6c | 65 63 74 70 6f 70 0d 0a | GET sel|ectpop..|
|00002400| 52 45 54 55 52 4e 0d 0a | 0d 0a 0d 0a 50 52 4f 43 |RETURN..|....PROC|
|00002410| 45 44 55 52 45 20 62 75 | 69 6c 64 66 70 6f 70 0d |EDURE bu|ildfpop.|
|00002420| 0a 50 52 49 56 41 54 45 | 20 6c 65 6e 6c 69 73 74 |.PRIVATE| lenlist|
|00002430| 0d 0a 52 45 4c 45 41 53 | 45 20 42 41 52 20 41 4c |..RELEAS|E BAR AL|
|00002440| 4c 20 4f 46 20 62 71 66 | 72 6f 6d 70 6f 70 0d 0a |L OF bqf|rompop..|
|00002450| 6c 65 6e 6c 69 73 74 20 | 3d 20 41 4c 45 4e 28 66 |lenlist |= ALEN(f|
|00002460| 72 6f 6d 6c 69 73 74 29 | 20 2d 20 31 0d 0a 46 4f |romlist)| - 1..FO|
|00002470| 52 20 69 20 3d 20 31 20 | 54 4f 20 6c 65 6e 6c 69 |R i = 1 |TO lenli|
|00002480| 73 74 0d 0a 09 44 45 46 | 49 4e 45 20 42 41 52 20 |st...DEF|INE BAR |
|00002490| 28 69 29 20 4f 46 20 62 | 71 66 72 6f 6d 70 6f 70 |(i) OF b|qfrompop|
|000024a0| 20 50 52 4f 4d 50 54 20 | 66 72 6f 6d 6c 69 73 74 | PROMPT |fromlist|
|000024b0| 5b 69 5d 0d 0a 45 4e 44 | 46 4f 52 0d 0a 53 48 4f |[i]..END|FOR..SHO|
|000024c0| 57 20 47 45 54 20 66 70 | 6f 70 64 75 6d 6d 79 0d |W GET fp|opdummy.|
|000024d0| 0a 52 45 54 55 52 4e 0d | 0a 0d 0a 0d 0a 50 52 4f |.RETURN.|.....PRO|
|000024e0| 43 45 44 55 52 45 20 62 | 75 69 6c 64 63 6c 69 73 |CEDURE b|uildclis|
|000024f0| 74 0d 0a 44 49 4d 45 4e | 53 49 4f 4e 20 63 6f 6c |t..DIMEN|SION col|
|00002500| 75 6d 6e 6c 69 73 74 5b | 31 5d 0d 0a 6e 66 72 6f |umnlist[|1]..nfro|
|00002510| 6d 20 3d 20 41 4c 45 4e | 28 66 72 6f 6d 6c 69 73 |m = ALEN|(fromlis|
|00002520| 74 29 0d 0a 46 4f 52 20 | 69 20 3d 20 31 20 54 4f |t)..FOR |i = 1 TO|
|00002530| 20 6e 66 72 6f 6d 20 2d | 20 31 0d 0a 09 44 4f 20 | nfrom -| 1...DO |
|00002540| 61 64 64 63 6f 6c 75 6d | 6e 73 20 57 49 54 48 20 |addcolum|ns WITH |
|00002550| 66 72 6f 6d 6c 69 73 74 | 5b 69 5d 0d 0a 45 4e 44 |fromlist|[i]..END|
|00002560| 46 4f 52 0d 0a 52 45 54 | 55 52 4e 0d 0a 0d 0a 0d |FOR..RET|URN.....|
|00002570| 0a 50 52 4f 43 45 44 55 | 52 45 20 61 64 64 63 6f |.PROCEDU|RE addco|
|00002580| 6c 75 6d 6e 73 0d 0a 50 | 41 52 41 4d 45 54 45 52 |lumns..P|ARAMETER|
|00002590| 20 74 61 62 6c 65 6e 61 | 6d 65 0d 0a 50 52 49 56 | tablena|me..PRIV|
|000025a0| 41 54 45 20 6c 65 6e 6c | 69 73 74 0d 0a 49 46 20 |ATE lenl|ist..IF |
|000025b0| 28 63 6b 68 61 6e 64 6c | 65 20 3d 3d 20 30 29 0d |(ckhandl|e == 0).|
|000025c0| 0a 09 53 45 4c 45 43 54 | 20 30 0d 0a 09 55 53 45 |..SELECT| 0...USE|
|000025d0| 20 63 6f 6c 75 6d 6e 73 | 0d 0a 45 4c 53 45 0d 0a | columns|..ELSE..|
|000025e0| 09 3d 20 64 62 63 6f 6c | 73 28 63 6b 68 61 6e 64 |.= dbcol|s(ckhand|
|000025f0| 6c 65 2c 20 74 61 62 6c | 65 6e 61 6d 65 2c 20 22 |le, tabl|ename, "|
|00002600| 4e 61 74 69 76 65 22 29 | 0d 0a 45 4e 44 49 46 0d |Native")|..ENDIF.|
|00002610| 0a 6c 65 6e 6c 69 73 74 | 20 3d 20 41 4c 45 4e 28 |.lenlist| = ALEN(|
|00002620| 63 6f 6c 75 6d 6e 6c 69 | 73 74 29 0d 0a 44 49 4d |columnli|st)..DIM|
|00002630| 45 4e 53 49 4f 4e 20 63 | 6f 6c 75 6d 6e 6c 69 73 |ENSION c|olumnlis|
|00002640| 74 5b 6c 65 6e 4c 69 73 | 74 20 2b 20 52 45 43 43 |t[lenLis|t + RECC|
|00002650| 4f 28 29 5d 0d 0a 53 43 | 41 4e 0d 0a 09 63 6f 6c |O()]..SC|AN...col|
|00002660| 75 6d 6e 6c 69 73 74 5b | 6c 65 6e 4c 69 73 74 5d |umnlist[|lenList]|
|00002670| 20 3d 20 74 61 62 6c 65 | 6e 61 6d 65 20 2b 20 22 | = table|name + "|
|00002680| 2e 22 20 2b 20 41 4c 4c | 54 52 49 4d 28 63 6f 6c |." + ALL|TRIM(col|
|00002690| 75 6d 6e 5f 6e 61 6d 29 | 0d 0a 09 6c 65 6e 6c 69 |umn_nam)|...lenli|
|000026a0| 73 74 20 3d 20 6c 65 6e | 6c 69 73 74 20 2b 20 31 |st = len|list + 1|
|000026b0| 0d 0a 45 4e 44 53 43 41 | 4e 0d 0a 55 53 45 0d 0a |..ENDSCA|N..USE..|
|000026c0| 52 45 54 55 52 4e 0d 0a | 00 00 00 00 00 00 00 00 |RETURN..|........|
|000026d0| 01 00 00 00 f5 44 4f 20 | 62 75 69 6c 64 74 6c 69 |.....DO |buildtli|
|000026e0| 73 74 0d 0a 0d 0a 49 46 | 20 28 41 4c 45 4e 28 74 |st....IF| (ALEN(t|
|000026f0| 61 62 6c 65 6c 69 73 74 | 29 20 3c 20 32 29 0d 0a |ablelist|) < 2)..|
|00002700| 09 3f 3f 20 43 48 52 28 | 37 29 0d 0a 09 57 41 49 |.?? CHR(|7)...WAI|
|00002710| 54 20 57 49 4e 44 4f 57 | 20 22 4e 6f 20 74 61 62 |T WINDOW| "No tab|
|00002720| 6c 65 73 20 69 6e 20 64 | 61 74 61 62 61 73 65 22 |les in d|atabase"|
|00002730| 0d 0a 09 52 45 54 55 52 | 4e 0d 0a 45 4e 44 49 46 |...RETUR|N..ENDIF|
|00002740| 0d 0a 0d 0a 44 45 46 49 | 4e 45 20 50 4f 50 55 50 |....DEFI|NE POPUP|
|00002750| 20 62 71 73 65 6c 65 63 | 74 70 6f 70 20 53 43 52 | bqselec|tpop SCR|
|00002760| 4f 4c 4c 20 4d 41 52 47 | 49 4e 20 4d 41 52 4b 20 |OLL MARG|IN MARK |
|00002770| 22 20 22 20 4d 4f 56 45 | 52 0d 0a 44 45 46 49 4e |" " MOVE|R..DEFIN|
|00002780| 45 20 50 4f 50 55 50 20 | 62 71 66 72 6f 6d 70 6f |E POPUP |bqfrompo|
|00002790| 70 20 20 20 53 43 52 4f | 4c 4c 20 4d 41 52 47 49 |p   SCRO|LL MARGI|
|000027a0| 4e 20 4d 41 52 4b 20 22 | 20 22 0d 0a 0d 0a 44 4f |N MARK "| "....DO|
|000027b0| 20 62 75 69 6c 64 66 70 | 6f 70 0d 0a 44 4f 20 62 | buildfp|op..DO b|
|000027c0| 75 69 6c 64 73 70 6f 70 | 0d 0a 00 00 00 00 00 00 |uildspop|........|
|000027d0| 00 00 00 00 00 00 00 00 | 01 00 00 00 0a 45 78 69 |........|.....Exi|
|000027e0| 74 41 63 74 69 6f 6e 00 | 00 00 00 00 00 00 00 00 |tAction.|........|
|000027f0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 2e 22 40 |........|......"@|
|00002800| 2a 56 54 20 5c 21 20 45 | 5c 3c 78 65 63 75 74 65 |*VT \! E|\<xecute|
|00002810| 20 3b 5c 3c 45 64 69 74 | 2e 2e 2e 3b 43 5c 3c 6c | ;\<Edit|...;C\<l|
|00002820| 65 61 72 3b 5c 3f 43 6c | 6f 73 65 22 00 00 00 00 |ear;\?Cl|ose"....|
|00002830| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0d |........|........|
|00002840| 4d 53 20 53 61 6e 73 20 | 53 65 72 69 66 00 00 00 |MS Sans |Serif...|
|00002850| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00002860| 0b 22 20 45 78 65 63 75 | 74 65 20 22 00 00 00 00 |." Execu|te "....|
|00002870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002880| 00 0a 46 72 6f 6d 42 75 | 74 74 6f 6e 00 00 00 00 |..FromBu|tton....|
|00002890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000028a0| 00 00 10 22 40 2a 56 4e | 20 5c 3c 46 72 6f 6d 2e |..."@*VN| \<From.|
|000028b0| 2e 2e 22 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |..".....|........|
|000028c0| 00 00 00 0d 4d 53 20 53 | 61 6e 73 20 53 65 72 69 |....MS S|ans Seri|
|000028d0| 66 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |f.......|........|
|000028e0| 01 00 00 04 4a 50 52 49 | 56 41 54 45 20 69 2c 20 |....JPRI|VATE i, |
|000028f0| 74 61 62 6c 65 6e 61 6d | 65 2c 20 43 4f 55 4e 54 |tablenam|e, COUNT|
|00002900| 2c 20 49 4e 4c 49 53 54 | 0d 0a 0d 0a 44 4f 20 66 |, INLIST|....DO f|
|00002910| 72 6f 6d 2e 73 70 72 0d | 0a 44 4f 20 62 75 69 6c |rom.spr.|.DO buil|
|00002920| 64 66 70 6f 70 0d 0a 0d | 0a 44 4f 20 62 75 69 6c |dfpop...|.DO buil|
|00002930| 64 73 6c 69 73 74 0d 0a | 44 4f 20 62 75 69 6c 64 |dslist..|DO build|
|00002940| 73 70 6f 70 0d 0a 0d 0a | 44 4f 20 62 75 69 6c 64 |spop....|DO build|
|00002950| 63 6c 69 73 74 0d 0a 2a | 0d 0a 2a 09 52 65 62 75 |clist..*|..*.Rebu|
|00002960| 69 6c 64 20 57 48 45 52 | 45 20 6c 69 73 74 2e 20 |ild WHER|E list. |
|00002970| 4d 75 73 74 20 64 6f 20 | 74 68 69 73 2c 20 62 65 |Must do |this, be|
|00002980| 63 61 75 73 65 20 74 68 | 65 20 72 65 6d 6f 76 61 |cause th|e remova|
|00002990| 6c 20 6f 66 20 61 0d 0a | 2a 09 74 61 62 6c 65 20 |l of a..|*.table |
|000029a0| 63 6f 75 6c 64 20 6d 65 | 61 6e 20 73 6f 6d 65 20 |could me|an some |
|000029b0| 6f 66 20 74 68 65 73 65 | 20 63 6f 6c 75 6d 6e 73 |of these| columns|
|000029c0| 20 63 61 6e 20 6e 6f 20 | 6c 6f 6e 67 65 72 20 62 | can no |longer b|
|000029d0| 65 0d 0a 2a 09 53 45 4c | 45 43 54 65 64 2e 0d 0a |e..*.SEL|ECTed...|
|000029e0| 2a 0d 0a 69 20 3d 20 31 | 20 26 26 20 61 63 63 6f |*..i = 1| && acco|
|000029f0| 75 6e 74 20 66 6f 72 20 | 64 65 6c 65 74 65 73 20 |unt for |deletes |
|00002a00| 66 72 6f 6d 20 61 72 72 | 61 79 20 77 68 69 63 68 |from arr|ay which|
|00002a10| 20 6d 6f 76 65 73 20 65 | 76 65 72 79 74 68 69 6e | moves e|verythin|
|00002a20| 67 20 75 70 0d 0a 44 4f | 20 57 48 49 4c 45 20 28 |g up..DO| WHILE (|
|00002a30| 69 20 3c 20 41 4c 45 4e | 28 77 68 65 72 65 6c 69 |i < ALEN|(whereli|
|00002a40| 73 74 29 29 0d 0a 09 2a | 0d 0a 09 2a 09 09 45 78 |st))...*|...*..Ex|
|00002a50| 74 72 61 63 74 20 74 61 | 62 6c 65 20 6e 61 6d 65 |tract ta|ble name|
|00002a60| 73 20 66 72 6f 6d 20 57 | 48 45 52 45 20 63 6f 6e |s from W|HERE con|
|00002a70| 64 69 74 69 6f 6e 0d 0a | 09 2a 0d 0a 09 72 65 73 |dition..|.*...res|
|00002a80| 74 6f 66 77 68 65 72 65 | 20 3d 20 77 68 65 72 65 |tofwhere| = where|
|00002a90| 6c 69 73 74 5b 69 5d 0d | 0a 09 44 49 4d 45 4e 53 |list[i].|..DIMENS|
|00002aa0| 49 4f 4e 20 74 61 62 6c | 65 6e 61 6d 65 5b 31 5d |ION tabl|ename[1]|
|00002ab0| 0d 0a 09 44 4f 20 57 48 | 49 4c 45 20 2e 54 2e 0d |...DO WH|ILE .T..|
|00002ac0| 0a 09 09 65 6e 64 73 65 | 70 20 3d 20 41 54 28 22 |...endse|p = AT("|
|00002ad0| 2e 22 2c 20 72 65 73 74 | 6f 66 77 68 65 72 65 29 |.", rest|ofwhere)|
|00002ae0| 0d 0a 09 09 49 46 20 28 | 65 6e 64 73 65 70 20 3e |....IF (|endsep >|
|00002af0| 20 30 29 0d 0a 09 09 09 | 62 65 67 73 65 70 20 3d | 0).....|begsep =|
|00002b00| 20 52 41 54 28 22 20 22 | 2c 20 53 55 42 53 54 52 | RAT(" "|, SUBSTR|
|00002b10| 28 72 65 73 74 6f 66 77 | 68 65 72 65 2c 20 31 2c |(restofw|here, 1,|
|00002b20| 20 65 6e 64 73 65 70 20 | 2d 20 31 29 29 0d 0a 09 | endsep |- 1))...|
|00002b30| 09 09 49 4e 4c 49 53 54 | 20 3d 20 41 4c 45 4e 28 |..INLIST| = ALEN(|
|00002b40| 74 61 62 6c 65 6e 61 6d | 65 29 0d 0a 09 09 09 44 |tablenam|e).....D|
|00002b50| 49 4d 45 4e 53 49 4f 4e | 20 74 61 62 6c 65 6e 61 |IMENSION| tablena|
|00002b60| 6d 65 5b 49 4e 4c 49 53 | 54 20 2b 20 31 5d 0d 0a |me[INLIS|T + 1]..|
|00002b70| 09 09 09 74 61 62 6c 65 | 6e 61 6d 65 5b 49 4e 4c |...table|name[INL|
|00002b80| 49 53 54 5d 20 3d 20 53 | 55 42 53 54 52 28 72 65 |IST] = S|UBSTR(re|
|00002b90| 73 74 6f 66 77 68 65 72 | 65 2c 20 62 65 67 73 65 |stofwher|e, begse|
|00002ba0| 70 20 2b 20 31 2c 3b 0d | 0a 09 09 09 09 65 6e 64 |p + 1,;.|.....end|
|00002bb0| 73 65 70 20 2d 20 62 65 | 67 73 65 70 20 2d 20 31 |sep - be|gsep - 1|
|00002bc0| 29 0d 0a 09 09 09 72 65 | 73 74 6f 66 77 68 65 72 |).....re|stofwher|
|00002bd0| 65 20 3d 20 53 55 42 53 | 54 52 28 72 65 73 74 6f |e = SUBS|TR(resto|
|00002be0| 66 77 68 65 72 65 2c 20 | 65 6e 64 73 65 70 20 2b |fwhere, |endsep +|
|00002bf0| 20 31 29 0d 0a 09 09 45 | 4c 53 45 0d 0a 09 09 09 | 1)....E|LSE.....|
|00002c00| 45 58 49 54 0d 0a 09 09 | 45 4e 44 49 46 0d 0a 09 |EXIT....|ENDIF...|
|00002c10| 45 4e 44 44 4f 0d 0a 0d | 0a 09 64 65 6c 65 74 65 |ENDDO...|..delete|
|00002c20| 66 6c 61 67 20 3d 20 2e | 46 2e 0d 0a 09 49 4e 4c |flag = .|F....INL|
|00002c30| 49 53 54 20 3d 20 41 4c | 45 4e 28 74 61 62 6c 65 |IST = AL|EN(table|
|00002c40| 6e 61 6d 65 29 20 2d 20 | 31 0d 0a 09 46 4f 52 20 |name) - |1...FOR |
|00002c50| 6a 20 3d 20 31 20 54 4f | 20 49 4e 4c 49 53 54 0d |j = 1 TO| INLIST.|
|00002c60| 0a 0d 0a 09 09 49 46 20 | 28 20 2e 4e 4f 54 2e 20 |.....IF |( .NOT. |
|00002c70| 69 6e 66 72 6f 6d 6c 69 | 73 74 28 74 61 62 6c 65 |infromli|st(table|
|00002c80| 6e 61 6d 65 5b 6a 5d 29 | 29 0d 0a 09 09 09 44 4f |name[j])|).....DO|
|00002c90| 20 64 65 6c 77 68 65 72 | 65 20 57 49 54 48 20 69 | delwher|e WITH i|
|00002ca0| 0d 0a 09 09 09 64 65 6c | 65 74 65 66 6c 61 67 20 |.....del|eteflag |
|00002cb0| 3d 20 2e 54 2e 0d 0a 09 | 09 09 45 58 49 54 0d 0a |= .T....|..EXIT..|
|00002cc0| 09 09 45 4e 44 49 46 0d | 0a 0d 0a 09 45 4e 44 46 |..ENDIF.|....ENDF|
|00002cd0| 4f 52 0d 0a 0d 0a 09 49 | 46 20 28 20 2e 4e 4f 54 |OR.....I|F ( .NOT|
|00002ce0| 2e 20 64 65 6c 65 74 65 | 66 6c 61 67 29 0d 0a 09 |. delete|flag)...|
|00002cf0| 09 69 20 3d 20 69 20 2b | 20 31 0d 0a 09 45 4e 44 |.i = i +| 1...END|
|00002d00| 49 46 0d 0a 0d 0a 45 4e | 44 44 4f 0d 0a 53 48 4f |IF....EN|DDO..SHO|
|00002d10| 57 20 47 45 54 20 65 64 | 69 74 77 68 65 72 65 0d |W GET ed|itwhere.|
|00002d20| 0a 0d 0a 52 45 54 55 52 | 4e 20 2e 54 2e 0d 0a 00 |...RETUR|N .T....|
|00002d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d40| 00 00 01 00 00 00 09 22 | 46 72 6f 6d 2e 2e 2e 22 |......."|From..."|
|00002d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d60| 00 00 00 01 00 00 00 07 | 46 72 6f 6d 50 6f 70 00 |........|FromPop.|
|00002d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d80| 00 00 00 00 01 00 00 00 | 09 42 51 46 72 6f 6d 50 |........|.BQFromP|
|00002d90| 6f 70 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |op......|........|
|00002da0| 00 00 00 00 00 01 00 00 | 00 05 22 40 26 4e 22 00 |........|.."@&N".|
|00002db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002dc0| 00 00 00 00 00 00 01 00 | 00 00 0d 4d 53 20 53 61 |........|...MS Sa|
|00002dd0| 6e 73 20 53 65 72 69 66 | 00 00 00 00 00 00 00 00 |ns Serif|........|
|00002de0| 00 00 00 00 00 00 00 01 | 00 00 00 01 31 00 00 00 |........|....1...|
|00002df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e00| 00 00 00 00 00 00 00 00 | 01 00 00 00 12 41 4c 45 |........|.....ALE|
|00002e10| 4e 28 46 72 6f 6d 4c 69 | 73 74 29 20 2d 20 31 00 |N(FromLi|st) - 1.|
|00002e20| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 09 53 65 |........|......Se|
|00002e30| 6c 65 63 74 50 6f 70 00 | 00 00 00 00 00 00 00 00 |lectPop.|........|
|00002e40| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0a 42 |........|.......B|
|00002e50| 51 53 65 6c 65 63 74 50 | 6f 00 00 00 00 00 00 00 |QSelectP|o.......|
|00002e60| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 05 |........|........|
|00002e70| 22 40 26 4e 22 00 00 00 | 00 00 00 00 00 00 00 00 |"@&N"...|........|
|00002e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00002e90| 0d 4d 53 20 53 61 6e 73 | 20 53 65 72 69 66 00 00 |.MS Sans| Serif..|
|00002ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002eb0| 00 01 31 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |..1.....|........|
|00002ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00002ed0| 00 00 14 41 4c 45 4e 28 | 53 65 6c 65 63 74 4c 69 |...ALEN(|SelectLi|
|00002ee0| 73 74 29 20 2d 20 31 00 | 00 00 00 00 00 00 00 01 |st) - 1.|........|
|00002ef0| 00 00 00 2b 44 4f 20 62 | 75 69 6c 64 73 6c 69 73 |...+DO b|uildslis|
|00002f00| 74 0d 0a 44 4f 20 62 75 | 69 6c 64 73 70 6f 70 0d |t..DO bu|ildspop.|
|00002f10| 0a 0d 0a 52 45 54 55 52 | 4e 20 2e 54 2e 0d 0a 00 |...RETUR|N .T....|
|00002f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f30| 00 01 00 00 00 0c 53 65 | 6c 65 63 74 42 75 74 74 |......Se|lectButt|
|00002f40| 6f 6e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |on......|........|
|00002f50| 00 00 01 00 00 00 12 22 | 40 2a 56 4e 20 5c 3c 53 |......."|@*VN \<S|
|00002f60| 65 6c 65 63 74 2e 2e 2e | 22 00 00 00 00 00 00 00 |elect...|".......|
|00002f70| 00 00 00 01 00 00 00 0d | 4d 53 20 53 61 6e 73 20 |........|MS Sans |
|00002f80| 53 65 72 69 66 00 00 00 | 00 00 00 00 00 00 00 00 |Serif...|........|
|00002f90| 00 00 00 00 01 00 00 00 | 3a 44 4f 20 62 75 69 6c |........|:DO buil|
|00002fa0| 64 73 6c 69 73 74 0d 0a | 44 4f 20 73 65 6c 65 63 |dslist..|DO selec|
|00002fb0| 74 2e 73 70 72 0d 0a 44 | 4f 20 62 75 69 6c 64 73 |t.spr..D|O builds|
|00002fc0| 70 6f 70 0d 0a 0d 0a 52 | 45 54 55 52 4e 20 2e 54 |pop....R|ETURN .T|
|00002fd0| 2e 0d 0a 00 00 00 01 00 | 00 00 0b 22 53 65 6c 65 |........|..."Sele|
|00002fe0| 63 74 2e 2e 2e 22 00 00 | 00 00 00 00 00 00 00 00 |ct..."..|........|
|00002ff0| 00 00 00 00 00 00 00 01 | 00 00 00 05 44 75 6d 6d |........|....Dumm|
|00003000| 79 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |y.......|........|
|00003010| 00 00 00 00 00 00 00 00 | 01 00 00 00 10 22 40 2a |........|....."@*|
|00003020| 56 4e 20 5c 3c 4a 6f 69 | 6e 2e 2e 2e 22 00 00 00 |VN \<Joi|n..."...|
|00003030| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0d 4d 53 |........|......MS|
|00003040| 20 53 61 6e 73 20 53 65 | 72 69 66 00 00 00 00 00 | Sans Se|rif.....|
|00003050| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 2d 44 |........|......-D|
|00003060| 4f 20 6a 6f 69 6e 2e 73 | 70 72 0d 0a 53 48 4f 57 |O join.s|pr..SHOW|
|00003070| 20 47 45 54 20 65 64 69 | 74 77 68 65 72 65 0d 0a | GET edi|twhere..|
|00003080| 52 45 54 55 52 4e 20 2e | 54 2e 0d 0a 00 00 00 00 |RETURN .|T.......|
|00003090| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000030a0| 09 22 4a 6f 69 6e 2e 2e | 2e 22 00 00 00 00 00 00 |."Join..|."......|
|000030b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000030c0| 00 08 77 68 65 72 65 62 | 75 74 00 00 00 00 00 00 |..whereb|ut......|
|000030d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000030e0| 00 00 11 22 40 2a 56 4e | 20 5c 3c 57 68 65 72 65 |..."@*VN| \<Where|
|000030f0| 2e 2e 2e 22 00 00 00 00 | 00 00 00 00 00 00 00 01 |..."....|........|
|00003100| 00 00 00 0d 4d 53 20 53 | 61 6e 73 20 53 65 72 69 |....MS S|ans Seri|
|00003110| 66 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |f.......|........|
|00003120| 01 00 00 00 2e 44 4f 20 | 77 68 65 72 65 2e 73 70 |.....DO |where.sp|
|00003130| 72 0d 0a 53 48 4f 57 20 | 47 45 54 20 65 64 69 74 |r..SHOW |GET edit|
|00003140| 77 68 65 72 65 0d 0a 52 | 45 54 55 52 4e 20 2e 54 |where..R|ETURN .T|
|00003150| 2e 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003160| 00 00 01 00 00 00 0a 22 | 57 68 65 72 65 2e 2e 2e |......."|Where...|
|00003170| 22 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |".......|........|
|00003180| 00 00 00 01 00 00 00 09 | 45 64 69 74 57 68 65 72 |........|EditWher|
|00003190| 65 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |e.......|........|
|000031a0| 00 00 00 00 01 00 00 00 | 09 57 68 65 72 65 4c 69 |........|.WhereLi|
|000031b0| 73 74 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |st......|........|
|000031c0| 00 00 00 00 00 01 00 00 | 00 05 22 40 26 4e 22 00 |........|.."@&N".|
|000031d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000031e0| 00 00 00 00 00 00 01 00 | 00 00 0d 4d 53 20 53 61 |........|...MS Sa|
|000031f0| 6e 73 20 53 65 72 69 66 | 00 00 00 00 00 00 00 00 |ns Serif|........|
|00003200| 00 00 00 00 00 00 00 01 | 00 00 00 01 31 00 00 00 |........|....1...|
|00003210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003220| 00 00 00 00 00 00 00 00 | 01 00 00 00 13 41 4c 45 |........|.....ALE|
|00003230| 4e 28 57 68 65 72 65 4c | 69 73 74 29 20 2d 20 31 |N(WhereL|ist) - 1|
|00003240| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 7d 44 4f |........|.....}DO|
|00003250| 20 65 64 69 74 77 68 65 | 72 2e 73 70 72 0d 0a 0d | editwhe|r.spr...|
|00003260| 0a 49 46 20 28 45 4d 50 | 54 59 28 77 68 65 72 65 |.IF (EMP|TY(where|
|00003270| 6c 69 73 74 5b 45 64 69 | 74 57 68 65 72 65 5d 29 |list[Edi|tWhere])|
|00003280| 29 0d 0a 09 44 4f 20 64 | 65 6c 77 68 65 72 65 20 |)...DO d|elwhere |
|00003290| 57 49 54 48 20 65 64 69 | 74 77 68 65 72 65 0d 0a |WITH edi|twhere..|
|000032a0| 45 4e 44 49 46 0d 0a 0d | 0a 53 48 4f 57 20 47 45 |ENDIF...|.SHOW GE|
|000032b0| 54 20 65 64 69 74 77 68 | 65 72 65 0d 0a 0d 0a 52 |T editwh|ere....R|
|000032c0| 45 54 55 52 4e 20 2e 54 | 2e 0d 0a 00 00 00 00 00 |ETURN .T|........|
|000032d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000032f0| 00 00 0d 4d 53 20 53 61 | 6e 73 20 53 65 72 69 66 |...MS Sa|ns Serif|
|00003300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00003310| 00 00 00 0d 4d 53 20 53 | 61 6e 73 20 53 65 72 69 |....MS S|ans Seri|
|00003320| 66 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |f.......|........|
|00003330| 01 00 00 00 0a 42 75 69 | 6c 64 51 75 65 72 79 00 |.....Bui|ldQuery.|
|00003340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003350| 00 01 00 00 00 0f 22 20 | 42 75 69 6c 64 20 51 75 |......" |Build Qu|
|00003360| 65 72 79 20 22 00 00 00 | 00 00 00 00 00 00 00 00 |ery "...|........|
|00003370| 00 00 01 00 00 01 b6 44 | 4f 20 62 75 69 6c 64 73 |.......D|O builds|
|00003380| 6c 69 73 74 0d 0a 44 4f | 20 62 75 69 6c 64 73 70 |list..DO| buildsp|
|00003390| 6f 70 0d 0a 0d 0a 73 71 | 6c 73 65 6c 65 63 74 20 |op....sq|lselect |
|000033a0| 3d 20 62 75 69 6c 64 73 | 71 6c 28 29 0d 0a 0d 0a |= builds|ql()....|
|000033b0| 49 46 20 28 65 78 69 74 | 61 63 74 69 6f 6e 20 3d |IF (exit|action =|
|000033c0| 3d 20 31 29 0d 0a 09 44 | 4f 20 78 71 75 65 72 79 |= 1)...D|O xquery|
|000033d0| 20 57 49 54 48 20 73 71 | 6c 73 65 6c 65 63 74 0d | WITH sq|lselect.|
|000033e0| 0a 09 52 45 54 55 52 4e | 20 2e 46 2e 0d 0a 45 4c |..RETURN| .F...EL|
|000033f0| 53 45 0d 0a 09 49 46 20 | 28 65 78 69 74 61 63 74 |SE...IF |(exitact|
|00003400| 69 6f 6e 20 3d 3d 20 32 | 29 0d 0a 09 09 48 49 44 |ion == 2|)....HID|
|00003410| 45 20 57 49 4e 44 4f 57 | 20 62 75 69 6c 64 71 75 |E WINDOW| buildqu|
|00003420| 65 72 79 0d 0a 09 09 44 | 4f 20 65 64 69 74 71 75 |ery....D|O editqu|
|00003430| 65 72 2e 73 70 72 0d 0a | 09 09 52 45 54 55 52 4e |er.spr..|..RETURN|
|00003440| 20 2e 54 2e 0d 0a 09 45 | 4c 53 45 0d 0a 09 09 49 | .T....E|LSE....I|
|00003450| 46 20 28 65 78 69 74 61 | 63 74 69 6f 6e 20 3d 3d |F (exita|ction ==|
|00003460| 20 33 29 0d 0a 09 09 09 | 44 49 4d 45 4e 53 49 4f | 3).....|DIMENSIO|
|00003470| 4e 20 66 72 6f 6d 6c 69 | 73 74 5b 31 5d 0d 0a 09 |N fromli|st[1]...|
|00003480| 09 09 44 49 4d 45 4e 53 | 49 4f 4e 20 73 65 6c 65 |..DIMENS|ION sele|
|00003490| 63 74 6c 69 73 74 5b 31 | 5d 0d 0a 09 09 09 44 49 |ctlist[1|].....DI|
|000034a0| 4d 45 4e 53 49 4f 4e 20 | 77 68 65 72 65 6c 69 73 |MENSION |wherelis|
|000034b0| 74 5b 31 5d 0d 0a 09 09 | 09 44 4f 20 62 75 69 6c |t[1]....|.DO buil|
|000034c0| 64 66 70 6f 70 0d 0a 09 | 09 09 44 4f 20 62 75 69 |dfpop...|..DO bui|
|000034d0| 6c 64 73 70 6f 70 0d 0a | 09 09 09 53 48 4f 57 20 |ldspop..|...SHOW |
|000034e0| 47 45 54 20 65 64 69 74 | 77 68 65 72 65 0d 0a 09 |GET edit|where...|
|000034f0| 09 09 52 45 54 55 52 4e | 20 2e 46 2e 0d 0a 09 09 |..RETURN| .F.....|
|00003500| 45 4c 53 45 0d 0a 09 09 | 09 52 45 54 55 52 4e 20 |ELSE....|.RETURN |
|00003510| 2e 54 2e 0d 0a 09 09 45 | 4e 44 49 46 0d 0a 09 45 |.T.....E|NDIF...E|
|00003520| 4e 44 49 46 0d 0a 45 4e | 44 49 46 0d 0a 00 00 00 |NDIF..EN|DIF.....|
|00003530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003540| 01 00 00 00 b2 69 66 20 | 61 6c 65 6e 28 66 72 6f |.....if |alen(fro|
|00003550| 6d 6c 69 73 74 29 20 3c | 20 33 0d 0a 09 73 68 6f |mlist) <| 3...sho|
|00003560| 77 20 67 65 74 20 64 75 | 6d 6d 79 20 64 69 73 61 |w get du|mmy disa|
|00003570| 62 6c 65 64 0d 0a 65 6c | 73 65 0d 0a 09 73 68 6f |bled..el|se...sho|
|00003580| 77 20 67 65 74 20 64 75 | 6d 6d 79 20 65 6e 61 62 |w get du|mmy enab|
|00003590| 6c 65 64 0d 0a 65 6e 64 | 69 66 0d 0a 69 66 20 61 |led..end|if..if a|
|000035a0| 6c 65 6e 28 66 72 6f 6d | 6c 69 73 74 29 20 3c 20 |len(from|list) < |
|000035b0| 32 0d 0a 09 73 68 6f 77 | 20 67 65 74 20 77 68 65 |2...show| get whe|
|000035c0| 72 65 62 75 74 20 64 69 | 73 61 62 6c 65 64 0d 0a |rebut di|sabled..|
|000035d0| 65 6c 73 65 0d 0a 09 73 | 68 6f 77 20 67 65 74 20 |else...s|how get |
|000035e0| 77 68 65 72 65 62 75 74 | 20 65 6e 61 62 6c 65 64 |wherebut| enabled|
|000035f0| 0d 0a 65 6e 64 69 66 00 | 00 00 00 00 00 00 00 00 |..endif.|........|
|00003600| 00 00 00 00 00 00 01 00 | 00 08 df 52 45 4c 45 41 |........|...RELEA|
|00003610| 53 45 20 50 4f 50 55 50 | 20 62 71 73 65 6c 65 63 |SE POPUP| bqselec|
|00003620| 74 70 6f 70 0d 0a 52 45 | 4c 45 41 53 45 20 50 4f |tpop..RE|LEASE PO|
|00003630| 50 55 50 20 62 71 66 72 | 6f 6d 70 6f 70 0d 0a 52 |PUP bqfr|ompop..R|
|00003640| 45 54 55 52 4e 0d 0a 0d | 0a 0d 0a 46 55 4e 43 54 |ETURN...|...FUNCT|
|00003650| 49 4f 4e 20 69 6e 66 72 | 6f 6d 6c 69 73 74 0d 0a |ION infr|omlist..|
|00003660| 50 41 52 41 4d 45 54 45 | 52 20 74 61 62 6c 65 6e |PARAMETE|R tablen|
|00003670| 61 6d 65 0d 0a 50 52 49 | 56 41 54 45 20 6e 66 72 |ame..PRI|VATE nfr|
|00003680| 6f 6d 73 2c 20 69 0d 0a | 6e 66 72 6f 6d 73 20 3d |oms, i..|nfroms =|
|00003690| 20 41 4c 45 4e 28 66 72 | 6f 6d 6c 69 73 74 29 0d | ALEN(fr|omlist).|
|000036a0| 0a 46 4f 52 20 69 20 3d | 20 31 20 54 4f 20 6e 66 |.FOR i =| 1 TO nf|
|000036b0| 72 6f 6d 73 20 2d 20 31 | 0d 0a 09 49 46 20 28 74 |roms - 1|...IF (t|
|000036c0| 61 62 6c 65 6e 61 6d 65 | 20 3d 3d 20 66 72 6f 6d |ablename| == from|
|000036d0| 6c 69 73 74 5b 69 5d 29 | 0d 0a 09 09 52 45 54 55 |list[i])|....RETU|
|000036e0| 52 4e 20 2e 54 2e 0d 0a | 09 45 4e 44 49 46 0d 0a |RN .T...|.ENDIF..|
|000036f0| 45 4e 44 46 4f 52 0d 0a | 52 45 54 55 52 4e 20 2e |ENDFOR..|RETURN .|
|00003700| 46 2e 0d 0a 0d 0a 50 52 | 4f 43 45 44 55 52 45 20 |F.....PR|OCEDURE |
|00003710| 64 65 6c 77 68 65 72 65 | 0d 0a 50 41 52 41 4d 45 |delwhere|..PARAME|
|00003720| 54 45 52 20 69 0d 0a 50 | 52 49 56 41 54 45 20 6c |TER i..P|RIVATE l|
|00003730| 65 6e 6c 69 73 74 0d 0a | 3d 20 41 44 45 4c 28 77 |enlist..|= ADEL(w|
|00003740| 68 65 72 65 6c 69 73 74 | 2c 20 69 29 0d 0a 6c 65 |herelist|, i)..le|
|00003750| 6e 6c 69 73 74 20 3d 20 | 41 4c 45 4e 28 77 68 65 |nlist = |ALEN(whe|
|00003760| 72 65 6c 69 73 74 29 0d | 0a 49 46 20 28 69 20 21 |relist).|.IF (i !|
|00003770| 3d 20 31 29 0d 0a 09 3d | 20 41 44 45 4c 28 77 68 |= 1)...=| ADEL(wh|
|00003780| 65 72 65 6c 69 73 74 2c | 20 69 20 2d 20 31 29 0d |erelist,| i - 1).|
|00003790| 0a 09 6c 65 6e 6c 69 73 | 74 20 3d 20 6c 65 6e 6c |..lenlis|t = lenl|
|000037a0| 69 73 74 20 2d 20 31 0d | 0a 45 4c 53 45 09 09 09 |ist - 1.|.ELSE...|
|000037b0| 20 20 26 26 20 69 20 3d | 3d 20 31 2c 20 73 6f 20 |  && i =|= 1, so |
|000037c0| 6c 6f 67 69 63 61 6c 20 | 63 6f 6e 6e 65 63 74 6f |logical |connecto|
|000037d0| 72 20 66 6f 6c 6c 6f 77 | 73 0d 0a 09 49 46 20 28 |r follow|s...IF (|
|000037e0| 6c 65 6e 6c 69 73 74 20 | 3e 20 31 29 20 20 26 26 |lenlist |> 1)  &&|
|000037f0| 20 69 66 20 74 68 65 72 | 65 20 69 73 20 6f 6e 65 | if ther|e is one|
|00003800| 0d 0a 09 09 3d 20 41 44 | 45 4c 28 77 68 65 72 65 |....= AD|EL(where|
|00003810| 6c 69 73 74 2c 20 69 29 | 0d 0a 09 09 6c 65 6e 6c |list, i)|....lenl|
|00003820| 69 73 74 20 3d 20 6c 65 | 6e 6c 69 73 74 20 2d 20 |ist = le|nlist - |
|00003830| 31 0d 0a 09 45 4e 44 49 | 46 0d 0a 45 4e 44 49 46 |1...ENDI|F..ENDIF|
|00003840| 0d 0a 44 49 4d 45 4e 53 | 49 4f 4e 20 77 68 65 72 |..DIMENS|ION wher|
|00003850| 65 6c 69 73 74 5b 4d 41 | 58 28 6c 65 6e 4c 69 73 |elist[MA|X(lenLis|
|00003860| 74 20 2d 20 31 2c 20 31 | 29 5d 0d 0a 52 45 54 55 |t - 1, 1|)]..RETU|
|00003870| 52 4e 0d 0a 0d 0a 50 52 | 4f 43 45 44 55 52 45 20 |RN....PR|OCEDURE |
|00003880| 62 75 69 6c 64 73 6c 69 | 73 74 0d 0a 50 52 49 56 |buildsli|st..PRIV|
|00003890| 41 54 45 20 6c 65 6e 6c | 69 73 74 2c 20 69 2c 20 |ATE lenl|ist, i, |
|000038a0| 43 4f 55 4e 54 2c 20 6e | 65 77 6f 72 64 65 72 2c |COUNT, n|eworder,|
|000038b0| 20 74 61 62 6c 65 6e 61 | 6d 65 0d 0a 2a 0d 0a 2a | tablena|me..*..*|
|000038c0| 09 47 65 74 20 63 75 72 | 72 65 6e 74 20 6f 72 64 |.Get cur|rent ord|
|000038d0| 65 72 20 6f 6e 20 70 6f | 70 75 70 0d 0a 2a 0d 0a |er on po|pup..*..|
|000038e0| 6c 65 6e 6c 69 73 74 20 | 3d 20 41 4c 45 4e 28 73 |lenlist |= ALEN(s|
|000038f0| 65 6c 65 63 74 6c 69 73 | 74 29 20 2d 20 31 0d 0a |electlis|t) - 1..|
|00003900| 44 49 4d 45 4e 53 49 4f | 4e 20 6e 65 77 6f 72 64 |DIMENSIO|N neword|
|00003910| 65 72 5b 6c 65 6e 4c 69 | 73 74 20 2b 20 31 5d 0d |er[lenLi|st + 1].|
|00003920| 0a 46 4f 52 20 69 20 3d | 20 31 20 54 4f 20 6c 65 |.FOR i =| 1 TO le|
|00003930| 6e 6c 69 73 74 0d 0a 09 | 6e 65 77 6f 72 64 65 72 |nlist...|neworder|
|00003940| 5b 69 5d 20 3d 20 73 65 | 6c 65 63 74 6c 69 73 74 |[i] = se|lectlist|
|00003950| 5b 47 45 54 42 41 52 28 | 22 42 51 53 65 6c 65 63 |[GETBAR(|"BQSelec|
|00003960| 74 50 6f 22 2c 20 69 29 | 5d 0d 0a 45 4e 44 46 4f |tPo", i)|]..ENDFO|
|00003970| 52 0d 0a 46 4f 52 20 69 | 20 3d 20 31 20 54 4f 20 |R..FOR i| = 1 TO |
|00003980| 6c 65 6e 6c 69 73 74 0d | 0a 09 73 65 6c 65 63 74 |lenlist.|..select|
|00003990| 6c 69 73 74 5b 69 5d 20 | 3d 20 6e 65 77 6f 72 64 |list[i] |= neword|
|000039a0| 65 72 5b 69 5d 0d 0a 45 | 4e 44 46 4f 52 0d 0a 2a |er[i]..E|NDFOR..*|
|000039b0| 0d 0a 2a 09 43 68 65 63 | 6b 20 61 67 61 69 6e 73 |..*.Chec|k agains|
|000039c0| 74 20 46 52 4f 4d 20 6c | 69 73 74 0d 0a 2a 0d 0a |t FROM l|ist..*..|
|000039d0| 69 20 3d 20 31 20 26 26 | 20 61 63 63 6f 75 6e 74 |i = 1 &&| account|
|000039e0| 20 66 6f 72 20 64 65 6c | 65 74 65 73 20 66 72 6f | for del|etes fro|
|000039f0| 6d 20 61 72 72 61 79 20 | 53 65 6c 65 63 74 4c 69 |m array |SelectLi|
|00003a00| 73 74 20 77 68 69 63 68 | 20 6d 6f 76 65 73 20 65 |st which| moves e|
|00003a10| 76 65 72 79 74 68 69 6e | 67 20 75 70 0d 0a 46 4f |verythin|g up..FO|
|00003a20| 52 20 43 4f 55 4e 54 20 | 3d 20 31 20 54 4f 20 6c |R COUNT |= 1 TO l|
|00003a30| 65 6e 6c 69 73 74 0d 0a | 09 2a 0d 0a 09 2a 09 09 |enlist..|.*...*..|
|00003a40| 45 78 74 72 61 63 74 20 | 74 61 62 6c 65 20 6e 61 |Extract |table na|
|00003a50| 6d 65 20 66 72 6f 6d 20 | 63 6f 6c 75 6d 6e 20 6e |me from |column n|
|00003a60| 61 6d 65 0d 0a 09 2a 0d | 0a 09 74 61 62 6c 65 6e |ame...*.|..tablen|
|00003a70| 61 6d 65 20 3d 20 53 55 | 42 53 54 52 28 73 65 6c |ame = SU|BSTR(sel|
|00003a80| 65 63 74 6c 69 73 74 5b | 69 5d 2c 20 31 2c 20 41 |ectlist[|i], 1, A|
|00003a90| 54 28 22 2e 22 2c 20 73 | 65 6c 65 63 74 6c 69 73 |T(".", s|electlis|
|00003aa0| 74 5b 69 5d 29 20 2d 20 | 31 29 0d 0a 09 49 46 20 |t[i]) - |1)...IF |
|00003ab0| 28 20 2e 4e 4f 54 2e 20 | 69 6e 66 72 6f 6d 6c 69 |( .NOT. |infromli|
|00003ac0| 73 74 28 74 61 62 6c 65 | 6e 61 6d 65 29 29 0d 0a |st(table|name))..|
|00003ad0| 09 09 3d 20 41 44 45 4c | 28 73 65 6c 65 63 74 6c |..= ADEL|(selectl|
|00003ae0| 69 73 74 2c 20 69 29 0d | 0a 09 45 4c 53 45 0d 0a |ist, i).|..ELSE..|
|00003af0| 09 09 69 20 3d 20 69 20 | 2b 20 31 0d 0a 09 45 4e |..i = i |+ 1...EN|
|00003b00| 44 49 46 0d 0a 45 4e 44 | 46 4f 52 0d 0a 44 49 4d |DIF..END|FOR..DIM|
|00003b10| 45 4e 53 49 4f 4e 20 73 | 65 6c 65 63 74 6c 69 73 |ENSION s|electlis|
|00003b20| 74 5b 69 5d 0d 0a 52 45 | 54 55 52 4e 20 20 26 26 |t[i]..RE|TURN  &&|
|00003b30| 20 50 52 4f 43 45 44 55 | 52 45 20 42 75 69 6c 64 | PROCEDU|RE Build|
|00003b40| 53 4c 69 73 74 0d 0a 0d | 0a 0d 0a 50 52 4f 43 45 |SList...|...PROCE|
|00003b50| 44 55 52 45 20 62 75 69 | 6c 64 73 70 6f 70 0d 0a |DURE bui|ldspop..|
|00003b60| 50 52 49 56 41 54 45 20 | 6c 65 6e 6c 69 73 74 2c |PRIVATE |lenlist,|
|00003b70| 20 69 0d 0a 52 45 4c 45 | 41 53 45 20 42 41 52 20 | i..RELE|ASE BAR |
|00003b80| 41 4c 4c 20 4f 46 20 62 | 71 73 65 6c 65 63 74 70 |ALL OF b|qselectp|
|00003b90| 6f 70 0d 0a 6c 65 6e 6c | 69 73 74 20 3d 20 41 4c |op..lenl|ist = AL|
|00003ba0| 45 4e 28 73 65 6c 65 63 | 74 6c 69 73 74 29 20 2d |EN(selec|tlist) -|
|00003bb0| 20 31 0d 0a 46 4f 52 20 | 69 20 3d 20 31 20 54 4f | 1..FOR |i = 1 TO|
|00003bc0| 20 6c 65 6e 6c 69 73 74 | 0d 0a 09 44 45 46 49 4e | lenlist|...DEFIN|
|00003bd0| 45 20 42 41 52 20 28 69 | 29 20 4f 46 20 62 71 73 |E BAR (i|) OF bqs|
|00003be0| 65 6c 65 63 74 70 6f 70 | 20 50 52 4f 4d 50 54 20 |electpop| PROMPT |
|00003bf0| 73 65 6c 65 63 74 6c 69 | 73 74 5b 69 5d 0d 0a 45 |selectli|st[i]..E|
|00003c00| 4e 44 46 4f 52 0d 0a 53 | 48 4f 57 20 47 45 54 20 |NDFOR..S|HOW GET |
|00003c10| 73 65 6c 65 63 74 70 6f | 70 0d 0a 52 45 54 55 52 |selectpo|p..RETUR|
|00003c20| 4e 0d 0a 0d 0a 0d 0a 50 | 52 4f 43 45 44 55 52 45 |N......P|ROCEDURE|
|00003c30| 20 62 75 69 6c 64 66 70 | 6f 70 0d 0a 50 52 49 56 | buildfp|op..PRIV|
|00003c40| 41 54 45 20 6c 65 6e 6c | 69 73 74 0d 0a 52 45 4c |ATE lenl|ist..REL|
|00003c50| 45 41 53 45 20 42 41 52 | 20 41 4c 4c 20 4f 46 20 |EASE BAR| ALL OF |
|00003c60| 62 71 66 72 6f 6d 70 6f | 70 0d 0a 6c 65 6e 6c 69 |bqfrompo|p..lenli|
|00003c70| 73 74 20 3d 20 41 4c 45 | 4e 28 66 72 6f 6d 6c 69 |st = ALE|N(fromli|
|00003c80| 73 74 29 20 2d 20 31 0d | 0a 46 4f 52 20 69 20 3d |st) - 1.|.FOR i =|
|00003c90| 20 31 20 54 4f 20 6c 65 | 6e 6c 69 73 74 0d 0a 09 | 1 TO le|nlist...|
|00003ca0| 44 45 46 49 4e 45 20 42 | 41 52 20 28 69 29 20 4f |DEFINE B|AR (i) O|
|00003cb0| 46 20 62 71 66 72 6f 6d | 70 6f 70 20 50 52 4f 4d |F bqfrom|pop PROM|
|00003cc0| 50 54 20 66 72 6f 6d 6c | 69 73 74 5b 69 5d 0d 0a |PT froml|ist[i]..|
|00003cd0| 45 4e 44 46 4f 52 0d 0a | 53 48 4f 57 20 47 45 54 |ENDFOR..|SHOW GET|
|00003ce0| 20 66 70 6f 70 64 75 6d | 6d 79 0d 0a 52 45 54 55 | fpopdum|my..RETU|
|00003cf0| 52 4e 0d 0a 0d 0a 0d 0a | 50 52 4f 43 45 44 55 52 |RN......|PROCEDUR|
|00003d00| 45 20 62 75 69 6c 64 63 | 6c 69 73 74 0d 0a 44 49 |E buildc|list..DI|
|00003d10| 4d 45 4e 53 49 4f 4e 20 | 63 6f 6c 75 6d 6e 6c 69 |MENSION |columnli|
|00003d20| 73 74 5b 31 5d 0d 0a 6e | 66 72 6f 6d 20 3d 20 41 |st[1]..n|from = A|
|00003d30| 4c 45 4e 28 66 72 6f 6d | 6c 69 73 74 29 0d 0a 46 |LEN(from|list)..F|
|00003d40| 4f 52 20 69 20 3d 20 31 | 20 54 4f 20 6e 66 72 6f |OR i = 1| TO nfro|
|00003d50| 6d 20 2d 20 31 0d 0a 09 | 44 4f 20 61 64 64 63 6f |m - 1...|DO addco|
|00003d60| 6c 75 6d 6e 73 20 57 49 | 54 48 20 66 72 6f 6d 6c |lumns WI|TH froml|
|00003d70| 69 73 74 5b 69 5d 0d 0a | 45 4e 44 46 4f 52 0d 0a |ist[i]..|ENDFOR..|
|00003d80| 52 45 54 55 52 4e 0d 0a | 0d 0a 0d 0a 50 52 4f 43 |RETURN..|....PROC|
|00003d90| 45 44 55 52 45 20 61 64 | 64 63 6f 6c 75 6d 6e 73 |EDURE ad|dcolumns|
|00003da0| 0d 0a 50 41 52 41 4d 45 | 54 45 52 20 74 61 62 6c |..PARAME|TER tabl|
|00003db0| 65 6e 61 6d 65 0d 0a 50 | 52 49 56 41 54 45 20 6c |ename..P|RIVATE l|
|00003dc0| 65 6e 6c 69 73 74 0d 0a | 49 46 20 28 63 6b 68 61 |enlist..|IF (ckha|
|00003dd0| 6e 64 6c 65 20 3d 3d 20 | 30 29 0d 0a 09 53 45 4c |ndle == |0)...SEL|
|00003de0| 45 43 54 20 30 0d 0a 09 | 55 53 45 20 63 6f 6c 75 |ECT 0...|USE colu|
|00003df0| 6d 6e 73 0d 0a 45 4c 53 | 45 0d 0a 09 3d 20 64 62 |mns..ELS|E...= db|
|00003e00| 63 6f 6c 73 28 63 6b 68 | 61 6e 64 6c 65 2c 20 74 |cols(ckh|andle, t|
|00003e10| 61 62 6c 65 6e 61 6d 65 | 2c 20 22 46 6f 78 50 72 |ablename|, "FoxPr|
|00003e20| 6f 22 29 0d 0a 45 4e 44 | 49 46 0d 0a 6c 65 6e 6c |o")..END|IF..lenl|
|00003e30| 69 73 74 20 3d 20 41 4c | 45 4e 28 63 6f 6c 75 6d |ist = AL|EN(colum|
|00003e40| 6e 6c 69 73 74 29 0d 0a | 44 49 4d 45 4e 53 49 4f |nlist)..|DIMENSIO|
|00003e50| 4e 20 63 6f 6c 75 6d 6e | 6c 69 73 74 5b 6c 65 6e |N column|list[len|
|00003e60| 4c 69 73 74 20 2b 20 52 | 45 43 43 4f 28 29 5d 0d |List + R|ECCO()].|
|00003e70| 0a 53 43 41 4e 0d 0a 09 | 63 6f 6c 75 6d 6e 6c 69 |.SCAN...|columnli|
|00003e80| 73 74 5b 6c 65 6e 4c 69 | 73 74 5d 20 3d 20 74 61 |st[lenLi|st] = ta|
|00003e90| 62 6c 65 6e 61 6d 65 20 | 2b 20 22 2e 22 20 2b 20 |blename |+ "." + |
|00003ea0| 4c 4f 57 45 52 28 41 4c | 4c 54 52 49 4d 28 66 69 |LOWER(AL|LTRIM(fi|
|00003eb0| 65 6c 64 5f 6e 61 6d 65 | 29 29 0d 0a 09 6c 65 6e |eld_name|))...len|
|00003ec0| 6c 69 73 74 20 3d 20 6c | 65 6e 6c 69 73 74 20 2b |list = l|enlist +|
|00003ed0| 20 31 0d 0a 45 4e 44 53 | 43 41 4e 0d 0a 55 53 45 | 1..ENDS|CAN..USE|
|00003ee0| 0d 0a 52 45 54 55 52 4e | 0d 0a 00 00 00 00 00 00 |..RETURN|........|
|00003ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00003f10| f5 44 4f 20 62 75 69 6c | 64 74 6c 69 73 74 0d 0a |.DO buil|dtlist..|
|00003f20| 0d 0a 49 46 20 28 41 4c | 45 4e 28 74 61 62 6c 65 |..IF (AL|EN(table|
|00003f30| 6c 69 73 74 29 20 3c 20 | 32 29 0d 0a 09 3f 3f 20 |list) < |2)...?? |
|00003f40| 43 48 52 28 37 29 0d 0a | 09 57 41 49 54 20 57 49 |CHR(7)..|.WAIT WI|
|00003f50| 4e 44 4f 57 20 22 4e 6f | 20 74 61 62 6c 65 73 20 |NDOW "No| tables |
|00003f60| 69 6e 20 64 61 74 61 62 | 61 73 65 22 0d 0a 09 52 |in datab|ase"...R|
|00003f70| 45 54 55 52 4e 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |ETURN..E|NDIF....|
|00003f80| 44 45 46 49 4e 45 20 50 | 4f 50 55 50 20 62 71 73 |DEFINE P|OPUP bqs|
|00003f90| 65 6c 65 63 74 70 6f 70 | 20 53 43 52 4f 4c 4c 20 |electpop| SCROLL |
|00003fa0| 4d 41 52 47 49 4e 20 4d | 41 52 4b 20 22 20 22 20 |MARGIN M|ARK " " |
|00003fb0| 4d 4f 56 45 52 0d 0a 44 | 45 46 49 4e 45 20 50 4f |MOVER..D|EFINE PO|
|00003fc0| 50 55 50 20 62 71 66 72 | 6f 6d 70 6f 70 20 20 20 |PUP bqfr|ompop   |
|00003fd0| 53 43 52 4f 4c 4c 20 4d | 41 52 47 49 4e 20 4d 41 |SCROLL M|ARGIN MA|
|00003fe0| 52 4b 20 22 20 22 0d 0a | 0d 0a 44 4f 20 62 75 69 |RK " "..|..DO bui|
|00003ff0| 6c 64 66 70 6f 70 0d 0a | 44 4f 20 62 75 69 6c 64 |ldfpop..|DO build|
|00004000| 73 70 6f 70 0d 0a 00 00 | 00 00 00 00 00 00 00 00 |spop....|........|
|00004010| 00 00 00 00 01 00 00 00 | 0a 45 78 69 74 41 63 74 |........|.ExitAct|
|00004020| 69 6f 6e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ion.....|........|
|00004030| 00 00 00 00 00 01 00 00 | 00 2e 22 40 2a 56 54 20 |........|.."@*VT |
|00004040| 5c 21 20 45 5c 3c 78 65 | 63 75 74 65 20 3b 5c 3c |\! E\<xe|cute ;\<|
|00004050| 45 64 69 74 2e 2e 2e 3b | 43 5c 3c 6c 65 61 72 3b |Edit...;|C\<lear;|
|00004060| 5c 3f 43 6c 6f 73 65 22 | 00 00 00 00 00 00 00 00 |\?Close"|........|
|00004070| 00 00 00 00 00 00 00 01 | 00 00 00 0b 22 20 45 78 |........|...." Ex|
|00004080| 65 63 75 74 65 20 22 00 | 00 00 00 00 00 00 00 00 |ecute ".|........|
|00004090| 00 00 00 00 00 00 00 00 | 01 00 00 00 0a 46 72 6f |........|.....Fro|
|000040a0| 6d 42 75 74 74 6f 6e 00 | 00 00 00 00 00 00 00 00 |mButton.|........|
|000040b0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 10 22 40 |........|......"@|
|000040c0| 2a 56 4e 20 5c 3c 46 72 | 6f 6d 2e 2e 2e 22 00 00 |*VN \<Fr|om..."..|
|000040d0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 04 54 50 |........|......TP|
|000040e0| 52 49 56 41 54 45 20 69 | 2c 20 74 61 62 6c 65 4e |RIVATE i|, tableN|
|000040f0| 61 6d 65 2c 20 63 6f 75 | 6e 74 2c 20 69 6e 4c 69 |ame, cou|nt, inLi|
|00004100| 73 74 0d 0a 0d 0a 44 4f | 20 46 72 6f 6d 2e 53 50 |st....DO| From.SP|
|00004110| 52 0d 0a 44 4f 20 42 75 | 69 6c 64 46 50 6f 70 0d |R..DO Bu|ildFPop.|
|00004120| 0a 0d 0a 44 4f 20 42 75 | 69 6c 64 53 4c 69 73 74 |...DO Bu|ildSList|
|00004130| 0d 0a 44 4f 20 42 75 69 | 6c 64 53 50 6f 70 0d 0a |..DO Bui|ldSPop..|
|00004140| 0d 0a 44 4f 20 42 75 69 | 6c 64 43 4c 69 73 74 0d |..DO Bui|ldCList.|
|00004150| 0a 2a 0d 0a 2a 09 52 65 | 62 75 69 6c 64 20 57 48 |.*..*.Re|build WH|
|00004160| 45 52 45 20 6c 69 73 74 | 2e 20 4d 75 73 74 20 64 |ERE list|. Must d|
|00004170| 6f 20 74 68 69 73 2c 20 | 62 65 63 61 75 73 65 20 |o this, |because |
|00004180| 74 68 65 20 72 65 6d 6f | 76 61 6c 20 6f 66 20 61 |the remo|val of a|
|00004190| 0d 0a 2a 09 74 61 62 6c | 65 20 63 6f 75 6c 64 20 |..*.tabl|e could |
|000041a0| 6d 65 61 6e 20 73 6f 6d | 65 20 6f 66 20 74 68 65 |mean som|e of the|
|000041b0| 73 65 20 63 6f 6c 75 6d | 6e 73 20 63 61 6e 20 6e |se colum|ns can n|
|000041c0| 6f 20 6c 6f 6e 67 65 72 | 20 62 65 0d 0a 2a 09 53 |o longer| be..*.S|
|000041d0| 45 4c 45 43 54 65 64 2e | 0d 0a 2a 0d 0a 69 20 3d |ELECTed.|..*..i =|
|000041e0| 20 31 20 26 26 20 61 63 | 63 6f 75 6e 74 20 66 6f | 1 && ac|count fo|
|000041f0| 72 20 64 65 6c 65 74 65 | 73 20 66 72 6f 6d 20 61 |r delete|s from a|
|00004200| 72 72 61 79 20 77 68 69 | 63 68 20 6d 6f 76 65 73 |rray whi|ch moves|
|00004210| 20 65 76 65 72 79 74 68 | 69 6e 67 20 75 70 0d 0a | everyth|ing up..|
|00004220| 44 4f 20 57 48 49 4c 45 | 20 28 69 20 3c 20 41 4c |DO WHILE| (i < AL|
|00004230| 45 4e 28 57 68 65 72 65 | 4c 69 73 74 29 29 0d 0a |EN(Where|List))..|
|00004240| 2a 0d 0a 2a 09 09 45 78 | 74 72 61 63 74 20 74 61 |*..*..Ex|tract ta|
|00004250| 62 6c 65 20 6e 61 6d 65 | 73 20 66 72 6f 6d 20 57 |ble name|s from W|
|00004260| 48 45 52 45 20 63 6f 6e | 64 69 74 69 6f 6e 0d 0a |HERE con|dition..|
|00004270| 2a 09 0d 0a 09 72 65 73 | 74 4f 66 57 68 65 72 65 |*....res|tOfWhere|
|00004280| 20 3d 20 57 68 65 72 65 | 4c 69 73 74 5b 69 5d 0d | = Where|List[i].|
|00004290| 0a 20 20 20 20 44 49 4d | 45 4e 53 49 4f 4e 20 74 |.    DIM|ENSION t|
|000042a0| 61 62 6c 65 4e 61 6d 65 | 5b 31 5d 0d 0a 20 20 20 |ableName|[1]..   |
|000042b0| 20 44 4f 20 57 48 49 4c | 45 20 2e 54 2e 0d 0a 09 | DO WHIL|E .T....|
|000042c0| 09 65 6e 64 53 65 70 20 | 3d 20 41 54 28 22 2e 22 |.endSep |= AT("."|
|000042d0| 2c 20 72 65 73 74 4f 66 | 57 68 65 72 65 29 0d 0a |, restOf|Where)..|
|000042e0| 09 09 49 46 20 28 65 6e | 64 53 65 70 20 3e 20 30 |..IF (en|dSep > 0|
|000042f0| 29 0d 0a 09 09 09 62 65 | 67 53 65 70 20 3d 20 52 |).....be|gSep = R|
|00004300| 41 54 28 22 20 22 2c 20 | 53 55 42 53 54 52 28 72 |AT(" ", |SUBSTR(r|
|00004310| 65 73 74 4f 66 57 68 65 | 72 65 2c 20 31 2c 20 65 |estOfWhe|re, 1, e|
|00004320| 6e 64 53 65 70 20 2d 20 | 31 29 29 0d 0a 09 09 09 |ndSep - |1)).....|
|00004330| 69 6e 4c 69 73 74 20 3d | 20 41 4c 45 4e 28 74 61 |inList =| ALEN(ta|
|00004340| 62 6c 65 4e 61 6d 65 29 | 0d 0a 09 09 09 44 49 4d |bleName)|.....DIM|
|00004350| 45 4e 53 49 4f 4e 20 74 | 61 62 6c 65 4e 61 6d 65 |ENSION t|ableName|
|00004360| 5b 69 6e 4c 69 73 74 20 | 2b 20 31 5d 0d 0a 09 09 |[inList |+ 1]....|
|00004370| 09 74 61 62 6c 65 4e 61 | 6d 65 5b 69 6e 4c 69 73 |.tableNa|me[inLis|
|00004380| 74 5d 20 3d 20 53 55 42 | 53 54 52 28 72 65 73 74 |t] = SUB|STR(rest|
|00004390| 4f 66 57 68 65 72 65 2c | 20 62 65 67 53 65 70 20 |OfWhere,| begSep |
|000043a0| 2b 20 31 2c 3b 0d 0a 09 | 09 09 09 65 6e 64 53 65 |+ 1,;...|...endSe|
|000043b0| 70 20 2d 20 62 65 67 53 | 65 70 20 2d 20 31 29 0d |p - begS|ep - 1).|
|000043c0| 0a 09 09 09 72 65 73 74 | 4f 66 57 68 65 72 65 20 |....rest|OfWhere |
|000043d0| 3d 20 53 55 42 53 54 52 | 28 72 65 73 74 4f 66 57 |= SUBSTR|(restOfW|
|000043e0| 68 65 72 65 2c 20 65 6e | 64 53 65 70 20 2b 20 31 |here, en|dSep + 1|
|000043f0| 29 0d 0a 09 09 45 4c 53 | 45 0d 0a 09 09 09 45 58 |)....ELS|E.....EX|
|00004400| 49 54 0d 0a 09 09 45 4e | 44 49 46 0d 0a 09 45 4e |IT....EN|DIF...EN|
|00004410| 44 44 4f 0d 0a 0d 0a 09 | 64 65 6c 65 74 65 46 6c |DDO.....|deleteFl|
|00004420| 61 67 20 3d 20 2e 46 2e | 0d 0a 09 69 6e 4c 69 73 |ag = .F.|...inLis|
|00004430| 74 20 3d 20 41 4c 45 4e | 28 74 61 62 6c 65 4e 61 |t = ALEN|(tableNa|
|00004440| 6d 65 29 20 2d 20 31 0d | 0a 09 46 4f 52 20 6a 20 |me) - 1.|..FOR j |
|00004450| 3d 20 31 20 54 4f 20 69 | 6e 4c 69 73 74 0d 0a 0d |= 1 TO i|nList...|
|00004460| 0a 09 09 49 46 20 28 2e | 4e 4f 54 2e 20 49 6e 46 |...IF (.|NOT. InF|
|00004470| 72 6f 6d 4c 69 73 74 28 | 74 61 62 6c 65 4e 61 6d |romList(|tableNam|
|00004480| 65 5b 6a 5d 29 29 0d 0a | 09 09 09 44 4f 20 44 65 |e[j]))..|...DO De|
|00004490| 6c 57 68 65 72 65 20 57 | 49 54 48 20 69 0d 0a 09 |lWhere W|ITH i...|
|000044a0| 09 09 64 65 6c 65 74 65 | 46 6c 61 67 20 3d 20 2e |..delete|Flag = .|
|000044b0| 54 2e 0d 0a 09 09 09 45 | 58 49 54 0d 0a 09 09 45 |T......E|XIT....E|
|000044c0| 4e 44 49 46 0d 0a 0d 0a | 20 20 20 20 45 4e 44 46 |NDIF....|    ENDF|
|000044d0| 4f 52 0d 0a 0d 0a 20 20 | 20 20 49 46 20 28 2e 4e |OR....  |  IF (.N|
|000044e0| 4f 54 2e 20 64 65 6c 65 | 74 65 46 6c 61 67 29 0d |OT. dele|teFlag).|
|000044f0| 0a 09 09 69 20 3d 20 69 | 20 2b 20 31 0d 0a 09 45 |...i = i| + 1...E|
|00004500| 4e 44 49 46 09 09 0d 0a | 0d 0a 45 4e 44 44 4f 0d |NDIF....|..ENDDO.|
|00004510| 0a 53 48 4f 57 20 47 45 | 54 20 45 64 69 74 57 68 |.SHOW GE|T EditWh|
|00004520| 65 72 65 0d 0a 0d 0a 52 | 45 54 55 52 4e 20 2e 54 |ere....R|ETURN .T|
|00004530| 2e 0d 0a 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00004540| 09 22 46 72 6f 6d 2e 2e | 2e 22 00 00 00 00 00 00 |."From..|."......|
|00004550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00004560| 00 07 46 72 6f 6d 50 6f | 70 00 00 00 00 00 00 00 |..FromPo|p.......|
|00004570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00004580| 00 00 09 42 51 46 72 6f | 6d 50 6f 70 00 00 00 00 |...BQFro|mPop....|
|00004590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000045a0| 00 00 00 05 22 40 26 4e | 22 00 00 00 00 00 00 00 |...."@&N|".......|
|000045b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045c0| 01 00 00 00 01 31 00 00 | 00 00 00 00 00 00 00 00 |.....1..|........|
|000045d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045e0| 00 01 00 00 00 12 41 4c | 45 4e 28 46 72 6f 6d 4c |......AL|EN(FromL|
|000045f0| 69 73 74 29 20 2d 20 31 | 00 00 00 00 00 00 00 00 |ist) - 1|........|
|00004600| 00 00 01 00 00 00 09 53 | 65 6c 65 63 74 50 6f 70 |.......S|electPop|
|00004610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004620| 00 00 00 01 00 00 00 0a | 42 51 53 65 6c 65 63 74 |........|BQSelect|
|00004630| 50 6f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |Po......|........|
|00004640| 00 00 00 00 01 00 00 00 | 05 22 40 26 4e 22 00 00 |........|."@&N"..|
|00004650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004660| 00 00 00 00 00 01 00 00 | 00 01 31 00 00 00 00 00 |........|..1.....|
|00004670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004680| 00 00 00 00 00 00 01 00 | 00 00 14 41 4c 45 4e 28 |........|...ALEN(|
|00004690| 53 65 6c 65 63 74 4c 69 | 73 74 29 20 2d 20 31 00 |SelectLi|st) - 1.|
|000046a0| 00 00 00 00 00 00 00 01 | 00 00 00 2b 44 4f 20 42 |........|...+DO B|
|000046b0| 75 69 6c 64 53 4c 69 73 | 74 20 20 0d 0a 44 4f 20 |uildSLis|t  ..DO |
|000046c0| 42 75 69 6c 64 53 50 6f | 70 0d 0a 0d 0a 52 45 54 |BuildSPo|p....RET|
|000046d0| 55 52 4e 20 2e 54 2e 00 | 00 00 00 00 00 00 00 00 |URN .T..|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0c 53 65 |........|......Se|
|000046f0| 6c 65 63 74 42 75 74 74 | 6f 6e 00 00 00 00 00 00 |lectButt|on......|
|00004700| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 12 22 |........|......."|
|00004710| 40 2a 56 4e 20 5c 3c 53 | 65 6c 65 63 74 2e 2e 2e |@*VN \<S|elect...|
|00004720| 22 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 3a |".......|.......:|
|00004730| 44 4f 20 42 75 69 6c 64 | 53 4c 69 73 74 20 20 0d |DO Build|SList  .|
|00004740| 0a 44 4f 20 53 65 6c 65 | 63 74 2e 53 50 52 0d 0a |.DO Sele|ct.SPR..|
|00004750| 44 4f 20 42 75 69 6c 64 | 53 50 6f 70 0d 0a 0d 0a |DO Build|SPop....|
|00004760| 52 45 54 55 52 4e 20 2e | 54 2e 00 00 00 01 00 00 |RETURN .|T.......|
|00004770| 00 0b 22 53 65 6c 65 63 | 74 2e 2e 2e 22 00 00 00 |.."Selec|t..."...|
|00004780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00004790| 00 00 05 44 75 6d 6d 79 | 00 00 00 00 00 00 00 00 |...Dummy|........|
|000047a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000047b0| 00 00 00 10 22 40 2a 56 | 4e 20 5c 3c 4a 6f 69 6e |...."@*V|N \<Join|
|000047c0| 2e 2e 2e 22 00 00 00 00 | 00 00 00 00 00 00 00 00 |..."....|........|
|000047d0| 01 00 00 00 2b 44 4f 20 | 4a 6f 69 6e 2e 53 50 52 |....+DO |Join.SPR|
|000047e0| 0d 0a 53 48 4f 57 20 47 | 45 54 20 45 64 69 74 57 |..SHOW G|ET EditW|
|000047f0| 68 65 72 65 0d 0a 52 45 | 54 55 52 4e 20 2e 54 2e |here..RE|TURN .T.|
|00004800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004810| 00 00 01 00 00 00 09 22 | 4a 6f 69 6e 2e 2e 2e 22 |......."|Join..."|
|00004820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004830| 00 00 00 01 00 00 00 08 | 77 68 65 72 65 62 75 74 |........|wherebut|
|00004840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004850| 00 00 00 00 01 00 00 00 | 11 22 40 2a 56 4e 20 5c |........|."@*VN \|
|00004860| 3c 57 68 65 72 65 2e 2e | 2e 22 00 00 00 00 00 00 |<Where..|."......|
|00004870| 00 00 00 00 00 01 00 00 | 00 2c 44 4f 20 57 68 65 |........|.,DO Whe|
|00004880| 72 65 2e 53 50 52 0d 0a | 53 48 4f 57 20 47 45 54 |re.SPR..|SHOW GET|
|00004890| 20 45 64 69 74 57 68 65 | 72 65 0d 0a 52 45 54 55 | EditWhe|re..RETU|
|000048a0| 52 4e 20 2e 54 2e 00 00 | 00 00 00 00 00 00 00 00 |RN .T...|........|
|000048b0| 00 00 00 00 00 00 00 01 | 00 00 00 0a 22 57 68 65 |........|...."Whe|
|000048c0| 72 65 2e 2e 2e 22 00 00 | 00 00 00 00 00 00 00 00 |re..."..|........|
|000048d0| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 45 64 69 |........|.....Edi|
|000048e0| 74 57 68 65 72 65 00 00 | 00 00 00 00 00 00 00 00 |tWhere..|........|
|000048f0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 09 57 68 |........|......Wh|
|00004900| 65 72 65 4c 69 73 74 00 | 00 00 00 00 00 00 00 00 |ereList.|........|
|00004910| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 05 22 |........|......."|
|00004920| 40 26 4e 22 00 00 00 00 | 00 00 00 00 00 00 00 00 |@&N"....|........|
|00004930| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 01 |........|........|
|00004940| 31 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|00004950| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00004960| 13 41 4c 45 4e 28 57 68 | 65 72 65 4c 69 73 74 29 |.ALEN(Wh|ereList)|
|00004970| 20 2d 20 31 00 00 00 00 | 00 00 00 00 00 01 00 00 | - 1....|........|
|00004980| 00 7d 44 4f 20 45 64 69 | 74 57 68 65 72 2e 53 50 |.}DO Edi|tWher.SP|
|00004990| 52 0d 0a 0d 0a 49 46 20 | 28 45 4d 50 54 59 28 57 |R....IF |(EMPTY(W|
|000049a0| 68 65 72 65 4c 69 73 74 | 5b 45 64 69 74 57 68 65 |hereList|[EditWhe|
|000049b0| 72 65 5d 29 29 0d 0a 09 | 44 4f 20 44 65 6c 57 68 |re]))...|DO DelWh|
|000049c0| 65 72 65 20 57 49 54 48 | 20 45 64 69 74 57 68 65 |ere WITH| EditWhe|
|000049d0| 72 65 0d 0a 45 4e 44 49 | 46 0d 0a 0d 0a 53 48 4f |re..ENDI|F....SHO|
|000049e0| 57 20 47 45 54 20 45 64 | 69 74 57 68 65 72 65 0d |W GET Ed|itWhere.|
|000049f0| 0a 0d 0a 52 45 54 55 52 | 4e 20 2e 54 2e 0d 0a    |...RETUR|N .T... |
+--------+-------------------------+-------------------------+--------+--------+