home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Database Designers / Erwin 3.0 / ERWIN / ERWTMPL.DLL < prev    next >
Microsoft Windows Dynamic Link Library  |  1993-04-30  |  154.5 KB
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text

This file was processed as: Microsoft Windows Dynamic Link Library (executable/dll).

ConfidenceProgramDetectionMatch TypeSupport
100% dexvert Microsoft Windows Dynamic Link Library (executable/dll) magic Supported
100% dexvert MS-DOS/Windows or OS/2 Executable (executable/exe) magic Supported
1% dexvert OS/2 Dynamic Link Library (other/os2DLL) ext Unsupported
100% file MS-DOS executable, NE for MS Windows 3.x (3.0) (DLL or font) default
99% file DIY-Thermocam raw data (Lepton 2.x), scale 28260-3338, spot sensor temperature 0.000000, unit celsius, color scheme 0, calibration: offset 128.000000, slope 817.145020 default (weak)
98% file data default
45% TrID Win16 NE executable (generic) default
18% TrID OS/2 Executable (generic) default
18% TrID Generic Win/DOS Executable default
18% TrID DOS Executable Generic default
0% TrID VXD Driver default (weak)
100% siegfried x-fmt/410 Windows New Executable default
100% gt2 Ist eine ausf�hrbare Win 3.x Datei default
100% xdgMime application/x-msdownload default (weak)


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4d 5a 2b 01 03 00 00 00 | 20 00 00 00 ff ff 07 00 |MZ+.....| .......|
|00000010| 00 01 65 40 00 00 00 00 | 40 00 00 00 01 00 00 00 |..e@....|@.......|
|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 04 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| e8 53 00 54 68 69 73 20 | 70 72 6f 67 72 61 6d 20 |.S.This |program |
|00000210| 72 65 71 75 69 72 65 73 | 20 4d 69 63 72 6f 73 6f |requires| Microso|
|00000220| 66 74 20 57 69 6e 64 6f | 77 73 2e 0d 0a 24 20 20 |ft Windo|ws...$  |
|00000230| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000250| 20 20 20 20 20 20 5a 0e | 1f b4 09 cd 21 b8 01 4c |      Z.|....!..L|
|00000260| cd 21 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.!......|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 4e 45 05 0e 47 09 46 00 | 4b c5 05 f2 01 83 02 00 |NE..G.F.|K.......|
|00000410| 00 04 00 00 22 01 01 00 | 00 00 00 00 02 00 01 00 |...."...|........|
|00000420| 6e 00 40 00 50 00 20 09 | 3d 09 3f 09 8d 0d 00 00 |n.@.P. .|=.?.....|
|00000430| 0b 00 04 00 00 00 02 08 | e2 00 90 00 00 00 00 03 |........|........|
|00000440| e4 00 52 06 50 1d 52 06 | 58 01 62 01 71 0c 62 01 |..R.P.R.|X.b.q.b.|
|00000450| 04 00 0a 80 bb 00 00 00 | 00 00 72 01 01 00 30 1c |........|..r...0.|
|00000460| 2c 81 00 00 00 00 73 01 | 22 00 30 1c 2d 81 00 00 |,.....s.|".0.-...|
|00000470| 00 00 95 01 32 00 30 1c | 2e 81 00 00 00 00 c7 01 |....2.0.|........|
|00000480| 1c 00 30 1c 2f 81 00 00 | 00 00 e3 01 1c 00 30 1c |..0./...|......0.|
|00000490| 30 81 00 00 00 00 ff 01 | 12 00 30 1c 31 81 00 00 |0.......|..0.1...|
|000004a0| 00 00 11 02 17 00 30 1c | 32 81 00 00 00 00 28 02 |......0.|2.....(.|
|000004b0| 31 00 30 1c 33 81 00 00 | 00 00 59 02 26 00 30 1c |1.0.3...|..Y.&.0.|
|000004c0| 34 81 00 00 00 00 7f 02 | 29 00 30 1c 35 81 00 00 |4.......|).0.5...|
|000004d0| 00 00 a8 02 31 00 30 1c | 36 81 00 00 00 00 d9 02 |....1.0.|6.......|
|000004e0| 26 00 30 1c 37 81 00 00 | 00 00 ff 02 29 00 30 1c |&.0.7...|....).0.|
|000004f0| 38 81 00 00 00 00 28 03 | 28 00 30 1c 39 81 00 00 |8.....(.|(.0.9...|
|00000500| 00 00 50 03 1f 00 30 1c | 3a 81 00 00 00 00 6f 03 |..P...0.|:.....o.|
|00000510| 21 00 30 1c 3b 81 00 00 | 00 00 90 03 17 00 30 1c |!.0.;...|......0.|
|00000520| 3c 81 00 00 00 00 a7 03 | 09 00 30 1c 3d 81 00 00 |<.......|..0.=...|
|00000530| 00 00 b0 03 0e 00 30 1c | 3e 81 00 00 00 00 be 03 |......0.|>.......|
|00000540| 09 00 30 1c 3f 81 00 00 | 00 00 c7 03 15 00 30 1c |..0.?...|......0.|
|00000550| 40 81 00 00 00 00 dc 03 | 09 00 30 1c 41 81 00 00 |@.......|..0.A...|
|00000560| 00 00 e5 03 06 00 30 1c | 42 81 00 00 00 00 eb 03 |......0.|B.......|
|00000570| 02 00 30 1c 43 81 00 00 | 00 00 ed 03 25 00 30 1c |..0.C...|....%.0.|
|00000580| 44 81 00 00 00 00 12 04 | 0b 00 30 1c 45 81 00 00 |D.......|..0.E...|
|00000590| 00 00 1d 04 0b 00 30 1c | 46 81 00 00 00 00 28 04 |......0.|F.....(.|
|000005a0| 0b 00 30 1c 47 81 00 00 | 00 00 33 04 0b 00 30 1c |..0.G...|..3...0.|
|000005b0| 48 81 00 00 00 00 3e 04 | 0b 00 30 1c 49 81 00 00 |H.....>.|..0.I...|
|000005c0| 00 00 49 04 0b 00 30 1c | 4a 81 00 00 00 00 54 04 |..I...0.|J.....T.|
|000005d0| 0b 00 30 1c 4b 81 00 00 | 00 00 5f 04 0b 00 30 1c |..0.K...|.._...0.|
|000005e0| 4c 81 00 00 00 00 6a 04 | 0b 00 30 1c 4d 81 00 00 |L.....j.|..0.M...|
|000005f0| 00 00 75 04 b9 01 30 1c | 4f 81 00 00 00 00 2e 06 |..u...0.|O.......|
|00000600| d0 01 30 1c 50 81 00 00 | 00 00 fe 07 56 01 30 1c |..0.P...|....V.0.|
|00000610| 51 81 00 00 00 00 54 09 | 01 00 30 1c 78 85 00 00 |Q.....T.|..0.x...|
|00000620| 00 00 55 09 14 00 30 1c | 79 85 00 00 00 00 69 09 |..U...0.|y.....i.|
|00000630| 1e 00 30 1c 7a 85 00 00 | 00 00 87 09 1b 00 30 1c |..0.z...|......0.|
|00000640| 7b 85 00 00 00 00 a2 09 | 14 00 30 1c 7c 85 00 00 |{.......|..0.|...|
|00000650| 00 00 b6 09 12 00 30 1c | 7d 85 00 00 00 00 c8 09 |......0.|}.......|
|00000660| 16 00 30 1c 7e 85 00 00 | 00 00 de 09 1c 00 30 1c |..0.~...|......0.|
|00000670| 7f 85 00 00 00 00 fa 09 | 23 00 30 1c 80 85 00 00 |........|#.0.....|
|00000680| 00 00 1d 0a 1c 00 30 1c | 81 85 00 00 00 00 39 0a |......0.|......9.|
|00000690| 1a 00 30 1c 82 85 00 00 | 00 00 53 0a 29 00 30 1c |..0.....|..S.).0.|
|000006a0| 83 85 00 00 00 00 7c 0a | 29 00 30 1c 84 85 00 00 |......|.|).0.....|
|000006b0| 00 00 a5 0a 14 00 30 1c | 85 85 00 00 00 00 b9 0a |......0.|........|
|000006c0| 12 00 30 1c 86 85 00 00 | 00 00 cb 0a 15 00 30 1c |..0.....|......0.|
|000006d0| 87 85 00 00 00 00 e0 0a | 09 00 30 1c 88 85 00 00 |........|..0.....|
|000006e0| 00 00 e9 0a 02 00 30 1c | 89 85 00 00 00 00 eb 0a |......0.|........|
|000006f0| 0a 00 30 1c 8a 85 00 00 | 00 00 f5 0a 02 00 30 1c |..0.....|......0.|
|00000700| 8b 85 00 00 00 00 f7 0a | 09 00 30 1c 8c 85 00 00 |........|..0.....|
|00000710| 00 00 00 0b 02 00 30 1c | 8d 85 00 00 00 00 02 0b |......0.|........|
|00000720| 07 00 30 1c 8e 85 00 00 | 00 00 09 0b 02 00 30 1c |..0.....|......0.|
|00000730| 8f 85 00 00 00 00 0b 0b | 11 00 30 1c 90 85 00 00 |........|..0.....|
|00000740| 00 00 1c 0b 0b 00 30 1c | 91 85 00 00 00 00 27 0b |......0.|......'.|
|00000750| 0b 00 30 1c 92 85 00 00 | 00 00 32 0b 0b 00 30 1c |..0.....|..2...0.|
|00000760| 93 85 00 00 00 00 3d 0b | 0b 00 30 1c 94 85 00 00 |......=.|..0.....|
|00000770| 00 00 48 0b 0b 00 30 1c | 95 85 00 00 00 00 53 0b |..H...0.|......S.|
|00000780| 0b 00 30 1c 96 85 00 00 | 00 00 5e 0b 0a 00 30 1c |..0.....|..^...0.|
|00000790| 97 85 00 00 00 00 68 0b | 0b 00 30 1c 98 85 00 00 |......h.|..0.....|
|000007a0| 00 00 73 0b 0a 00 30 1c | 99 85 00 00 00 00 7d 0b |..s...0.|......}.|
|000007b0| b5 01 30 1c 9b 85 00 00 | 00 00 32 0d bb 01 30 1c |..0.....|..2...0.|
|000007c0| 9c 85 00 00 00 00 ed 0e | 56 01 30 1c 9d 85 00 00 |........|V.0.....|
|000007d0| 00 00 43 10 01 00 30 1c | 58 82 00 00 00 00 44 10 |..C...0.|X.....D.|
|000007e0| 1b 00 30 1c 59 82 00 00 | 00 00 5f 10 1d 00 30 1c |..0.Y...|.._...0.|
|000007f0| 5a 82 00 00 00 00 7c 10 | 1c 00 30 1c 5b 82 00 00 |Z.....|.|..0.[...|
|00000800| 00 00 98 10 1b 00 30 1c | 5c 82 00 00 00 00 b3 10 |......0.|\.......|
|00000810| 11 00 30 1c 5d 82 00 00 | 00 00 c4 10 15 00 30 1c |..0.]...|......0.|
|00000820| 5e 82 00 00 00 00 d9 10 | 23 00 30 1c 5f 82 00 00 |^.......|#.0._...|
|00000830| 00 00 fc 10 29 00 30 1c | 60 82 00 00 00 00 25 11 |....).0.|`.....%.|
|00000840| 22 00 30 1c 61 82 00 00 | 00 00 47 11 23 00 30 1c |".0.a...|..G.#.0.|
|00000850| 62 82 00 00 00 00 6a 11 | 29 00 30 1c 63 82 00 00 |b.....j.|).0.c...|
|00000860| 00 00 93 11 22 00 30 1c | 64 82 00 00 00 00 b5 11 |....".0.|d.......|
|00000870| 27 00 30 1c 65 82 00 00 | 00 00 dc 11 1d 00 30 1c |'.0.e...|......0.|
|00000880| 66 82 00 00 00 00 f9 11 | 1c 00 30 1c 67 82 00 00 |f.......|..0.g...|
|00000890| 00 00 15 12 0b 00 30 1c | 68 82 00 00 00 00 20 12 |......0.|h..... .|
|000008a0| 0f 00 30 1c 69 82 00 00 | 00 00 2f 12 0b 00 30 1c |..0.i...|../...0.|
|000008b0| 6a 82 00 00 00 00 3a 12 | 0f 00 30 1c 6b 82 00 00 |j.....:.|..0.k...|
|000008c0| 00 00 49 12 0b 00 30 1c | 6c 82 00 00 00 00 54 12 |..I...0.|l.....T.|
|000008d0| 0f 00 30 1c 6d 82 00 00 | 00 00 63 12 07 00 30 1c |..0.m...|..c...0.|
|000008e0| 6e 82 00 00 00 00 6a 12 | 02 00 30 1c 6f 82 00 00 |n.....j.|..0.o...|
|000008f0| 00 00 6c 12 24 00 30 1c | 70 82 00 00 00 00 90 12 |..l.$.0.|p.......|
|00000900| 0b 00 30 1c 71 82 00 00 | 00 00 9b 12 0b 00 30 1c |..0.q...|......0.|
|00000910| 72 82 00 00 00 00 a6 12 | 0b 00 30 1c 73 82 00 00 |r.......|..0.s...|
|00000920| 00 00 b1 12 0b 00 30 1c | 74 82 00 00 00 00 bc 12 |......0.|t.......|
|00000930| 0b 00 30 1c 75 82 00 00 | 00 00 c7 12 0b 00 30 1c |..0.u...|......0.|
|00000940| 76 82 00 00 00 00 d2 12 | 0b 00 30 1c 77 82 00 00 |v.......|..0.w...|
|00000950| 00 00 dd 12 0b 00 30 1c | 78 82 00 00 00 00 e8 12 |......0.|x.......|
|00000960| 0b 00 30 1c 79 82 00 00 | 00 00 f3 12 ad 01 30 1c |..0.y...|......0.|
|00000970| 7b 82 00 00 00 00 a0 14 | d8 01 30 1c 7c 82 00 00 |{.......|..0.|...|
|00000980| 00 00 78 16 56 01 30 1c | 7d 82 00 00 00 00 ce 17 |..x.V.0.|}.......|
|00000990| 01 00 30 1c f4 81 00 00 | 00 00 cf 17 1d 00 30 1c |..0.....|......0.|
|000009a0| f5 81 00 00 00 00 ec 17 | 1e 00 30 1c f6 81 00 00 |........|..0.....|
|000009b0| 00 00 0a 18 19 00 30 1c | f7 81 00 00 00 00 23 18 |......0.|......#.|
|000009c0| 1d 00 30 1c f8 81 00 00 | 00 00 40 18 11 00 30 1c |..0.....|..@...0.|
|000009d0| f9 81 00 00 00 00 51 18 | 15 00 30 1c fa 81 00 00 |......Q.|..0.....|
|000009e0| 00 00 66 18 24 00 30 1c | fb 81 00 00 00 00 8a 18 |..f.$.0.|........|
|000009f0| 22 00 30 1c fc 81 00 00 | 00 00 ac 18 21 00 30 1c |".0.....|....!.0.|
|00000a00| fd 81 00 00 00 00 cd 18 | 24 00 30 1c fe 81 00 00 |........|$.0.....|
|00000a10| 00 00 f1 18 22 00 30 1c | ff 81 00 00 00 00 13 19 |....".0.|........|
|00000a20| 21 00 30 1c 00 82 00 00 | 00 00 34 19 1c 00 30 1c |!.0.....|..4...0.|
|00000a30| 01 82 00 00 00 00 50 19 | 11 00 30 1c 02 82 00 00 |......P.|..0.....|
|00000a40| 00 00 61 19 1c 00 30 1c | 03 82 00 00 00 00 7d 19 |..a...0.|......}.|
|00000a50| 0c 00 30 1c 04 82 00 00 | 00 00 89 19 04 00 30 1c |..0.....|......0.|
|00000a60| 05 82 00 00 00 00 8d 19 | 0c 00 30 1c 06 82 00 00 |........|..0.....|
|00000a70| 00 00 99 19 04 00 30 1c | 07 82 00 00 00 00 9d 19 |......0.|........|
|00000a80| 0c 00 30 1c 08 82 00 00 | 00 00 a9 19 04 00 30 1c |..0.....|......0.|
|00000a90| 09 82 00 00 00 00 ad 19 | 08 00 30 1c 0a 82 00 00 |........|..0.....|
|00000aa0| 00 00 b5 19 02 00 30 1c | 0b 82 00 00 00 00 b7 19 |......0.|........|
|00000ab0| 14 00 30 1c 0c 82 00 00 | 00 00 cb 19 0b 00 30 1c |..0.....|......0.|
|00000ac0| 0d 82 00 00 00 00 d6 19 | 0b 00 30 1c 0e 82 00 00 |........|..0.....|
|00000ad0| 00 00 e1 19 0b 00 30 1c | 0f 82 00 00 00 00 ec 19 |......0.|........|
|00000ae0| 0b 00 30 1c 10 82 00 00 | 00 00 f7 19 0b 00 30 1c |..0.....|......0.|
|00000af0| 11 82 00 00 00 00 02 1a | 0b 00 30 1c 12 82 00 00 |........|..0.....|
|00000b00| 00 00 0d 1a 0b 00 30 1c | 13 82 00 00 00 00 18 1a |......0.|........|
|00000b10| 0b 00 30 1c 14 82 00 00 | 00 00 23 1a 0b 00 30 1c |..0.....|..#...0.|
|00000b20| 15 82 00 00 00 00 2e 1a | c9 01 30 1c 17 82 00 00 |........|..0.....|
|00000b30| 00 00 f7 1b e9 01 30 1c | 18 82 00 00 00 00 e0 1d |......0.|........|
|00000b40| 56 01 30 1c 19 82 00 00 | 00 00 36 1f 01 00 30 1c |V.0.....|..6...0.|
|00000b50| e8 83 00 00 00 00 37 1f | 1b 00 30 1c e9 83 00 00 |......7.|..0.....|
|00000b60| 00 00 52 1f 1f 00 30 1c | ea 83 00 00 00 00 71 1f |..R...0.|......q.|
|00000b70| 1c 00 30 1c eb 83 00 00 | 00 00 8d 1f 1b 00 30 1c |..0.....|......0.|
|00000b80| ec 83 00 00 00 00 a8 1f | 11 00 30 1c ed 83 00 00 |........|..0.....|
|00000b90| 00 00 b9 1f 15 00 30 1c | ee 83 00 00 00 00 ce 1f |......0.|........|
|00000ba0| 24 00 30 1c ef 83 00 00 | 00 00 f2 1f 23 00 30 1c |$.0.....|....#.0.|
|00000bb0| f0 83 00 00 00 00 15 20 | 22 00 30 1c f1 83 00 00 |....... |".0.....|
|00000bc0| 00 00 37 20 24 00 30 1c | f2 83 00 00 00 00 5b 20 |..7 $.0.|......[ |
|00000bd0| 2c 00 30 1c f3 83 00 00 | 00 00 87 20 2b 00 30 1c |,.0.....|... +.0.|
|00000be0| f4 83 00 00 00 00 b2 20 | 1b 00 30 1c f5 83 00 00 |....... |..0.....|
|00000bf0| 00 00 cd 20 11 00 30 1c | f6 83 00 00 00 00 de 20 |... ..0.|....... |
|00000c00| 1c 00 30 1c f7 83 00 00 | 00 00 fa 20 0d 00 30 1c |..0.....|... ..0.|
|00000c10| f8 83 00 00 00 00 07 21 | 02 00 30 1c f9 83 00 00 |.......!|..0.....|
|00000c20| 00 00 09 21 0c 00 30 1c | fa 83 00 00 00 00 15 21 |...!..0.|.......!|
|00000c30| 02 00 30 1c fb 83 00 00 | 00 00 17 21 0c 00 30 1c |..0.....|...!..0.|
|00000c40| fc 83 00 00 00 00 23 21 | 02 00 30 1c fd 83 00 00 |......#!|..0.....|
|00000c50| 00 00 25 21 07 00 30 1c | fe 83 00 00 00 00 2c 21 |..%!..0.|......,!|
|00000c60| 02 00 30 1c ff 83 00 00 | 00 00 2e 21 10 00 30 1c |..0.....|...!..0.|
|00000c70| 00 84 00 00 00 00 3e 21 | 0b 00 30 1c 01 84 00 00 |......>!|..0.....|
|00000c80| 00 00 49 21 0b 00 30 1c | 02 84 00 00 00 00 54 21 |..I!..0.|......T!|
|00000c90| 0b 00 30 1c 03 84 00 00 | 00 00 5f 21 0b 00 30 1c |..0.....|.._!..0.|
|00000ca0| 04 84 00 00 00 00 6a 21 | 0b 00 30 1c 05 84 00 00 |......j!|..0.....|
|00000cb0| 00 00 75 21 0b 00 30 1c | 06 84 00 00 00 00 80 21 |..u!..0.|.......!|
|00000cc0| 0a 00 30 1c 07 84 00 00 | 00 00 8a 21 0b 00 30 1c |..0.....|...!..0.|
|00000cd0| 08 84 00 00 00 00 95 21 | 0a 00 30 1c 09 84 00 00 |.......!|..0.....|
|00000ce0| 00 00 9f 21 c1 01 30 1c | 0b 84 00 00 00 00 60 23 |...!..0.|......`#|
|00000cf0| c1 01 30 1c 0c 84 00 00 | 00 00 21 25 56 01 30 1c |..0.....|..!%V.0.|
|00000d00| 0d 84 00 00 00 00 77 26 | 15 00 30 1c d0 87 00 00 |......w&|..0.....|
|00000d10| 00 00 8c 26 14 00 30 1c | b8 8b 00 00 00 00 00 00 |...&..0.|........|
|00000d20| 07 45 52 57 54 4d 50 4c | 00 00 0f 5f 5f 5f 45 58 |.ERWTMPL|...___EX|
|00000d30| 50 4f 52 54 45 44 53 54 | 55 42 03 00 00 01 00 00 |PORTEDST|UB......|
|00000d40| 06 4b 45 52 4e 45 4c 0b | ff 03 cd 3f 01 52 00 03 |.KERNEL.|...?.R..|
|00000d50| cd 3f 01 34 00 03 cd 3f | 01 32 05 00 cd 3f 01 00 |.?.4...?|.2...?..|
|00000d60| 00 00 cd 3f 01 c4 01 00 | cd 3f 01 14 03 00 cd 3f |...?....|.?.....?|
|00000d70| 01 b2 00 00 cd 3f 01 3a | 06 00 cd 3f 01 1e 02 00 |.....?.:|...?....|
|00000d80| cd 3f 01 22 05 00 cd 3f | 01 48 05 00 00 41 4c 6f |.?."...?|.H...ALo|
|00000d90| 67 69 63 20 57 6f 72 6b | 73 20 44 44 4c 20 74 72 |gic Work|s DDL tr|
|00000da0| 69 67 67 65 72 20 74 65 | 6d 70 6c 61 74 65 73 2c |igger te|mplates,|
|00000db0| 20 43 6f 70 79 72 69 67 | 68 74 20 28 43 29 20 4c | Copyrig|ht (C) L|
|00000dc0| 6f 67 69 63 20 57 6f 72 | 6b 73 20 31 39 39 32 00 |ogic Wor|ks 1992.|
|00000dd0| 00 14 45 52 57 54 4d 50 | 4c 5f 4c 4f 41 44 54 45 |..ERWTMP|L_LOADTE|
|00000de0| 4d 50 4c 41 54 45 01 00 | 0f 45 52 57 54 4d 50 4c |MPLATE..|.ERWTMPL|
|00000df0| 5f 56 45 52 53 49 4f 4e | 02 00 00 00 00 00 00 00 |_VERSION|........|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 1e 58 90 45 55 8b ec 1e | 8e d8 81 ec 02 00 56 57 |.X.EU...|......VW|
|00000e50| 8b 46 0e a3 60 01 83 7e | 0a 00 76 07 6a ff 9a ff |.F..`..~|..v.j...|
|00000e60| ff 00 00 b8 01 00 5f 5e | 83 ed 02 8b e5 1f 5d 4d |......_^|......]M|
|00000e70| ca 0a 00 90 1e 58 90 45 | 55 8b ec 1e 8e d8 81 ec |.....X.E|U.......|
|00000e80| 02 00 56 57 b8 ae 00 5f | 5e 83 ed 02 8b e5 1f 5d |..VW..._|^......]|
|00000e90| 4d cb 1e 58 90 45 55 8b | ec 1e 8e d8 81 ec 04 00 |M..X.EU.|........|
|00000ea0| 56 57 ff 36 60 01 8b 46 | 06 33 d2 52 50 6a 00 6a |VW.6`..F|.3.RPj.j|
|00000eb0| 0a 9a ff ff 00 00 89 46 | fc 83 7e fc 00 74 11 ff |.......F|..~..t..|
|00000ec0| 36 60 01 ff 76 fc 9a ff | ff 00 00 eb 07 90 eb 04 |6`..v...|........|
|00000ed0| 33 c0 eb 00 5f 5e 83 ed | 02 8b e5 1f 5d 4d ca 02 |3..._^..|....]M..|
|00000ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 8c d8 90 45 55 8b | ec 1e 8e d8 ff 36 12 00 |.....EU.|.....6..|
|00000f00| ff 36 14 00 ff 36 16 00 | ff 36 1a 00 ff 36 18 00 |.6...6..|.6...6..|
|00000f10| 9a ff ff 00 00 83 ed 02 | 8b e5 1f 5d 4d cb ff ff |........|...]M...|
|00000f20| 50 53 51 52 06 b8 de 00 | 0b c0 79 12 07 5a 59 5b |PSQR....|..y..ZY[|
|00000f30| 58 9a fb ff 00 00 eb 04 | 90 33 c0 cb eb 24 90 90 |X.......|.3...$..|
|00000f40| eb 0e 57 9a ff ff 00 00 | 48 74 05 40 83 c4 0a cb |..W.....|Ht.@....|
|00000f50| 07 5a 59 5b 58 eb 0b 43 | 44 44 01 00 16 00 1e 00 |.ZY[X..C|DD......|
|00000f60| 42 00 8c d8 90 45 55 8b | ec 1e 8e d8 57 56 89 3e |B....EU.|....WV.>|
|00000f70| 12 00 8c 1e 14 00 89 0e | 16 00 89 1e 18 00 89 36 |........|.......6|
|00000f80| 1a 00 e3 0e 1e 33 c0 50 | 51 9a ff ff 00 00 0b c0 |.....3.P|Q.......|
|00000f90| 74 51 9a ff ff 00 00 a3 | 38 00 b4 30 2e f7 06 de |tQ......|8..0....|
|00000fa0| 00 01 00 74 07 9a ff ff | 00 00 eb 02 cd 21 a3 3a |...t....|.....!.:|
|00000fb0| 00 2e f7 06 de 00 01 00 | 75 05 b0 00 a2 3d 00 9a |........|u....=..|
|00000fc0| ff ff 00 00 9a ff ff 00 | 00 fe 06 1c 00 ff 36 5a |........|......6Z|
|00000fd0| 00 ff 36 58 00 ff 36 56 | 00 9a ff ff 00 00 83 c4 |..6X..6V|........|
|00000fe0| 06 5e 5f 83 ed 02 8b e5 | 1f 5d 4d cb 8c d8 90 45 |.^_.....|.]M....E|
|00000ff0| 55 8b ec 1e 8e d8 b8 01 | 00 83 ed 02 8b e5 1f 5d |U.......|.......]|
|00001000| 4d ca 0a 00 8c d8 90 45 | 55 8b ec 1e 8e d8 8b 0e |M......E|U.......|
|00001010| 6e 00 e3 14 33 f6 a1 70 | 00 8b 16 72 00 33 db ff |n...3..p|...r.3..|
|00001020| 1e 6c 00 73 03 e9 06 03 | be 78 00 bf 78 00 e8 9d |.l.s....|.x..x...|
|00001030| 00 be 78 00 bf 78 00 e8 | 94 00 be 78 00 bf 78 00 |..x..x..|...x..x.|
|00001040| e8 8b 00 be 78 00 bf 78 | 00 e8 82 00 be 78 00 bf |....x..x|.....x..|
|00001050| 78 00 e8 79 00 83 ed 02 | 8b e5 1f 5d 4d cb 8c d8 |x..y....|...]M...|
|00001060| 90 45 55 8b ec 1e 8e d8 | 56 57 b9 00 01 eb 0f 8c |.EU.....|VW......|
|00001070| d8 90 45 55 8b ec 1e 8e | d8 56 57 b9 01 01 88 2e |..EU....|.VW.....|
|00001080| 63 00 51 0a c9 75 12 be | 58 01 bf 58 01 e8 3e 00 |c.Q..u..|X..X..>.|
|00001090| be 78 00 bf 78 00 e8 35 | 00 be 78 00 bf 78 00 e8 |.x..x..5|..x..x..|
|000010a0| 2c 00 be 78 00 bf 78 00 | e8 23 00 e8 12 00 e8 d5 |,..x..x.|.#......|
|000010b0| 02 e8 d2 02 58 5f 5e 83 | ed 02 8b e5 1f 5d 4d cb |....X_^.|.....]M.|
|000010c0| 8b 0e 6e 00 e3 07 bb 02 | 00 ff 1e 6c 00 c3 3b f7 |..n.....|...l..;.|
|000010d0| 73 0e 83 ef 04 8b 05 0b | 45 02 74 f2 ff 1d eb ee |s.......|E.t.....|
|000010e0| c3 00 8c d8 90 45 55 8b | ec 1e 8e d8 b8 fc 00 50 |.....EU.|.......P|
|000010f0| 0e e8 49 00 b8 ff 00 50 | 0e e8 41 00 83 ed 02 8b |..I....P|..A.....|
|00001100| e5 1f 5d 4d cb 00 8c d8 | 90 45 55 8b ec 1e 8e d8 |..]M....|.EU.....|
|00001110| 56 57 1e 07 8b 56 06 be | 80 00 ad 3b c2 74 10 40 |VW...V..|...;.t.@|
|00001120| 96 74 0c 97 33 c0 b9 ff | ff f2 ae 8b f7 eb eb 96 |.t..3...|........|
|00001130| 5f 5e 83 ed 02 8b e5 1f | 5d 4d ca 02 00 8c d8 90 |_^......|]M......|
|00001140| 45 55 8b ec 1e 8e d8 57 | 5f 83 ed 02 8b e5 1f 5d |EU.....W|_......]|
|00001150| 4d ca 02 00 8c d8 90 45 | 55 8b ec 1e 8e d8 1e 9a |M......E|U.......|
|00001160| ff ff 00 00 0b c0 74 02 | 8b d0 8b da 8e c2 33 c0 |......t.|......3.|
|00001170| 33 f6 33 ff b9 ff ff 0b | db 74 0e 26 80 3e 00 00 |3.3.....|.t.&.>..|
|00001180| 00 74 06 f2 ae 46 ae 75 | fa 8b c7 40 24 fe 46 8b |.t...F.u|...@$.F.|
|00001190| fe d1 e6 b9 09 00 e8 9b | 01 50 8b c6 e8 95 01 a3 |........|.P......|
|000011a0| 5a 00 06 1e 07 1f 8b cf | 8b d8 33 f6 5f 49 e3 0d |Z.......|..3._I..|
|000011b0| 26 89 3f 43 43 ac aa 0a | c0 75 fa e2 f3 26 89 0f |&.?CC...|.u...&..|
|000011c0| 1f 83 ed 02 8b e5 1f 5d | 4d cb 9a ff ff 00 00 8e |.......]|M.......|
|000011d0| d8 b8 03 00 50 50 0e e8 | 08 ff 0e e8 5f ff 0e e8 |....PP..|...._...|
|000011e0| 24 ff 33 db 0b c0 74 1d | 8b f8 b8 09 00 80 3d 4d |$.3...t.|......=M|
|000011f0| 75 03 b8 0f 00 03 f8 57 | 1e 07 b0 0d b9 22 00 f2 |u......W|....."..|
|00001200| ae 88 5d ff 58 53 1e 50 | 9a ff ff 00 00 b8 ff 00 |..].XS.P|........|
|00001210| 50 9a ff ff 00 00 51 57 | f6 47 02 01 74 68 e8 ec |P.....QW|.G..th..|
|00001220| 00 8b fe 8b 04 a8 01 74 | 03 2b c8 49 41 41 8b 77 |.......t|.+.IAA.w|
|00001230| 04 0b f6 74 51 03 ce 73 | 09 33 c0 ba f0 ff e3 35 |...tQ..s|.3.....5|
|00001240| eb 44 9a 8b 03 00 00 8e | c0 26 a1 68 00 3d 00 10 |.D......|.&.h.=..|
|00001250| 74 16 ba 00 80 3b d0 72 | 06 d1 ea 75 f8 eb 22 83 |t....;.r|...u..".|
|00001260| fa 08 72 1d d1 e2 8b c2 | 48 8b d0 03 c1 73 02 33 |..r.....|H....s.3|
|00001270| c0 f7 d2 23 c2 52 e8 2e | 00 5a 73 0d 83 fa f0 74 |...#.R..|.Zs....t|
|00001280| 05 b8 10 00 eb e2 f9 eb | 1b 8b d0 2b 57 04 89 47 |........|...+W..G|
|00001290| 04 89 7f 0a 8b 77 0c 4a | 89 14 42 03 f2 c7 04 fe |.....w.J|..B.....|
|000012a0| ff 89 77 0c 5f 59 c3 8b | d0 f6 47 02 04 74 02 eb |..w._Y..|..G..t..|
|000012b0| 51 52 51 53 8b 77 06 2e | 8b 1e de 00 33 c9 0b d2 |QRQS.w..|....3...|
|000012c0| 75 07 f7 c3 10 00 75 40 | 41 b8 22 20 f7 c3 01 00 |u.....u@|A." ....|
|000012d0| 75 03 b8 20 20 56 51 52 | 50 9a ff ff 00 00 0b c0 |u..  VQR|P.......|
|000012e0| 74 26 3b c6 75 1c 56 9a | ff ff 00 00 0b d0 74 12 |t&;.u.V.|......t.|
|000012f0| 5b 59 5a 8b c2 f6 47 02 | 04 74 04 4a 89 57 fe f8 |[YZ...G.|.t.J.W..|
|00001300| eb 0a b8 12 00 e9 cc fe | 5b 59 5a f9 c3 57 8b 77 |........|[YZ..W.w|
|00001310| 0a 3b 77 0c 75 03 8b 77 | 08 ad 83 f8 fe 74 08 8b |.;w.u..w|.....t..|
|00001320| fe 24 fe 03 f0 eb f2 4f | 4f 8b f7 5f c3 00 b8 02 |.$.....O|O.._....|
|00001330| 00 e9 a0 fe 55 8b ec 53 | 06 51 b9 00 10 87 0e 68 |....U..S|.Q.....h|
|00001340| 00 51 50 9a ff ff 00 00 | 5b 8f 06 68 00 59 8c da |.QP.....|[..h.Y..|
|00001350| 0b c0 74 04 07 5b eb 05 | 8b c1 e9 77 fe 8b e5 5d |..t..[..|...w...]|
|00001360| c3 00 2e 80 3e 32 05 b8 | 74 03 8c d0 cb 2e a1 33 |....>2..|t......3|
|00001370| 05 cb 1e 58 90 45 55 8b | ec 1e 8e d8 33 c0 4d 4d |...X.EU.|....3.MM|
|00001380| 8b e5 1f 5d 4d cb c3 00 | 45 55 8b ec 83 ec 04 b8 |...]M...|EU......|
|00001390| ff ff 50 9a b7 05 00 00 | b8 20 00 50 83 7e 06 00 |..P.....|. .P.~..|
|000013a0| 74 06 8b 46 06 eb 04 90 | b8 01 00 50 9a ff ff 00 |t..F....|...P....|
|000013b0| 00 89 46 fe b8 ff ff 50 | 9a df 05 00 00 8b 46 fe |..F....P|......F.|
|000013c0| 8b e5 5d 4d cb 90 45 55 | 8b ec ff 76 06 9a ff ff |..]M..EU|...v....|
|000013d0| 00 00 8b e5 5d 4d cb 90 | 45 55 8b ec 83 ec 04 83 |....]M..|EU......|
|000013e0| 7e 06 00 75 0d ff 76 08 | 9a 04 05 00 00 83 c4 02 |~..u..v.|........|
|000013f0| eb 34 b8 ff ff 50 9a ff | ff 00 00 ff 76 06 83 7e |.4...P..|....v..~|
|00001400| 08 00 74 06 8b 46 08 eb | 04 90 b8 01 00 50 b8 62 |..t..F..|.....P.b|
|00001410| 00 50 9a ff ff 00 00 89 | 46 fe b8 ff ff 50 9a 1f |.P......|F....P..|
|00001420| 00 00 00 8b 46 fe 8b e5 | 5d 4d cb 90 45 55 8b ec |....F...|]M..EU..|
|00001430| ff 76 06 9a ff ff 00 00 | 8b e5 5d 4d cb 90 8c d8 |.v......|..]M....|
|00001440| 90 45 55 8b ec 1e 8e d8 | 8c d9 0f 02 c1 75 1d 0d |.EU.....|.....u..|
|00001450| 00 80 74 18 a0 1c 00 0a | c0 74 11 ff 76 06 9a ff |..t.....|.t..v...|
|00001460| ff 00 00 50 9a ff ff 00 | 00 58 eb 03 b8 01 00 83 |...P....|.X......|
|00001470| ed 02 8b e5 1f 5d 4d ca | 02 00 8c d8 90 45 55 8b |.....]M.|.....EU.|
|00001480| ec 1e 8e d8 b8 01 00 83 | ed 02 8b e5 1f 5d 4d ca |........|.....]M.|
|00001490| 02 00 1b 00 03 00 1f 06 | ff 00 08 00 03 00 25 06 |........|......%.|
|000014a0| ff 00 09 00 03 00 03 04 | ff 00 0a 00 03 00 a9 05 |........|........|
|000014b0| ff 00 0b 00 03 01 d2 03 | 01 00 01 00 03 01 53 01 |........|......S.|
|000014c0| 01 00 03 00 03 01 20 03 | 01 00 83 00 03 01 4a 01 |...... .|......J.|
|000014d0| 01 00 04 00 03 01 6d 05 | 01 00 05 00 03 01 d3 05 |......m.|........|
|000014e0| 01 00 06 00 03 01 8e 05 | 01 00 07 00 03 01 c9 03 |........|........|
|000014f0| 01 00 89 00 03 01 f4 05 | 01 00 0a 00 03 01 9a 04 |........|........|
|00001500| 01 00 10 00 03 01 a8 04 | 01 00 14 00 03 01 54 05 |........|......T.|
|00001510| 01 00 17 00 03 01 79 05 | 01 00 18 00 03 01 04 01 |......y.|........|
|00001520| 01 00 30 00 03 01 72 00 | 01 00 3c 00 03 01 87 00 |..0...r.|..<.....|
|00001530| 01 00 3d 00 05 01 e6 00 | 01 00 b2 00 03 05 f2 00 |..=.....|........|
|00001540| 01 00 5b 00 03 01 66 01 | 01 00 66 00 03 00 d1 00 |..[...f.|..f.....|
|00001550| ff 00 04 00 03 00 80 01 | ff 00 05 00 03 00 85 01 |........|........|
|00001560| ff 00 06 00 03 00 9a 01 | ff 00 07 00 00 00 00 00 |........|........|
|00001570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001580| 00 00 00 00 05 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001590| 00 01 00 00 00 00 00 00 | 00 00 00 00 00 01 00 ff |........|........|
|000015a0| ff 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 02 01 00 00 |........|........|
|000015c0| 14 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 60 00 00 00 |........|....`...|
|000015e0| 00 00 00 00 00 00 00 00 | 00 10 00 00 00 00 00 00 |........|........|
|000015f0| 00 00 00 00 00 00 00 00 | 3c 3c 4e 4d 53 47 3e 3e |........|<<NMSG>>|
|00001600| 00 00 52 36 30 30 30 0d | 0a 2d 20 73 74 61 63 6b |..R6000.|.- stack|
|00001610| 20 6f 76 65 72 66 6c 6f | 77 0d 0a 00 03 00 52 36 | overflo|w.....R6|
|00001620| 30 30 33 0d 0a 2d 20 69 | 6e 74 65 67 65 72 20 64 |003..- i|nteger d|
|00001630| 69 76 69 64 65 20 62 79 | 20 30 0d 0a 00 09 00 52 |ivide by| 0.....R|
|00001640| 36 30 30 39 0d 0a 2d 20 | 6e 6f 74 20 65 6e 6f 75 |6009..- |not enou|
|00001650| 67 68 20 73 70 61 63 65 | 20 66 6f 72 20 65 6e 76 |gh space| for env|
|00001660| 69 72 6f 6e 6d 65 6e 74 | 0d 0a 00 12 00 52 36 30 |ironment|.....R60|
|00001670| 31 38 0d 0a 2d 20 75 6e | 65 78 70 65 63 74 65 64 |18..- un|expected|
|00001680| 20 68 65 61 70 20 65 72 | 72 6f 72 0d 0a 00 fc 00 | heap er|ror.....|
|00001690| 0d 0a 00 ff 00 72 75 6e | 2d 74 69 6d 65 20 65 72 |.....run|-time er|
|000016a0| 72 6f 72 20 00 02 00 52 | 36 30 30 32 0d 0a 2d 20 |ror ...R|6002..- |
|000016b0| 66 6c 6f 61 74 69 6e 67 | 2d 70 6f 69 6e 74 20 73 |floating|-point s|
|000016c0| 75 70 70 6f 72 74 20 6e | 6f 74 20 6c 6f 61 64 65 |upport n|ot loade|
|000016d0| 64 0d 0a 00 ff ff ff 00 | 00 00 00 00 00 00 00 00 |d.......|........|
|000016e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001720| 4f 01 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |O.......|........|
|00001730| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 52 45 |PARENT U|PDATE RE|
|00001740| 53 54 52 49 43 54 00 20 | 20 2f 2a 20 45 52 77 69 |STRICT. | /* ERwi|
|00001750| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001760| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..|  /* %Pa|
|00001770| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00001780| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|00001790| 54 20 55 50 44 41 54 45 | 20 52 45 53 54 52 49 43 |T UPDATE| RESTRIC|
|000017a0| 54 20 2a 2f 0d 0a 20 20 | 69 66 0d 0a 20 20 20 20 |T */..  |if..    |
|000017b0| 2f 2a 20 25 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |/* %%Par|entPK(" |
|000017c0| 6f 72 22 2c 75 70 64 61 | 74 65 29 20 2a 2f 0d 0a |or",upda|te) */..|
|000017d0| 20 20 20 20 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |    %Par|entPK(" |
|000017e0| 6f 72 22 2c 75 70 64 61 | 74 65 29 0d 0a 20 20 62 |or",upda|te)..  b|
|000017f0| 65 67 69 6e 0d 0a 20 20 | 20 20 69 66 20 65 78 69 |egin..  |  if exi|
|00001800| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 73 65 6c |sts (.. |     sel|
|00001810| 65 63 74 20 2a 20 66 72 | 6f 6d 20 64 65 6c 65 74 |ect * fr|om delet|
|00001820| 65 64 2c 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |ed,%Chil|d..     |
|00001830| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00001840| 2f 2a 20 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 |/*  %%Jo|inFKPK(%|
|00001850| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00001860| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00001870| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |        |%JoinFKP|
|00001880| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00001890| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|000018a0| 20 20 20 20 29 0d 0a 20 | 20 20 20 62 65 67 69 6e |    ).. |   begin|
|000018b0| 0d 0a 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 40 |..      |select @|
|000018c0| 65 72 72 6e 6f 20 20 3d | 20 33 30 30 30 35 2c 0d |errno  =| 30005,.|
|000018d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|000018e0| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|000018f0| 55 50 44 41 54 45 20 22 | 25 50 61 72 65 6e 74 22 |UPDATE "|%Parent"|
|00001900| 20 62 65 63 61 75 73 65 | 20 22 25 43 68 69 6c 64 | because| "%Child|
|00001910| 22 20 65 78 69 73 74 73 | 2e 27 0d 0a 20 20 20 20 |" exists|.'..    |
|00001920| 20 20 67 6f 74 6f 20 65 | 72 72 6f 72 0d 0a 20 20 |  goto e|rror..  |
|00001930| 20 20 65 6e 64 0d 0a 20 | 20 65 6e 64 0d 0a 00 10 |  end.. | end....|
|00001940| 27 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |'.......|........|
|00001950| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 43 41 |PARENT U|PDATE CA|
|00001960| 53 43 41 44 45 00 20 20 | 2f 2a 20 45 52 77 69 6e |SCADE.  |/* ERwin|
|00001970| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00001980| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00001990| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|000019a0| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|000019b0| 20 55 50 44 41 54 45 20 | 43 41 53 43 41 44 45 20 | UPDATE |CASCADE |
|000019c0| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|000019d0| 20 25 25 50 61 72 65 6e | 74 50 4b 28 22 20 6f 72 | %%Paren|tPK(" or|
|000019e0| 22 2c 75 70 64 61 74 65 | 29 20 2a 2f 0d 0a 20 20 |",update|) */..  |
|000019f0| 20 20 25 50 61 72 65 6e | 74 50 4b 28 22 20 6f 72 |  %Paren|tPK(" or|
|00001a00| 22 2c 75 70 64 61 74 65 | 29 0d 0a 20 20 62 65 67 |",update|)..  beg|
|00001a10| 69 6e 0d 0a 20 20 20 20 | 69 66 20 40 6e 75 6d 72 |in..    |if @numr|
|00001a20| 6f 77 73 20 3d 20 31 0d | 0a 20 20 20 20 62 65 67 |ows = 1.|.    beg|
|00001a30| 69 6e 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |in..    |  select|
|00001a40| 20 25 4a 6f 69 6e 50 4b | 50 4b 28 40 69 6e 73 2c | %JoinPK|PK(@ins,|
|00001a50| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|00001a60| 2c 20 22 29 0d 0a 20 20 | 20 20 20 20 20 20 66 72 |, ")..  |      fr|
|00001a70| 6f 6d 20 69 6e 73 65 72 | 74 65 64 0d 0a 20 20 20 |om inser|ted..   |
|00001a80| 20 20 20 75 70 64 61 74 | 65 20 25 43 68 69 6c 64 |   updat|e %Child|
|00001a90| 0d 0a 20 20 20 20 20 20 | 73 65 74 0d 0a 20 20 20 |..      |set..   |
|00001aa0| 20 20 20 20 20 2f 2a 20 | 20 25 25 4a 6f 69 6e 46 |     /* | %%JoinF|
|00001ab0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 40 69 6e 73 2c |KPK(%Chi|ld,@ins,|
|00001ac0| 22 20 3d 20 22 2c 22 2c | 22 29 20 2a 2f 0d 0a 20 |" = ",",|") */.. |
|00001ad0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00001ae0| 28 25 43 68 69 6c 64 2c | 40 69 6e 73 2c 22 20 3d |(%Child,|@ins," =|
|00001af0| 20 22 2c 22 2c 22 29 0d | 0a 20 20 20 20 20 20 66 | ",",").|.      f|
|00001b00| 72 6f 6d 20 25 43 68 69 | 6c 64 2c 69 6e 73 65 72 |rom %Chi|ld,inser|
|00001b10| 74 65 64 2c 64 65 6c 65 | 74 65 64 0d 0a 20 20 20 |ted,dele|ted..   |
|00001b20| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|00001b30| 20 20 2f 2a 20 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |  /*  %%|JoinFKPK|
|00001b40| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00001b50| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00001b60| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00001b70| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |KPK(%Chi|ld,delet|
|00001b80| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|00001b90| 0d 0a 20 20 20 20 65 6e | 64 0d 0a 20 20 20 20 65 |..    en|d..    e|
|00001ba0| 6c 73 65 0d 0a 20 20 20 | 20 62 65 67 69 6e 0d 0a |lse..   | begin..|
|00001bb0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 40 65 72 |      se|lect @er|
|00001bc0| 72 6e 6f 20 3d 20 33 30 | 30 30 36 2c 0d 0a 20 20 |rno = 30|006,..  |
|00001bd0| 20 20 20 20 20 20 20 20 | 20 20 20 40 65 72 72 6d |        |   @errm|
|00001be0| 73 67 20 3d 20 27 43 61 | 6e 6e 6f 74 20 63 61 73 |sg = 'Ca|nnot cas|
|00001bf0| 63 61 64 65 20 22 25 50 | 61 72 65 6e 74 22 20 55 |cade "%P|arent" U|
|00001c00| 50 44 41 54 45 20 62 65 | 63 61 75 73 65 20 6d 6f |PDATE be|cause mo|
|00001c10| 72 65 20 74 68 61 6e 20 | 6f 6e 65 20 72 6f 77 20 |re than |one row |
|00001c20| 68 61 73 20 62 65 65 6e | 20 61 66 66 65 63 74 65 |has been| affecte|
|00001c30| 64 2e 27 0d 0a 20 20 20 | 20 20 20 72 61 69 73 65 |d.'..   |   raise|
|00001c40| 72 72 6f 72 20 40 65 72 | 72 6e 6f 20 40 65 72 72 |rror @er|rno @err|
|00001c50| 6d 73 67 0d 0a 20 20 20 | 20 65 6e 64 0d 0a 20 20 |msg..   | end..  |
|00001c60| 65 6e 64 0d 0a 00 11 27 | 00 00 00 00 00 00 00 00 |end....'|........|
|00001c70| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 53 45 |PARENT U|PDATE SE|
|00001c80| 54 20 4e 55 4c 4c 00 20 | 20 2f 2a 20 45 52 77 69 |T NULL. | /* ERwi|
|00001c90| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001ca0| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..|  /* %Pa|
|00001cb0| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00001cc0| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|00001cd0| 54 20 55 50 44 41 54 45 | 20 53 45 54 20 4e 55 4c |T UPDATE| SET NUL|
|00001ce0| 4c 20 2a 2f 0d 0a 20 20 | 69 66 0d 0a 20 20 20 20 |L */..  |if..    |
|00001cf0| 2f 2a 20 25 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |/* %%Par|entPK(" |
|00001d00| 6f 72 22 2c 75 70 64 61 | 74 65 29 20 2a 2f 0d 0a |or",upda|te) */..|
|00001d10| 20 20 20 20 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |    %Par|entPK(" |
|00001d20| 6f 72 22 2c 75 70 64 61 | 74 65 29 0d 0a 20 20 62 |or",upda|te)..  b|
|00001d30| 65 67 69 6e 0d 0a 20 20 | 20 20 75 70 64 61 74 65 |egin..  |  update|
|00001d40| 20 25 43 68 69 6c 64 0d | 0a 20 20 20 20 20 20 73 | %Child.|.      s|
|00001d50| 65 74 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |et..    |    /* %|
|00001d60| 25 53 65 74 46 4b 28 25 | 43 68 69 6c 64 2c 4e 55 |%SetFK(%|Child,NU|
|00001d70| 4c 4c 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |LL) */..|        |
|00001d80| 25 53 65 74 46 4b 28 25 | 43 68 69 6c 64 2c 4e 55 |%SetFK(%|Child,NU|
|00001d90| 4c 4c 29 0d 0a 20 20 20 | 20 20 20 66 72 6f 6d 20 |LL)..   |   from |
|00001da0| 25 43 68 69 6c 64 2c 64 | 65 6c 65 74 65 64 0d 0a |%Child,d|eleted..|
|00001db0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|00001dc0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b |     /* |%%JoinFK|
|00001dd0| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00001de0| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |d," = ",|" and") |
|00001df0| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |*/..    |    %Joi|
|00001e00| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 64 65 6c |nFKPK(%C|hild,del|
|00001e10| 65 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |eted," =| "," and|
|00001e20| 22 29 0d 0a 20 20 65 6e | 64 0d 0a 00 12 27 00 00 |")..  en|d....'..|
|00001e30| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 52 45 |PARENT D|ELETE RE|
|00001e40| 53 54 52 49 43 54 00 20 | 20 20 20 2f 2a 20 45 52 |STRICT. |   /* ER|
|00001e50| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00001e60| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 20 20 2f 2a |etime */|..    /*|
|00001e70| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00001e80| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00001e90| 41 52 45 4e 54 20 44 45 | 4c 45 54 45 20 52 45 53 |ARENT DE|LETE RES|
|00001ea0| 54 52 49 43 54 20 2a 2f | 0d 0a 20 20 20 20 69 66 |TRICT */|..    if|
|00001eb0| 20 65 78 69 73 74 73 20 | 28 0d 0a 20 20 20 20 20 | exists |(..     |
|00001ec0| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 64 | select |* from d|
|00001ed0| 65 6c 65 74 65 64 2c 25 | 43 68 69 6c 64 0d 0a 20 |eleted,%|Child.. |
|00001ee0| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 |     whe|re..    |
|00001ef0| 20 20 20 20 2f 2a 20 20 | 25 25 4a 6f 69 6e 46 4b |    /*  |%%JoinFK|
|00001f00| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00001f10| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |d," = ",|" and") |
|00001f20| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |*/..    |    %Joi|
|00001f30| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 64 65 6c |nFKPK(%C|hild,del|
|00001f40| 65 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |eted," =| "," and|
|00001f50| 22 29 0d 0a 20 20 20 20 | 29 0d 0a 20 20 20 20 62 |")..    |)..    b|
|00001f60| 65 67 69 6e 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |egin..  |    sele|
|00001f70| 63 74 20 40 65 72 72 6e | 6f 20 20 3d 20 33 30 30 |ct @errn|o  = 300|
|00001f80| 30 31 2c 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |01,..   |        |
|00001f90| 20 20 40 65 72 72 6d 73 | 67 20 3d 20 27 43 61 6e |  @errms|g = 'Can|
|00001fa0| 6e 6f 74 20 44 45 4c 45 | 54 45 20 22 25 50 61 72 |not DELE|TE "%Par|
|00001fb0| 65 6e 74 22 20 62 65 63 | 61 75 73 65 20 22 25 43 |ent" bec|ause "%C|
|00001fc0| 68 69 6c 64 22 20 65 78 | 69 73 74 73 2e 27 0d 0a |hild" ex|ists.'..|
|00001fd0| 20 20 20 20 20 20 67 6f | 74 6f 20 65 72 72 6f 72 |      go|to error|
|00001fe0| 0d 0a 20 20 20 20 65 6e | 64 0d 0a 00 14 27 00 00 |..    en|d....'..|
|00001ff0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 43 41 |PARENT D|ELETE CA|
|00002000| 53 43 41 44 45 00 20 20 | 20 20 2f 2a 20 45 52 77 |SCADE.  |  /* ERw|
|00002010| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00002020| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|.    /* |
|00002030| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00002040| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|00002050| 52 45 4e 54 20 44 45 4c | 45 54 45 20 43 41 53 43 |RENT DEL|ETE CASC|
|00002060| 41 44 45 20 2a 2f 0d 0a | 20 20 20 20 64 65 6c 65 |ADE */..|    dele|
|00002070| 74 65 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |te %Chil|d..     |
|00002080| 20 66 72 6f 6d 20 25 43 | 68 69 6c 64 2c 64 65 6c | from %C|hild,del|
|00002090| 65 74 65 64 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |eted..  |    wher|
|000020a0| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 20 25 |e..     |   /*  %|
|000020b0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|000020c0| 2c 64 65 6c 65 74 65 64 | 2c 22 20 3d 20 22 2c 22 |,deleted|," = ","|
|000020d0| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|000020e0| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 25 43 68 |   %Join|FKPK(%Ch|
|000020f0| 69 6c 64 2c 64 65 6c 65 | 74 65 64 2c 22 20 3d 20 |ild,dele|ted," = |
|00002100| 22 2c 22 20 61 6e 64 22 | 29 0d 0a 00 15 27 00 00 |"," and"|)....'..|
|00002110| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 53 45 |PARENT D|ELETE SE|
|00002120| 54 20 4e 55 4c 4c 00 20 | 20 20 20 2f 2a 20 45 52 |T NULL. |   /* ER|
|00002130| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00002140| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 20 20 2f 2a |etime */|..    /*|
|00002150| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00002160| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00002170| 41 52 45 4e 54 20 44 45 | 4c 45 54 45 20 53 45 54 |ARENT DE|LETE SET|
|00002180| 20 4e 55 4c 4c 20 2a 2f | 0d 0a 20 20 20 20 75 70 | NULL */|..    up|
|00002190| 64 61 74 65 20 25 43 68 | 69 6c 64 0d 0a 20 20 20 |date %Ch|ild..   |
|000021a0| 20 20 20 73 65 74 0d 0a | 20 20 20 20 20 20 20 20 |   set..|        |
|000021b0| 2f 2a 20 25 25 53 65 74 | 46 4b 28 25 43 68 69 6c |/* %%Set|FK(%Chil|
|000021c0| 64 2c 4e 55 4c 4c 29 20 | 2a 2f 0d 0a 20 20 20 20 |d,NULL) |*/..    |
|000021d0| 20 20 20 20 25 53 65 74 | 46 4b 28 25 43 68 69 6c |    %Set|FK(%Chil|
|000021e0| 64 2c 4e 55 4c 4c 29 0d | 0a 20 20 20 20 20 20 66 |d,NULL).|.      f|
|000021f0| 72 6f 6d 20 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |rom %Chi|ld,delet|
|00002200| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 0d |ed..    |  where.|
|00002210| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4a 6f |.       | /* %%Jo|
|00002220| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 64 65 |inFKPK(%|Child,de|
|00002230| 6c 65 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |leted," |= "," an|
|00002240| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..|        |
|00002250| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00002260| 2c 64 65 6c 65 74 65 64 | 2c 22 20 3d 20 22 2c 22 |,deleted|," = ","|
|00002270| 20 61 6e 64 22 29 0d 0a | 00 16 27 00 00 00 00 00 | and")..|..'.....|
|00002280| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 52 45 53 |CHILD IN|SERT RES|
|00002290| 54 52 49 43 54 00 20 20 | 2f 2a 20 45 52 77 69 6e |TRICT.  |/* ERwin|
|000022a0| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|000022b0| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|000022c0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|000022d0| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|000022e0| 49 4e 53 45 52 54 20 52 | 45 53 54 52 49 43 54 20 |INSERT R|ESTRICT |
|000022f0| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|00002300| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|00002310| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */..   |
|00002320| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|00002330| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|.  begin|
|00002340| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |..    se|lect @nu|
|00002350| 6c 6c 63 6e 74 20 3d 20 | 30 0d 0a 20 20 20 20 73 |llcnt = |0..    s|
|00002360| 65 6c 65 63 74 20 40 76 | 61 6c 69 64 63 6e 74 20 |elect @v|alidcnt |
|00002370| 3d 20 63 6f 75 6e 74 28 | 2a 29 0d 0a 20 20 20 20 |= count(|*)..    |
|00002380| 20 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 2c |  from i|nserted,|
|00002390| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|.       |
|000023a0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|000023b0| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|000023c0| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|000023d0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|000023e0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|000023f0| 65 64 2c 25 50 61 72 65 | 6e 74 29 0d 0a 20 20 20 |ed,%Pare|nt)..   |
|00002400| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|00002410| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|00002420| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|00002430| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|00002440| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|00002450| 65 72 65 22 2c 22 20 6f | 72 22 29 20 2a 2f 0d 0a |ere"," o|r") */..|
|00002460| 20 20 20 20 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 |    %Not|nullFK(i|
|00002470| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 75 6c |nserted,|" is nul|
|00002480| 6c 22 2c 22 73 65 6c 65 | 63 74 20 40 6e 75 6c 6c |l","sele|ct @null|
|00002490| 63 6e 74 20 3d 20 63 6f | 75 6e 74 28 2a 29 20 66 |cnt = co|unt(*) f|
|000024a0| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 20 77 68 65 |rom inse|rted whe|
|000024b0| 72 65 22 2c 22 20 6f 72 | 22 29 0d 0a 20 20 20 20 |re"," or|")..    |
|000024c0| 69 66 20 40 76 61 6c 69 | 64 63 6e 74 20 2b 20 40 |if @vali|dcnt + @|
|000024d0| 6e 75 6c 6c 63 6e 74 20 | 21 3d 20 40 6e 75 6d 72 |nullcnt |!= @numr|
|000024e0| 6f 77 73 0d 0a 20 20 20 | 20 62 65 67 69 6e 0d 0a |ows..   | begin..|
|000024f0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 40 65 72 |      se|lect @er|
|00002500| 72 6e 6f 20 20 3d 20 33 | 30 30 30 32 2c 0d 0a 20 |rno  = 3|0002,.. |
|00002510| 20 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |        |    @err|
|00002520| 6d 73 67 20 3d 20 27 43 | 61 6e 6e 6f 74 20 49 4e |msg = 'C|annot IN|
|00002530| 53 45 52 54 20 22 25 43 | 68 69 6c 64 22 20 62 65 |SERT "%C|hild" be|
|00002540| 63 61 75 73 65 20 22 25 | 50 61 72 65 6e 74 22 20 |cause "%|Parent" |
|00002550| 64 6f 65 73 20 6e 6f 74 | 20 65 78 69 73 74 2e 27 |does not| exist.'|
|00002560| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |..      |goto err|
|00002570| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 20 20 65 |or..    |end..  e|
|00002580| 6e 64 0d 0a 00 18 27 00 | 00 00 00 00 00 00 00 00 |nd....'.|........|
|00002590| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 43 41 53 |CHILD IN|SERT CAS|
|000025a0| 43 41 44 45 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |CADE.  /|* ERwin |
|000025b0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000025c0| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|000025d0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000025e0| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 49 |Child ON| CHILD I|
|000025f0| 4e 53 45 52 54 20 43 41 | 53 43 41 44 45 20 2a 2f |NSERT CA|SCADE */|
|00002600| 0d 0a 20 20 69 66 0d 0a | 20 20 20 20 2f 2a 20 25 |..  if..|    /* %|
|00002610| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00002620| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/..    %|
|00002630| 43 68 69 6c 64 46 4b 28 | 22 20 6f 72 22 2c 75 70 |ChildFK(|" or",up|
|00002640| 64 61 74 65 29 0d 0a 20 | 20 62 65 67 69 6e 0d 0a |date).. | begin..|
|00002650| 20 20 20 20 69 6e 73 65 | 72 74 20 25 50 61 72 65 |    inse|rt %Pare|
|00002660| 6e 74 20 28 25 50 61 72 | 65 6e 74 50 4b 28 22 2c |nt (%Par|entPK(",|
|00002670| 22 2c 29 29 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |",))..  |    sele|
|00002680| 63 74 20 25 43 68 69 6c | 64 46 4b 28 22 2c 22 2c |ct %Chil|dFK(",",|
|00002690| 29 0d 0a 20 20 20 20 20 | 20 66 72 6f 6d 20 20 20 |)..     | from   |
|000026a0| 69 6e 73 65 72 74 65 64 | 0d 0a 20 20 20 20 20 20 |inserted|..      |
|000026b0| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. |       /|
|000026c0| 2a 20 25 25 4e 6f 74 6e | 75 6c 6c 46 4b 28 69 6e |* %%Notn|ullFK(in|
|000026d0| 73 65 72 74 65 64 2c 22 | 20 69 73 20 6e 6f 74 20 |serted,"| is not |
|000026e0| 6e 75 6c 6c 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 |null and|") */.. |
|000026f0| 20 20 20 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 |       %|NotnullF|
|00002700| 4b 28 69 6e 73 65 72 74 | 65 64 2c 22 20 69 73 20 |K(insert|ed," is |
|00002710| 6e 6f 74 20 6e 75 6c 6c | 20 61 6e 64 22 29 0d 0a |not null| and")..|
|00002720| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|00002730| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|00002740| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 50 |select *| from %P|
|00002750| 61 72 65 6e 74 0d 0a 20 | 20 20 20 20 20 20 20 20 |arent.. |        |
|00002760| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00002770| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|00002780| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00002790| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|000027a0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 | */..   |        |
|000027b0| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 69 6e 73 65 72 | %JoinFK|PK(inser|
|000027c0| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|000027d0| 22 2c 22 20 61 6e 64 22 | 29 0d 0a 20 20 20 20 20 |"," and"|)..     |
|000027e0| 20 20 20 29 0d 0a 20 20 | 65 6e 64 0d 0a 00 19 27 |   )..  |end....'|
|000027f0| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00002800| 4e 55 4c 4c 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |NULL.  /|* ERwin |
|00002810| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002820| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00002830| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00002840| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 49 |Child ON| CHILD I|
|00002850| 4e 53 45 52 54 20 53 45 | 54 20 4e 55 4c 4c 20 2a |NSERT SE|T NULL *|
|00002860| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/..  if.|.    /* |
|00002870| 25 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c |%%ChildF|K(" or",|
|00002880| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/..    |
|00002890| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|000028a0| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..|  begin.|
|000028b0| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |.    upd|ate %Chi|
|000028c0| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld..    |  set.. |
|000028d0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 |       /|* %%SetF|
|000028e0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|000028f0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/..     |   %SetF|
|00002900| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00002910| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c |      fr|om %Chil|
|00002920| 64 2c 69 6e 73 65 72 74 | 65 64 0d 0a 20 20 20 20 |d,insert|ed..    |
|00002930| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|00002940| 20 2f 2a 20 25 25 4a 6f | 69 6e 50 4b 50 4b 28 25 | /* %%Jo|inPKPK(%|
|00002950| 43 68 69 6c 64 2c 69 6e | 73 65 72 74 65 64 2c 22 |Child,in|serted,"|
|00002960| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00002970| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 50 4b |.       | %JoinPK|
|00002980| 50 4b 28 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |PK(%Chil|d,insert|
|00002990| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|000029a0| 20 61 6e 64 0d 0a 20 20 | 20 20 20 20 20 20 6e 6f | and..  |      no|
|000029b0| 74 20 65 78 69 73 74 73 | 20 28 0d 0a 20 20 20 20 |t exists| (..    |
|000029c0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 2a 20 66 |      se|lect * f|
|000029d0| 72 6f 6d 20 25 50 61 72 | 65 6e 74 0d 0a 20 20 20 |rom %Par|ent..   |
|000029e0| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 |       w|here..  |
|000029f0| 20 20 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |        |  /* %%J|
|00002a00| 6f 69 6e 46 4b 50 4b 28 | 69 6e 73 65 72 74 65 64 |oinFKPK(|inserted|
|00002a10| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00002a20| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|00002a30| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00002a40| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00002a50| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|00002a60| 0a 20 20 20 20 20 20 20 | 20 29 0d 0a 20 20 65 6e |.       | )..  en|
|00002a70| 64 0d 0a 00 1a 27 00 00 | 00 00 00 00 00 00 00 00 |d....'..|........|
|00002a80| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00002a90| 54 52 49 43 54 00 20 20 | 2f 2a 20 45 52 77 69 6e |TRICT.  |/* ERwin|
|00002aa0| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00002ab0| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00002ac0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00002ad0| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00002ae0| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 20 |UPDATE R|ESTRICT |
|00002af0| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|00002b00| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|00002b10| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */..   |
|00002b20| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|00002b30| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|.  begin|
|00002b40| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |..    se|lect @nu|
|00002b50| 6c 6c 63 6e 74 20 3d 20 | 30 0d 0a 20 20 20 20 73 |llcnt = |0..    s|
|00002b60| 65 6c 65 63 74 20 40 76 | 61 6c 69 64 63 6e 74 20 |elect @v|alidcnt |
|00002b70| 3d 20 63 6f 75 6e 74 28 | 2a 29 0d 0a 20 20 20 20 |= count(|*)..    |
|00002b80| 20 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 2c |  from i|nserted,|
|00002b90| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|.       |
|00002ba0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00002bb0| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|00002bc0| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|00002bd0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|00002be0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00002bf0| 65 64 2c 25 50 61 72 65 | 6e 74 29 0d 0a 20 20 20 |ed,%Pare|nt)..   |
|00002c00| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|00002c10| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|00002c20| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|00002c30| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|00002c40| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|00002c50| 65 72 65 22 2c 22 20 6f | 72 22 29 20 2a 2f 0d 0a |ere"," o|r") */..|
|00002c60| 20 20 20 20 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 |    %Not|nullFK(i|
|00002c70| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 75 6c |nserted,|" is nul|
|00002c80| 6c 22 2c 22 73 65 6c 65 | 63 74 20 40 6e 75 6c 6c |l","sele|ct @null|
|00002c90| 63 6e 74 20 3d 20 63 6f | 75 6e 74 28 2a 29 20 66 |cnt = co|unt(*) f|
|00002ca0| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 20 77 68 65 |rom inse|rted whe|
|00002cb0| 72 65 22 2c 22 20 6f 72 | 22 29 0d 0a 20 20 20 20 |re"," or|")..    |
|00002cc0| 69 66 20 40 76 61 6c 69 | 64 63 6e 74 20 2b 20 40 |if @vali|dcnt + @|
|00002cd0| 6e 75 6c 6c 63 6e 74 20 | 21 3d 20 40 6e 75 6d 72 |nullcnt |!= @numr|
|00002ce0| 6f 77 73 0d 0a 20 20 20 | 20 62 65 67 69 6e 0d 0a |ows..   | begin..|
|00002cf0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 40 65 72 |      se|lect @er|
|00002d00| 72 6e 6f 20 20 3d 20 33 | 30 30 30 37 2c 0d 0a 20 |rno  = 3|0007,.. |
|00002d10| 20 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |        |    @err|
|00002d20| 6d 73 67 20 3d 20 27 43 | 61 6e 6e 6f 74 20 55 50 |msg = 'C|annot UP|
|00002d30| 44 41 54 45 20 22 25 43 | 68 69 6c 64 22 20 62 65 |DATE "%C|hild" be|
|00002d40| 63 61 75 73 65 20 22 25 | 50 61 72 65 6e 74 22 20 |cause "%|Parent" |
|00002d50| 64 6f 65 73 20 6e 6f 74 | 20 65 78 69 73 74 2e 27 |does not| exist.'|
|00002d60| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |..      |goto err|
|00002d70| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 20 20 65 |or..    |end..  e|
|00002d80| 6e 64 0d 0a 00 1c 27 00 | 00 00 00 00 00 00 00 00 |nd....'.|........|
|00002d90| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00002da0| 43 41 44 45 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |CADE.  /|* ERwin |
|00002db0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002dc0| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00002dd0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00002de0| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00002df0| 50 44 41 54 45 20 43 41 | 53 43 41 44 45 20 2a 2f |PDATE CA|SCADE */|
|00002e00| 0d 0a 20 20 69 66 0d 0a | 20 20 20 20 2f 2a 20 25 |..  if..|    /* %|
|00002e10| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00002e20| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/..    %|
|00002e30| 43 68 69 6c 64 46 4b 28 | 22 20 6f 72 22 2c 75 70 |ChildFK(|" or",up|
|00002e40| 64 61 74 65 29 0d 0a 20 | 20 62 65 67 69 6e 0d 0a |date).. | begin..|
|00002e50| 20 20 20 20 69 6e 73 65 | 72 74 20 25 50 61 72 65 |    inse|rt %Pare|
|00002e60| 6e 74 20 28 25 50 61 72 | 65 6e 74 50 4b 28 22 2c |nt (%Par|entPK(",|
|00002e70| 22 2c 29 29 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |",))..  |    sele|
|00002e80| 63 74 20 25 43 68 69 6c | 64 46 4b 28 22 2c 22 2c |ct %Chil|dFK(",",|
|00002e90| 29 0d 0a 20 20 20 20 20 | 20 66 72 6f 6d 20 20 20 |)..     | from   |
|00002ea0| 69 6e 73 65 72 74 65 64 | 0d 0a 20 20 20 20 20 20 |inserted|..      |
|00002eb0| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. |       /|
|00002ec0| 2a 20 25 25 4e 6f 74 6e | 75 6c 6c 46 4b 28 69 6e |* %%Notn|ullFK(in|
|00002ed0| 73 65 72 74 65 64 2c 22 | 20 69 73 20 6e 6f 74 20 |serted,"| is not |
|00002ee0| 6e 75 6c 6c 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 |null and|") */.. |
|00002ef0| 20 20 20 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 |       %|NotnullF|
|00002f00| 4b 28 69 6e 73 65 72 74 | 65 64 2c 22 20 69 73 20 |K(insert|ed," is |
|00002f10| 6e 6f 74 20 6e 75 6c 6c | 20 61 6e 64 22 29 0d 0a |not null| and")..|
|00002f20| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|00002f30| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|00002f40| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 50 |select *| from %P|
|00002f50| 61 72 65 6e 74 0d 0a 20 | 20 20 20 20 20 20 20 20 |arent.. |        |
|00002f60| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00002f70| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|00002f80| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00002f90| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00002fa0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 | */..   |        |
|00002fb0| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 69 6e 73 65 72 | %JoinFK|PK(inser|
|00002fc0| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|00002fd0| 22 2c 22 20 61 6e 64 22 | 29 0d 0a 20 20 20 20 20 |"," and"|)..     |
|00002fe0| 20 20 20 29 0d 0a 20 20 | 65 6e 64 0d 0a 00 1d 27 |   )..  |end....'|
|00002ff0| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|00003000| 4e 55 4c 4c 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |NULL.  /|* ERwin |
|00003010| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00003020| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00003030| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00003040| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00003050| 50 44 41 54 45 20 53 45 | 54 20 4e 55 4c 4c 20 2a |PDATE SE|T NULL *|
|00003060| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/..  if.|.    /* |
|00003070| 25 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c |%%ChildF|K(" or",|
|00003080| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/..    |
|00003090| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|000030a0| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..|  begin.|
|000030b0| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |.    upd|ate %Chi|
|000030c0| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld..    |  set.. |
|000030d0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 |       /|* %%SetF|
|000030e0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|000030f0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/..     |   %SetF|
|00003100| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00003110| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c |      fr|om %Chil|
|00003120| 64 2c 69 6e 73 65 72 74 | 65 64 0d 0a 20 20 20 20 |d,insert|ed..    |
|00003130| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 |  where.|.       |
|00003140| 20 2f 2a 20 25 25 4a 6f | 69 6e 50 4b 50 4b 28 25 | /* %%Jo|inPKPK(%|
|00003150| 43 68 69 6c 64 2c 69 6e | 73 65 72 74 65 64 2c 22 |Child,in|serted,"|
|00003160| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00003170| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 50 4b |.       | %JoinPK|
|00003180| 50 4b 28 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |PK(%Chil|d,insert|
|00003190| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|000031a0| 20 61 6e 64 20 0d 0a 20 | 20 20 20 20 20 20 20 6e | and .. |       n|
|000031b0| 6f 74 20 65 78 69 73 74 | 73 20 28 0d 0a 20 20 20 |ot exist|s (..   |
|000031c0| 20 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 2a 20 |       s|elect * |
|000031d0| 66 72 6f 6d 20 25 50 61 | 72 65 6e 74 0d 0a 20 20 |from %Pa|rent..  |
|000031e0| 20 20 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |        |where.. |
|000031f0| 20 20 20 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |        |   /* %%|
|00003200| 4a 6f 69 6e 46 4b 50 4b | 28 69 6e 73 65 72 74 65 |JoinFKPK|(inserte|
|00003210| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|00003220| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/..    |
|00003230| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |        |%JoinFKP|
|00003240| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00003250| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00003260| 0d 0a 20 20 20 20 20 20 | 20 20 29 0d 0a 20 20 65 |..      |  )..  e|
|00003270| 6e 64 0d 0a 00 1e 27 00 | 00 00 00 00 00 00 00 00 |nd....'.|........|
|00003280| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00003290| 54 52 49 43 54 00 20 20 | 20 20 2f 2a 20 45 52 77 |TRICT.  |  /* ERw|
|000032a0| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|000032b0| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|.    /* |
|000032c0| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000032d0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|000032e0| 49 4c 44 20 44 45 4c 45 | 54 45 20 52 45 53 54 52 |ILD DELE|TE RESTR|
|000032f0| 49 43 54 20 2a 2f 0d 0a | 20 20 20 20 69 66 20 65 |ICT */..|    if e|
|00003300| 78 69 73 74 73 20 28 73 | 65 6c 65 63 74 20 2a 20 |xists (s|elect * |
|00003310| 66 72 6f 6d 20 64 65 6c | 65 74 65 64 2c 25 50 61 |from del|eted,%Pa|
|00003320| 72 65 6e 74 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |rent..  |    wher|
|00003330| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |e..     |   /* %%|
|00003340| 4a 6f 69 6e 46 4b 50 4b | 28 64 65 6c 65 74 65 64 |JoinFKPK|(deleted|
|00003350| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00003360| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|00003370| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 64 65 6c |   %Join|FKPK(del|
|00003380| 65 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |eted,%Pa|rent," =|
|00003390| 20 22 2c 22 20 61 6e 64 | 22 29 20 61 6e 64 0d 0a | "," and|") and..|
|000033a0| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|000033b0| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|000033c0| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 43 |select *| from %C|
|000033d0| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |hild..  |        |
|000033e0| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|000033f0| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00003400| 28 25 43 68 69 6c 64 2c | 25 50 61 72 65 6e 74 2c |(%Child,|%Parent,|
|00003410| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00003420| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a |..      |      %J|
|00003430| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 25 |oinFKPK(|%Child,%|
|00003440| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00003450| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 20 20 29 0d |nd")..  |      ).|
|00003460| 0a 20 20 20 20 29 0d 0a | 20 20 20 20 62 65 67 69 |.    )..|    begi|
|00003470| 6e 0d 0a 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |n..     | select |
|00003480| 40 65 72 72 6e 6f 20 20 | 3d 20 33 30 30 31 30 2c |@errno  |= 30010,|
|00003490| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 40 |..      |       @|
|000034a0| 65 72 72 6d 73 67 20 3d | 20 27 43 61 6e 6e 6f 74 |errmsg =| 'Cannot|
|000034b0| 20 44 45 4c 45 54 45 20 | 6c 61 73 74 20 22 25 43 | DELETE |last "%C|
|000034c0| 68 69 6c 64 22 20 62 65 | 63 61 75 73 65 20 22 25 |hild" be|cause "%|
|000034d0| 50 61 72 65 6e 74 22 20 | 65 78 69 73 74 73 2e 27 |Parent" |exists.'|
|000034e0| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |..      |goto err|
|000034f0| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 00 20 27 |or..    |end... '|
|00003500| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 43 41 53 |CHILD DE|LETE CAS|
|00003510| 43 41 44 45 00 20 20 20 | 20 2f 2a 20 45 52 77 69 |CADE.   | /* ERwi|
|00003520| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00003530| 69 6d 65 20 2a 2f 0d 0a | 20 20 20 20 2f 2a 20 25 |ime */..|    /* %|
|00003540| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00003550| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 43 48 49 |se %Chil|d ON CHI|
|00003560| 4c 44 20 44 45 4c 45 54 | 45 20 43 41 53 43 41 44 |LD DELET|E CASCAD|
|00003570| 45 20 2a 2f 0d 0a 20 20 | 20 20 64 65 6c 65 74 65 |E */..  |  delete|
|00003580| 20 25 50 61 72 65 6e 74 | 0d 0a 20 20 20 20 20 20 | %Parent|..      |
|00003590| 66 72 6f 6d 20 25 50 61 | 72 65 6e 74 2c 64 65 6c |from %Pa|rent,del|
|000035a0| 65 74 65 64 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |eted..  |    wher|
|000035b0| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |e..     |   /* %%|
|000035c0| 4a 6f 69 6e 46 4b 50 4b | 28 64 65 6c 65 74 65 64 |JoinFKPK|(deleted|
|000035d0| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|000035e0| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|000035f0| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 64 65 6c |   %Join|FKPK(del|
|00003600| 65 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |eted,%Pa|rent," =|
|00003610| 20 22 2c 22 20 61 6e 64 | 22 29 20 61 6e 64 0d 0a | "," and|") and..|
|00003620| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|00003630| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|00003640| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 43 |select *| from %C|
|00003650| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |hild..  |        |
|00003660| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|00003670| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00003680| 28 25 43 68 69 6c 64 2c | 25 50 61 72 65 6e 74 2c |(%Child,|%Parent,|
|00003690| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|000036a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a |..      |      %J|
|000036b0| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 25 |oinFKPK(|%Child,%|
|000036c0| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|000036d0| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 20 20 29 0d |nd")..  |      ).|
|000036e0| 0a 00 21 27 00 00 00 00 | 00 00 00 00 00 00 00 00 |..!'....|........|
|000036f0| 50 41 52 45 4e 54 20 49 | 4e 53 45 52 54 20 52 45 |PARENT I|NSERT RE|
|00003700| 53 54 52 49 43 54 00 20 | 20 20 20 2f 2a 20 45 52 |STRICT. |   /* ER|
|00003710| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00003720| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 20 20 2f 2a |etime */|..    /*|
|00003730| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00003740| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00003750| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 52 45 53 |ARENT IN|SERT RES|
|00003760| 54 52 49 43 54 20 2a 2f | 0d 0a 20 20 20 20 69 66 |TRICT */|..    if|
|00003770| 20 65 78 69 73 74 73 20 | 28 73 65 6c 65 63 74 20 | exists |(select |
|00003780| 2a 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 0d |* from i|nserted.|
|00003790| 0a 20 20 20 20 20 20 77 | 68 65 72 65 20 6e 6f 74 |.      w|here not|
|000037a0| 20 65 78 69 73 74 73 20 | 28 0d 0a 20 20 20 20 20 | exists |(..     |
|000037b0| 20 20 20 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 |     sel|ect * fr|
|000037c0| 6f 6d 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |om %Chil|d..     |
|000037d0| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 |     whe|re..    |
|000037e0| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 4a 6f 69 |        |/* %%Joi|
|000037f0| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 69 6e 73 |nFKPK(%C|hild,ins|
|00003800| 65 72 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |erted," |= "," an|
|00003810| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..|        |
|00003820| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |    %Joi|nFKPK(%C|
|00003830| 68 69 6c 64 2c 69 6e 73 | 65 72 74 65 64 2c 22 20 |hild,ins|erted," |
|00003840| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |= "," an|d")..   |
|00003850| 20 20 20 29 0d 0a 20 20 | 20 20 29 0d 0a 20 20 20 |   )..  |  )..   |
|00003860| 20 62 65 67 69 6e 0d 0a | 20 20 20 20 20 20 73 65 | begin..|      se|
|00003870| 6c 65 63 74 20 40 65 72 | 72 6e 6f 20 20 3d 20 33 |lect @er|rno  = 3|
|00003880| 30 30 31 31 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 |0011,.. |        |
|00003890| 20 20 20 20 40 65 72 72 | 6d 73 67 20 3d 20 27 43 |    @err|msg = 'C|
|000038a0| 61 6e 6e 6f 74 20 49 4e | 53 45 52 54 20 22 25 50 |annot IN|SERT "%P|
|000038b0| 61 72 65 6e 74 22 20 62 | 65 63 61 75 73 65 20 22 |arent" b|ecause "|
|000038c0| 25 43 68 69 6c 64 22 20 | 64 6f 65 73 20 6e 6f 74 |%Child" |does not|
|000038d0| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'..    |  goto e|
|000038e0| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 00 |rror..  |  end...|
|000038f0| 24 27 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |$'......|........|
|00003900| 55 50 44 41 54 45 20 48 | 45 41 44 45 52 00 63 72 |UPDATE H|EADER.cr|
|00003910| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00003920| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|00003930| 61 6d 65 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ame on %|TableNam|
|00003940| 65 20 66 6f 72 20 25 41 | 63 74 69 6f 6e 20 61 73 |e for %A|ction as|
|00003950| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00003960| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003970| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |./* %Act|ion trig|
|00003980| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00003990| 65 20 2a 2f 0d 0a 62 65 | 67 69 6e 0d 0a 20 20 64 |e */..be|gin..  d|
|000039a0| 65 63 6c 61 72 65 20 20 | 40 6e 75 6d 72 6f 77 73 |eclare  |@numrows|
|000039b0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|000039c0| 20 20 40 6e 75 6c 6c 63 | 6e 74 20 69 6e 74 2c 0d |  @nullc|nt int,.|
|000039d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 76 61 6c |.       |    @val|
|000039e0| 69 64 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |idcnt in|t,..    |
|000039f0| 20 20 20 20 20 20 20 25 | 50 4b 44 65 63 6c 28 2c |       %|PKDecl(,|
|00003a00| 40 69 6e 73 29 2c 0d 0a | 20 20 20 20 20 20 20 20 |@ins),..|        |
|00003a10| 20 20 20 40 65 72 72 6e | 6f 20 20 20 69 6e 74 2c |   @errn|o   int,|
|00003a20| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 65 72 |..      |     @er|
|00003a30| 72 6d 73 67 20 20 76 61 | 72 63 68 61 72 28 32 35 |rmsg  va|rchar(25|
|00003a40| 35 29 0d 0a 0d 0a 20 20 | 73 65 6c 65 63 74 20 40 |5)....  |select @|
|00003a50| 6e 75 6d 72 6f 77 73 20 | 3d 20 40 40 72 6f 77 63 |numrows |= @@rowc|
|00003a60| 6f 75 6e 74 00 28 27 00 | 00 00 00 00 00 00 00 00 |ount.('.|........|
|00003a70| 55 50 44 41 54 45 20 46 | 4f 4f 54 45 52 00 20 20 |UPDATE F|OOTER.  |
|00003a80| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00003a90| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00003aa0| 20 72 65 74 75 72 6e 0d | 0a 65 72 72 6f 72 3a 0d | return.|.error:.|
|00003ab0| 0a 20 20 20 20 72 61 69 | 73 65 72 72 6f 72 20 40 |.    rai|serror @|
|00003ac0| 65 72 72 6e 6f 20 40 65 | 72 72 6d 73 67 0d 0a 20 |errno @e|rrmsg.. |
|00003ad0| 20 20 20 72 6f 6c 6c 62 | 61 63 6b 20 74 72 61 6e |   rollb|ack tran|
|00003ae0| 73 61 63 74 69 6f 6e 0d | 0a 65 6e 64 0d 0a 67 6f |saction.|.end..go|
|00003af0| 0d 0a 00 29 27 00 00 00 | 00 00 00 00 00 00 00 00 |...)'...|........|
|00003b00| 44 45 4c 45 54 45 20 48 | 45 41 44 45 52 00 63 72 |DELETE H|EADER.cr|
|00003b10| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00003b20| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|00003b30| 61 6d 65 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ame on %|TableNam|
|00003b40| 65 20 66 6f 72 20 25 41 | 63 74 69 6f 6e 20 61 73 |e for %A|ction as|
|00003b50| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00003b60| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003b70| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |./* %Act|ion trig|
|00003b80| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00003b90| 65 20 2a 2f 0d 0a 62 65 | 67 69 6e 0d 0a 20 20 64 |e */..be|gin..  d|
|00003ba0| 65 63 6c 61 72 65 20 20 | 40 65 72 72 6e 6f 20 20 |eclare  |@errno  |
|00003bb0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|00003bc0| 20 20 40 65 72 72 6d 73 | 67 20 20 76 61 72 63 68 |  @errms|g  varch|
|00003bd0| 61 72 28 32 35 35 29 00 | 2a 27 00 00 00 00 00 00 |ar(255).|*'......|
|00003be0| 44 45 4c 45 54 45 20 46 | 4f 4f 54 45 52 00 20 20 |DELETE F|OOTER.  |
|00003bf0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |  /* ERw|in Built|
|00003c00| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003c10| 0a 20 20 20 20 72 65 74 | 75 72 6e 0d 0a 65 72 72 |.    ret|urn..err|
|00003c20| 6f 72 3a 0d 0a 20 20 20 | 20 72 61 69 73 65 72 72 |or:..   | raiserr|
|00003c30| 6f 72 20 40 65 72 72 6e | 6f 20 40 65 72 72 6d 73 |or @errn|o @errms|
|00003c40| 67 0d 0a 20 20 20 20 72 | 6f 6c 6c 62 61 63 6b 20 |g..    r|ollback |
|00003c50| 74 72 61 6e 73 61 63 74 | 69 6f 6e 0d 0a 65 6e 64 |transact|ion..end|
|00003c60| 0d 0a 67 6f 0d 0a 00 2b | 27 00 00 00 00 00 00 00 |..go...+|'.......|
|00003c70| 49 4e 53 45 52 54 20 48 | 45 41 44 45 52 00 63 72 |INSERT H|EADER.cr|
|00003c80| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00003c90| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|00003ca0| 61 6d 65 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ame on %|TableNam|
|00003cb0| 65 20 66 6f 72 20 25 41 | 63 74 69 6f 6e 20 61 73 |e for %A|ction as|
|00003cc0| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00003cd0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003ce0| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |./* %Act|ion trig|
|00003cf0| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00003d00| 65 20 2a 2f 0d 0a 62 65 | 67 69 6e 0d 0a 20 20 64 |e */..be|gin..  d|
|00003d10| 65 63 6c 61 72 65 20 20 | 40 6e 75 6d 72 6f 77 73 |eclare  |@numrows|
|00003d20| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|00003d30| 20 20 40 6e 75 6c 6c 63 | 6e 74 20 69 6e 74 2c 0d |  @nullc|nt int,.|
|00003d40| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 76 61 6c |.       |    @val|
|00003d50| 69 64 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |idcnt in|t,..    |
|00003d60| 20 20 20 20 20 20 20 40 | 65 72 72 6e 6f 20 20 20 |       @|errno   |
|00003d70| 69 6e 74 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |int,..  |        |
|00003d80| 20 40 65 72 72 6d 73 67 | 20 20 76 61 72 63 68 61 | @errmsg|  varcha|
|00003d90| 72 28 32 35 35 29 0d 0a | 0d 0a 20 20 73 65 6c 65 |r(255)..|..  sele|
|00003da0| 63 74 20 40 6e 75 6d 72 | 6f 77 73 20 3d 20 40 40 |ct @numr|ows = @@|
|00003db0| 72 6f 77 63 6f 75 6e 74 | 00 2c 27 00 00 00 00 00 |rowcount|.,'.....|
|00003dc0| 49 4e 53 45 52 54 20 46 | 4f 4f 54 45 52 00 20 20 |INSERT F|OOTER.  |
|00003dd0| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00003de0| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00003df0| 20 72 65 74 75 72 6e 0d | 0a 65 72 72 6f 72 3a 0d | return.|.error:.|
|00003e00| 0a 20 20 20 20 72 61 69 | 73 65 72 72 6f 72 20 40 |.    rai|serror @|
|00003e10| 65 72 72 6e 6f 20 40 65 | 72 72 6d 73 67 0d 0a 20 |errno @e|rrmsg.. |
|00003e20| 20 20 20 72 6f 6c 6c 62 | 61 63 6b 20 74 72 61 6e |   rollb|ack tran|
|00003e30| 73 61 63 74 69 6f 6e 0d | 0a 65 6e 64 0d 0a 67 6f |saction.|.end..go|
|00003e40| 0d 0a 00 2d 27 00 00 00 | 00 00 00 00 00 00 00 00 |...-'...|........|
|00003e50| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 48 |CUSTOM T|RIGGER H|
|00003e60| 45 41 44 45 52 00 63 72 | 65 61 74 65 20 74 72 69 |EADER.cr|eate tri|
|00003e70| 67 67 65 72 20 25 54 72 | 69 67 67 65 72 4e 61 6d |gger %Tr|iggerNam|
|00003e80| 65 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 0d |e on %Ta|bleName.|
|00003e90| 0a 20 20 66 6f 72 20 25 | 41 63 74 69 6f 6e 73 28 |.  for %|Actions(|
|00003ea0| 22 2c 22 29 0d 0a 20 20 | 61 73 0d 0a 00 2e 27 00 |",")..  |as....'.|
|00003eb0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 46 |CUSTOM T|RIGGER F|
|00003ec0| 4f 4f 54 45 52 00 67 6f | 0d 0a 00 2f 27 00 00 00 |OOTER.go|.../'...|
|00003ed0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|00003ee0| 45 46 41 55 4c 54 20 42 | 4f 44 59 00 63 72 65 61 |EFAULT B|ODY.crea|
|00003ef0| 74 65 20 74 72 69 67 67 | 65 72 20 25 54 72 69 67 |te trigg|er %Trig|
|00003f00| 67 65 72 4e 61 6d 65 20 | 6f 6e 20 25 54 61 62 6c |gerName |on %Tabl|
|00003f10| 65 4e 61 6d 65 0d 0a 20 | 20 66 6f 72 20 25 41 63 |eName.. | for %Ac|
|00003f20| 74 69 6f 6e 73 28 22 2c | 22 29 0d 0a 20 20 61 73 |tions(",|")..  as|
|00003f30| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00003f40| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003f50| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 73 28 22 2c 22 |./* %Act|ions(","|
|00003f60| 29 20 74 72 69 67 67 65 | 72 20 6f 6e 20 25 54 61 |) trigge|r on %Ta|
|00003f70| 62 6c 65 4e 61 6d 65 20 | 2a 2f 0d 0a 2f 2a 20 64 |bleName |*/../* d|
|00003f80| 65 66 61 75 6c 74 20 62 | 6f 64 79 20 66 6f 72 20 |efault b|ody for |
|00003f90| 25 54 72 69 67 67 65 72 | 4e 61 6d 65 20 2a 2f 0d |%Trigger|Name */.|
|00003fa0| 0a 62 65 67 69 6e 0d 0a | 20 20 64 65 63 6c 61 72 |.begin..|  declar|
|00003fb0| 65 20 20 40 6e 75 6d 72 | 6f 77 73 20 69 6e 74 2c |e  @numr|ows int,|
|00003fc0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 6e 75 |..      |     @nu|
|00003fd0| 6c 6c 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |llcnt in|t,..    |
|00003fe0| 20 20 20 20 20 20 20 40 | 76 61 6c 69 64 63 6e 74 |       @|validcnt|
|00003ff0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|00004000| 20 20 25 50 4b 44 65 63 | 6c 28 2c 40 69 6e 73 29 |  %PKDec|l(,@ins)|
|00004010| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |,..     |      @e|
|00004020| 72 72 6e 6f 20 20 20 69 | 6e 74 2c 0d 0a 20 20 20 |rrno   i|nt,..   |
|00004030| 20 20 20 20 20 20 20 20 | 40 65 72 72 6d 73 67 20 |        |@errmsg |
|00004040| 20 76 61 72 63 68 61 72 | 28 32 35 35 29 0d 0a 0d | varchar|(255)...|
|00004050| 0a 20 20 73 65 6c 65 63 | 74 20 40 6e 75 6d 72 6f |.  selec|t @numro|
|00004060| 77 73 20 3d 20 40 40 72 | 6f 77 63 6f 75 6e 74 0d |ws = @@r|owcount.|
|00004070| 0a 25 46 6f 72 45 61 63 | 68 43 68 69 6c 64 52 65 |.%ForEac|hChildRe|
|00004080| 6c 28 29 20 7b 0d 0a 20 | 20 25 52 65 6c 54 65 6d |l() {.. | %RelTem|
|00004090| 70 6c 61 74 65 0d 0a 7d | 0d 0a 25 46 6f 72 45 61 |plate..}|..%ForEa|
|000040a0| 63 68 50 61 72 65 6e 74 | 52 65 6c 28 29 20 7b 0d |chParent|Rel() {.|
|000040b0| 0a 20 20 25 52 65 6c 54 | 65 6d 70 6c 61 74 65 0d |.  %RelT|emplate.|
|000040c0| 0a 7d 0d 0a 20 20 72 65 | 74 75 72 6e 0d 0a 65 72 |.}..  re|turn..er|
|000040d0| 72 6f 72 3a 0d 0a 20 20 | 20 20 72 61 69 73 65 72 |ror:..  |  raiser|
|000040e0| 72 6f 72 20 40 65 72 72 | 6e 6f 20 40 65 72 72 6d |ror @err|no @errm|
|000040f0| 73 67 0d 0a 20 20 20 20 | 72 6f 6c 6c 62 61 63 6b |sg..    |rollback|
|00004100| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 0d 0a 65 6e | transac|tion..en|
|00004110| 64 0d 0a 67 6f 0d 0a 00 | 30 27 00 00 00 00 00 00 |d..go...|0'......|
|00004120| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 53 45 |PARENT U|PDATE SE|
|00004130| 54 20 44 45 46 41 55 4c | 54 00 2f 2a 20 45 52 77 |T DEFAUL|T./* ERw|
|00004140| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00004150| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00004160| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00004170| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|00004180| 20 55 50 44 41 54 45 20 | 53 45 54 20 44 45 46 41 | UPDATE |SET DEFA|
|00004190| 55 4c 54 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULT */..|/* Appli|
|000041a0| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|000041b0| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e |  Left o|ut inten|
|000041c0| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 00 13 27 00 |tionally|. */..'.|
|000041d0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 53 45 |PARENT D|ELETE SE|
|000041e0| 54 20 44 45 46 41 55 4c | 54 00 2f 2a 20 45 52 77 |T DEFAUL|T./* ERw|
|000041f0| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00004200| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00004210| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00004220| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|00004230| 20 44 45 4c 45 54 45 20 | 53 45 54 20 44 45 46 41 | DELETE |SET DEFA|
|00004240| 55 4c 54 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULT */..|/* Appli|
|00004250| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00004260| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e |  Left o|ut inten|
|00004270| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 00 17 27 00 |tionally|. */..'.|
|00004280| 50 41 52 45 4e 54 20 49 | 4e 53 45 52 54 20 53 45 |PARENT I|NSERT SE|
|00004290| 54 20 44 45 46 41 55 4c | 54 00 2f 2a 20 45 52 77 |T DEFAUL|T./* ERw|
|000042a0| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|000042b0| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|000042c0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|000042d0| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|000042e0| 20 49 4e 53 45 52 54 20 | 53 45 54 20 44 45 46 41 | INSERT |SET DEFA|
|000042f0| 55 4c 54 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULT */..|/* Appli|
|00004300| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00004310| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e |  Left o|ut inten|
|00004320| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 00 27 27 00 |tionally|. */.''.|
|00004330| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00004340| 20 44 45 46 41 55 4c 54 | 00 2f 2a 20 45 52 77 69 | DEFAULT|./* ERwi|
|00004350| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00004360| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00004370| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00004380| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 49 |Child ON| CHILD I|
|00004390| 4e 53 45 52 54 20 53 45 | 54 20 44 45 46 41 55 4c |NSERT SE|T DEFAUL|
|000043a0| 54 20 2a 2f 0d 0a 2f 2a | 20 41 70 70 6c 69 63 61 |T */../*| Applica|
|000043b0| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 63 2e 20 20 |tion spe|cific.  |
|000043c0| 4c 65 66 74 20 6f 75 74 | 20 69 6e 74 65 6e 74 69 |Left out| intenti|
|000043d0| 6f 6e 61 6c 6c 79 2e 20 | 2a 2f 00 1b 27 00 00 00 |onally. |*/..'...|
|000043e0| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|000043f0| 20 44 45 46 41 55 4c 54 | 00 2f 2a 20 45 52 77 69 | DEFAULT|./* ERwi|
|00004400| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00004410| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00004420| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00004430| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00004440| 50 44 41 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |PDATE SE|T DEFAUL|
|00004450| 54 20 2a 2f 0d 0a 2f 2a | 20 41 70 70 6c 69 63 61 |T */../*| Applica|
|00004460| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 63 2e 20 20 |tion spe|cific.  |
|00004470| 4c 65 66 74 20 6f 75 74 | 20 69 6e 74 65 6e 74 69 |Left out| intenti|
|00004480| 6f 6e 61 6c 6c 79 2e 20 | 2a 2f 00 1f 27 00 00 00 |onally. |*/..'...|
|00004490| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 53 45 54 |CHILD DE|LETE SET|
|000044a0| 20 44 45 46 41 55 4c 54 | 00 2f 2a 20 45 52 77 69 | DEFAULT|./* ERwi|
|000044b0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|000044c0| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|000044d0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000044e0| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 44 |Child ON| CHILD D|
|000044f0| 45 4c 45 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |ELETE SE|T DEFAUL|
|00004500| 54 20 2a 2f 0d 0a 2f 2a | 20 41 70 70 6c 69 63 61 |T */../*| Applica|
|00004510| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 63 2e 20 20 |tion spe|cific.  |
|00004520| 4c 65 66 74 20 6f 75 74 | 20 69 6e 74 65 6e 74 69 |Left out| intenti|
|00004530| 6f 6e 61 6c 6c 79 2e 20 | 2a 2f 00 23 27 00 00 00 |onally. |*/.#'...|
|00004540| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 53 45 54 |CHILD DE|LETE SET|
|00004550| 20 4e 55 4c 4c 00 2f 2a | 20 45 52 77 69 6e 20 42 | NULL./*| ERwin B|
|00004560| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00004570| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|00004580| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00004590| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 44 45 4c 45 |ld ON CH|ILD DELE|
|000045a0| 54 45 20 53 45 54 20 4e | 55 4c 4c 20 2a 2f 0d 0a |TE SET N|ULL */..|
|000045b0| 2f 2a 20 41 70 70 6c 69 | 63 61 74 69 6f 6e 20 73 |/* Appli|cation s|
|000045c0| 70 65 63 69 66 69 63 2e | 20 20 4c 65 66 74 20 6f |pecific.|  Left o|
|000045d0| 75 74 20 69 6e 74 65 6e | 74 69 6f 6e 61 6c 6c 79 |ut inten|tionally|
|000045e0| 2e 20 2a 2f 00 22 27 00 | 00 00 00 00 00 00 00 00 |. */."'.|........|
|000045f0| 50 41 52 45 4e 54 20 49 | 4e 53 45 52 54 20 53 45 |PARENT I|NSERT SE|
|00004600| 54 20 4e 55 4c 4c 00 2f | 2a 20 45 52 77 69 6e 20 |T NULL./|* ERwin |
|00004610| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00004620| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00004630| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00004640| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 49 4e |ild ON P|ARENT IN|
|00004650| 53 45 52 54 20 53 45 54 | 20 4e 55 4c 4c 20 2a 2f |SERT SET| NULL */|
|00004660| 0d 0a 2f 2a 20 41 70 70 | 6c 69 63 61 74 69 6f 6e |../* App|lication|
|00004670| 20 73 70 65 63 69 66 69 | 63 2e 20 20 4c 65 66 74 | specifi|c.  Left|
|00004680| 20 6f 75 74 20 69 6e 74 | 65 6e 74 69 6f 6e 61 6c | out int|entional|
|00004690| 6c 79 2e 20 2a 2f 00 26 | 27 00 00 00 00 00 00 00 |ly. */.&|'.......|
|000046a0| 50 41 52 45 4e 54 20 49 | 4e 53 45 52 54 20 43 41 |PARENT I|NSERT CA|
|000046b0| 53 43 41 44 45 00 2f 2a | 20 45 52 77 69 6e 20 42 |SCADE./*| ERwin B|
|000046c0| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|000046d0| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|000046e0| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|000046f0| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 49 4e 53 |ld ON PA|RENT INS|
|00004700| 45 52 54 20 43 41 53 43 | 41 44 45 20 2a 2f 0d 0a |ERT CASC|ADE */..|
|00004710| 2f 2a 20 41 70 70 6c 69 | 63 61 74 69 6f 6e 20 73 |/* Appli|cation s|
|00004720| 70 65 63 69 66 69 63 2e | 20 20 4c 65 66 74 20 6f |pecific.|  Left o|
|00004730| 75 74 20 69 6e 74 65 6e | 74 69 6f 6e 61 6c 6c 79 |ut inten|tionally|
|00004740| 2e 20 2a 2f 00 25 27 00 | 00 00 00 00 00 00 00 00 |. */.%'.|........|
|00004750| 25 00 00 00 25 25 00 45 | 78 61 6d 70 6c 65 3a 0d |%...%%.E|xample:.|
|00004760| 0a 64 65 6c 65 74 65 20 | 25 25 43 68 69 6c 64 20 |.delete |%%Child |
|00004770| 66 72 6f 6d 20 25 25 43 | 68 69 6c 64 2c 64 65 6c |from %%C|hild,del|
|00004780| 65 74 65 64 0d 0a 0d 0a | 45 78 70 61 6e 73 69 6f |eted....|Expansio|
|00004790| 6e 3a 0d 0a 64 65 6c 65 | 74 65 20 25 43 68 69 6c |n:..dele|te %Chil|
|000047a0| 64 20 66 72 6f 6d 20 25 | 43 68 69 6c 64 2c 64 65 |d from %|Child,de|
|000047b0| 6c 65 74 65 64 00 25 25 | 00 50 61 72 65 6e 74 41 |leted.%%|.ParentA|
|000047c0| 74 74 73 00 01 00 25 50 | 61 72 65 6e 74 41 74 74 |tts...%P|arentAtt|
|000047d0| 73 28 29 00 42 61 73 69 | 63 20 53 79 6e 74 61 78 |s().Basi|c Syntax|
|000047e0| 3a 0d 0a 25 50 61 72 65 | 6e 74 41 74 74 73 28 29 |:..%Pare|ntAtts()|
|000047f0| 0d 0a 0d 0a 42 61 73 69 | 63 20 53 79 6e 74 61 78 |....Basi|c Syntax|
|00004800| 20 45 78 61 6d 70 6c 65 | 3a 0d 0a 25 50 61 72 65 | Example|:..%Pare|
|00004810| 6e 74 41 74 74 73 28 29 | 0d 0a 45 78 70 61 6e 73 |ntAtts()|..Expans|
|00004820| 69 6f 6e 3a 0d 0a 6d 61 | 73 74 65 72 5f 6e 75 6d |ion:..ma|ster_num|
|00004830| 62 65 72 2c 20 6d 6f 76 | 69 65 5f 63 6f 70 79 5f |ber, mov|ie_copy_|
|00004840| 6e 75 6d 62 65 72 2c 20 | 67 65 6e 65 72 61 6c 5f |number, |general_|
|00004850| 63 6f 6e 64 69 74 69 6f | 6e 0d 0a 0d 0a 46 75 6c |conditio|n....Ful|
|00004860| 6c 20 53 79 6e 74 61 78 | 3a 0d 0a 25 50 61 72 65 |l Syntax|:..%Pare|
|00004870| 6e 74 41 74 74 73 28 3c | 73 65 70 61 72 61 74 6f |ntAtts(<|separato|
|00004880| 72 3e 2c 3c 66 75 6e 63 | 74 69 6f 6e 3e 2c 3c 70 |r>,<func|tion>,<p|
|00004890| 72 65 66 69 78 3e 29 0d | 0a 0d 0a 46 75 6c 6c 20 |refix>).|...Full |
|000048a0| 53 79 6e 74 61 78 20 45 | 78 70 61 6d 6c 65 3a 0d |Syntax E|xpamle:.|
|000048b0| 0a 25 50 61 72 65 6e 74 | 41 74 74 73 28 22 20 6f |.%Parent|Atts(" o|
|000048c0| 72 20 22 2c 75 70 64 61 | 74 65 2c 25 50 61 72 65 |r ",upda|te,%Pare|
|000048d0| 6e 74 29 0d 0a 45 78 70 | 61 6e 73 69 6f 6e 3a 0d |nt)..Exp|ansion:.|
|000048e0| 0a 75 70 64 61 74 65 28 | 4d 4f 56 49 45 5f 43 4f |.update(|MOVIE_CO|
|000048f0| 50 59 2e 6d 61 73 74 65 | 72 5f 6e 75 6d 62 65 72 |PY.maste|r_number|
|00004900| 29 20 6f 72 0d 0a 75 70 | 64 61 74 65 28 4d 4f 56 |) or..up|date(MOV|
|00004910| 49 45 5f 43 4f 50 59 2e | 6d 6f 76 69 65 5f 63 6f |IE_COPY.|movie_co|
|00004920| 70 79 5f 6e 75 6d 62 65 | 72 29 20 6f 72 20 75 70 |py_numbe|r) or up|
|00004930| 64 61 74 65 28 4d 4f 56 | 49 45 5f 43 4f 50 59 2e |date(MOV|IE_COPY.|
|00004940| 67 65 6e 65 72 61 6c 5f | 63 6f 6e 64 69 74 69 6f |general_|conditio|
|00004950| 6e 29 00 25 50 61 72 65 | 6e 74 41 74 74 73 28 22 |n).%Pare|ntAtts("|
|00004960| 2c 20 22 2c 2c 40 69 6e | 73 29 00 50 61 72 65 6e |, ",,@in|s).Paren|
|00004970| 74 41 74 74 00 02 00 25 | 50 61 72 65 6e 74 41 74 |tAtt...%|ParentAt|
|00004980| 74 28 29 00 42 61 73 69 | 63 20 53 79 6e 74 61 78 |t().Basi|c Syntax|
|00004990| 3a 0d 0a 25 50 61 72 65 | 6e 74 41 74 74 28 3c 61 |:..%Pare|ntAtt(<a|
|000049a0| 74 74 72 69 62 75 74 65 | 20 6d 61 63 72 6f 3e 29 |ttribute| macro>)|
|000049b0| 0d 0a 0d 0a 42 61 73 69 | 63 20 53 79 6e 74 61 78 |....Basi|c Syntax|
|000049c0| 20 45 78 61 6d 70 6c 65 | 3a 0d 0a 25 46 6f 72 45 | Example|:..%ForE|
|000049d0| 61 63 68 46 4b 41 74 74 | 28 29 20 7b 25 50 61 72 |achFKAtt|() {%Par|
|000049e0| 65 6e 74 41 74 74 28 25 | 41 74 74 46 69 65 6c 64 |entAtt(%|AttField|
|000049f0| 4e 61 6d 65 29 7d 0d 0a | 45 78 70 61 6e 73 69 6f |Name)}..|Expansio|
|00004a00| 6e 3a 0d 0a 6d 61 73 74 | 65 72 5f 6e 75 6d 62 65 |n:..mast|er_numbe|
|00004a10| 72 2c 20 6d 6f 76 69 65 | 5f 63 6f 70 79 5f 6e 75 |r, movie|_copy_nu|
|00004a20| 6d 62 65 72 00 25 50 61 | 72 65 6e 74 41 74 74 28 |mber.%Pa|rentAtt(|
|00004a30| 25 41 74 74 46 69 65 6c | 64 4e 61 6d 65 29 00 50 |%AttFiel|dName).P|
|00004a40| 61 72 65 6e 74 50 4b 44 | 65 63 6c 00 03 00 25 50 |arentPKD|ecl...%P|
|00004a50| 61 72 65 6e 74 50 4b 44 | 65 63 6c 28 29 00 42 61 |arentPKD|ecl().Ba|
|00004a60| 73 69 63 20 53 79 6e 74 | 61 78 3a 0d 0a 25 50 61 |sic Synt|ax:..%Pa|
|00004a70| 72 65 6e 74 50 4b 44 65 | 63 6c 28 3c 6f 6c 64 20 |rentPKDe|cl(<old |
|00004a80| 70 72 65 66 69 78 3e 2c | 3c 6e 65 77 20 70 72 65 |prefix>,|<new pre|
|00004a90| 66 69 78 3e 29 0d 0a 0d | 0a 42 61 73 69 63 20 53 |fix>)...|.Basic S|
|00004aa0| 79 6e 74 61 78 20 45 78 | 61 6d 70 6c 65 3a 0d 0a |yntax Ex|ample:..|
|00004ab0| 25 50 61 72 65 6e 74 50 | 4b 44 65 63 6c 28 2c 40 |%ParentP|KDecl(,@|
|00004ac0| 69 6e 73 29 0d 0a 45 78 | 70 61 6e 73 69 6f 6e 3a |ins)..Ex|pansion:|
|00004ad0| 0d 0a 40 69 6e 73 5f 6d | 61 73 74 65 72 5f 6e 75 |..@ins_m|aster_nu|
|00004ae0| 6d 62 65 72 20 69 6e 74 | 2c 0d 0a 40 69 6e 73 5f |mber int|,..@ins_|
|00004af0| 6d 6f 76 69 65 5f 63 6f | 70 79 5f 6e 75 6d 62 65 |movie_co|py_numbe|
|00004b00| 72 20 69 6e 74 0d 0a 0d | 0a 46 75 6c 6c 20 53 79 |r int...|.Full Sy|
|00004b10| 6e 74 61 78 3a 0d 0a 25 | 50 61 72 65 6e 74 50 4b |ntax:..%|ParentPK|
|00004b20| 44 65 63 6c 28 3c 6f 6c | 64 20 70 72 65 66 69 78 |Decl(<ol|d prefix|
|00004b30| 3e 2c 3c 6e 65 77 20 70 | 72 65 66 69 78 3e 2c 3c |>,<new p|refix>,<|
|00004b40| 73 65 70 61 72 61 74 6f | 72 3e 29 0d 0a 0d 0a 46 |separato|r>)....F|
|00004b50| 75 6c 6c 20 53 79 6e 74 | 61 78 20 45 78 61 6d 70 |ull Synt|ax Examp|
|00004b60| 6c 65 3a 0d 0a 25 50 61 | 72 65 6e 74 50 4b 44 65 |le:..%Pa|rentPKDe|
|00004b70| 63 6c 28 2c 40 69 6e 73 | 2c 22 2c 20 22 29 0d 0a |cl(,@ins|,", ")..|
|00004b80| 45 78 70 61 6e 73 69 6f | 6e 3a 0d 0a 40 69 6e 73 |Expansio|n:..@ins|
|00004b90| 5f 6d 61 73 74 65 72 5f | 6e 75 6d 62 65 72 20 69 |_master_|number i|
|00004ba0| 6e 74 2c 0d 0a 40 69 6e | 73 5f 6d 6f 76 69 65 5f |nt,..@in|s_movie_|
|00004bb0| 63 6f 70 79 5f 6e 75 6d | 62 65 72 20 69 6e 74 00 |copy_num|ber int.|
|00004bc0| 25 50 61 72 65 6e 74 50 | 4b 44 65 63 6c 28 2c 40 |%ParentP|KDecl(,@|
|00004bd0| 69 6e 73 29 00 50 61 72 | 65 6e 74 50 4b 00 04 00 |ins).Par|entPK...|
|00004be0| 25 50 61 72 65 6e 74 50 | 4b 28 29 00 42 61 73 69 |%ParentP|K().Basi|
|00004bf0| 63 20 53 79 6e 74 61 78 | 3a 0d 0a 25 50 61 72 65 |c Syntax|:..%Pare|
|00004c00| 6e 74 50 4b 28 29 0d 0a | 0d 0a 42 61 73 69 63 20 |ntPK()..|..Basic |
|00004c10| 53 79 6e 74 61 78 20 45 | 78 61 6d 70 6c 65 3a 0d |Syntax E|xample:.|
|00004c20| 0a 25 50 61 72 65 6e 74 | 50 4b 28 29 0d 0a 45 78 |.%Parent|PK()..Ex|
|00004c30| 70 61 6e 73 69 6f 6e 3a | 0d 0a 6d 61 73 74 65 72 |pansion:|..master|
|00004c40| 5f 6e 75 6d 62 65 72 2c | 20 6d 6f 76 69 65 5f 63 |_number,| movie_c|
|00004c50| 6f 70 79 5f 6e 75 6d 62 | 65 72 2c 2e 2e 2e 0d 0a |opy_numb|er,.....|
|00004c60| 0d 0a 46 75 6c 6c 20 53 | 79 6e 74 61 78 3a 0d 0a |..Full S|yntax:..|
|00004c70| 25 50 61 72 65 6e 74 50 | 4b 28 3c 73 65 70 61 72 |%ParentP|K(<separ|
|00004c80| 61 74 6f 72 3e 2c 3c 66 | 75 6e 63 74 69 6f 6e 3e |ator>,<f|unction>|
|00004c90| 2c 3c 70 72 65 66 69 78 | 3e 29 0d 0a 0d 0a 46 75 |,<prefix|>)....Fu|
|00004ca0| 6c 6c 20 53 79 6e 74 61 | 78 20 45 78 70 61 6d 6c |ll Synta|x Expaml|
|00004cb0| 65 3a 0d 0a 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |e:..%Par|entPK(" |
|00004cc0| 6f 72 20 22 2c 75 70 64 | 61 74 65 2c 25 50 61 72 |or ",upd|ate,%Par|
|00004cd0| 65 6e 74 29 0d 0a 45 78 | 70 61 6e 73 69 6f 6e 3a |ent)..Ex|pansion:|
|00004ce0| 0d 0a 75 70 64 61 74 65 | 28 4d 4f 56 49 45 5f 43 |..update|(MOVIE_C|
|00004cf0| 4f 50 59 2e 6d 61 73 74 | 65 72 5f 6e 75 6d 62 65 |OPY.mast|er_numbe|
|00004d00| 72 29 20 6f 72 0d 0a 75 | 70 64 61 74 65 28 4d 4f |r) or..u|pdate(MO|
|00004d10| 56 49 45 5f 43 4f 50 59 | 2c 6d 6f 76 69 65 5f 63 |VIE_COPY|,movie_c|
|00004d20| 6f 70 79 5f 6e 75 6d 62 | 65 72 29 2e 2e 2e 00 25 |opy_numb|er)....%|
|00004d30| 50 61 72 65 6e 74 50 4b | 28 22 20 6f 72 20 22 2c |ParentPK|(" or ",|
|00004d40| 75 70 64 61 74 65 29 00 | 50 61 72 65 6e 74 4e 4b |update).|ParentNK|
|00004d50| 44 65 63 6c 00 05 00 25 | 50 61 72 65 6e 74 4e 4b |Decl...%|ParentNK|
|00004d60| 44 65 63 6c 28 29 00 42 | 61 73 69 63 20 53 79 6e |Decl().B|asic Syn|
|00004d70| 74 61 78 3a 0d 0a 25 50 | 61 72 65 6e 74 4e 4b 44 |tax:..%P|arentNKD|
|00004d80| 65 63 6c 28 3c 6f 6c 64 | 20 70 72 65 66 69 78 3e |ecl(<old| prefix>|
|00004d90| 2c 3c 6e 65 77 20 70 72 | 65 66 69 78 3e 29 0d 0a |,<new pr|efix>)..|
|00004da0| 0d 0a 42 61 73 69 63 20 | 53 79 6e 74 61 78 20 45 |..Basic |Syntax E|
|00004db0| 78 61 6d 70 6c 65 3a 0d | 0a 25 50 61 72 65 6e 74 |xample:.|.%Parent|
|00004dc0| 4e 4b 44 65 63 6c 28 2c | 40 69 6e 73 29 0d 0a 45 |NKDecl(,|@ins)..E|
|00004dd0| 78 70 61 6e 73 69 6f 6e | 3a 0d 0a 40 69 6e 73 5f |xpansion|:..@ins_|
|00004de0| 67 65 6e 65 72 61 6c 5f | 63 6f 6e 64 69 74 69 6f |general_|conditio|
|00004df0| 6e 20 76 61 72 63 68 61 | 72 28 31 30 29 0d 0a 46 |n varcha|r(10)..F|
|00004e00| 75 6c 6c 20 53 79 6e 74 | 61 78 3a 0d 0a 25 50 61 |ull Synt|ax:..%Pa|
|00004e10| 72 65 6e 74 4e 4b 44 65 | 63 6c 28 3c 6f 6c 64 20 |rentNKDe|cl(<old |
|00004e20| 70 72 65 66 69 78 3e 2c | 3c 6e 65 77 20 70 72 65 |prefix>,|<new pre|
|00004e30| 66 69 78 3e 2c 3c 73 65 | 70 61 72 61 74 6f 72 3e |fix>,<se|parator>|
|00004e40| 29 0d 0a 0d 0a 46 75 6c | 6c 20 53 79 6e 74 61 78 |)....Ful|l Syntax|
|00004e50| 20 45 78 61 6d 70 6c 65 | 3a 0d 0a 25 50 61 72 65 | Example|:..%Pare|
|00004e60| 6e 74 4e 4b 44 65 63 6c | 28 2c 40 69 6e 73 2c 22 |ntNKDecl|(,@ins,"|
|00004e70| 2c 20 22 29 0d 0a 45 78 | 70 61 6e 73 69 6f 6e 3a |, ")..Ex|pansion:|
|00004e80| 0d 0a 40 69 6e 73 5f 67 | 65 6e 65 72 61 6c 5f 63 |..@ins_g|eneral_c|
|00004e90| 6f 6e 64 69 74 69 6f 6e | 20 76 61 72 63 68 61 72 |ondition| varchar|
|00004ea0| 28 31 30 29 00 25 50 61 | 72 65 6e 74 4e 4b 44 65 |(10).%Pa|rentNKDe|
|00004eb0| 63 6c 28 2c 40 69 6e 73 | 29 00 50 61 72 65 6e 74 |cl(,@ins|).Parent|
|00004ec0| 4e 4b 00 06 00 25 50 61 | 72 65 6e 74 4e 4b 28 29 |NK...%Pa|rentNK()|
|00004ed0| 00 42 61 73 69 63 20 53 | 79 6e 74 61 78 3a 0d 0a |.Basic S|yntax:..|
|00004ee0| 25 50 61 72 65 6e 74 4e | 4b 28 29 0d 0a 0d 0a 42 |%ParentN|K()....B|
|00004ef0| 61 73 69 63 20 53 79 6e | 74 61 78 20 45 78 61 6d |asic Syn|tax Exam|
|00004f00| 70 6c 65 3a 0d 0a 25 50 | 61 72 65 6e 74 4e 4b 28 |ple:..%P|arentNK(|
|00004f10| 29 0d 0a 45 78 70 61 6e | 73 69 6f 6e 3a 0d 0a 67 |)..Expan|sion:..g|
|00004f20| 65 6e 65 72 61 6c 5f 63 | 6f 6e 64 69 74 69 6f 6e |eneral_c|ondition|
|00004f30| 0d 0a 0d 0a 46 75 6c 6c | 20 53 79 6e 74 61 78 3a |....Full| Syntax:|
|00004f40| 0d 0a 25 50 61 72 65 6e | 74 4e 4b 28 3c 73 65 70 |..%Paren|tNK(<sep|
|00004f50| 61 72 61 74 6f 72 3e 2c | 3c 66 75 6e 63 74 69 6f |arator>,|<functio|
|00004f60| 6e 3e 2c 3c 70 72 65 66 | 69 78 3e 29 0d 0a 0d 0a |n>,<pref|ix>)....|
|00004f70| 46 75 6c 6c 20 53 79 6e | 74 61 78 20 45 78 70 61 |Full Syn|tax Expa|
|00004f80| 6d 6c 65 3a 0d 0a 25 50 | 61 72 65 6e 74 4e 4b 28 |mle:..%P|arentNK(|
|00004f90| 22 20 6f 72 20 22 2c 75 | 70 64 61 74 65 2c 25 50 |" or ",u|pdate,%P|
|00004fa0| 61 72 65 6e 74 29 0d 0a | 45 78 70 61 6e 73 69 6f |arent)..|Expansio|
|00004fb0| 6e 3a 0d 0a 75 70 64 61 | 74 65 28 4d 4f 56 49 45 |n:..upda|te(MOVIE|
|00004fc0| 5f 43 4f 50 59 2e 67 65 | 6e 65 72 61 6c 5f 63 6f |_COPY.ge|neral_co|
|00004fd0| 6e 64 69 74 69 6f 6e 29 | 00 25 50 61 72 65 6e 74 |ndition)|.%Parent|
|00004fe0| 4e 4b 28 29 00 43 68 69 | 6c 64 41 74 74 73 00 07 |NK().Chi|ldAtts..|
|00004ff0| 00 25 43 68 69 6c 64 41 | 74 74 73 28 29 00 42 61 |.%ChildA|tts().Ba|
|00005000| 73 69 63 20 53 79 6e 74 | 61 78 3a 0d 0a 25 43 68 |sic Synt|ax:..%Ch|
|00005010| 69 6c 64 41 74 74 73 28 | 29 0d 0a 0d 0a 42 61 73 |ildAtts(|)....Bas|
|00005020| 69 63 20 53 79 6e 74 61 | 78 20 45 78 61 6d 70 6c |ic Synta|x Exampl|
|00005030| 65 3a 0d 0a 25 43 68 69 | 6c 64 41 74 74 73 28 29 |e:..%Chi|ldAtts()|
|00005040| 0d 0a 45 78 70 61 6e 73 | 69 6f 6e 3a 0d 0a 72 65 |..Expans|ion:..re|
|00005050| 6e 74 69 6e 67 5f 63 75 | 73 74 6f 6d 65 72 2c 20 |nting_cu|stomer, |
|00005060| 6d 61 73 74 65 72 5f 6e | 75 6d 62 65 72 2c 20 6d |master_n|umber, m|
|00005070| 6f 76 69 65 5f 63 6f 70 | 79 5f 6e 75 6d 62 65 72 |ovie_cop|y_number|
|00005080| 2c 20 72 65 6e 74 61 6c | 5f 72 65 63 6f 72 64 5f |, rental|_record_|
|00005090| 64 61 74 65 2c 20 72 65 | 6e 74 61 6c 5f 64 61 74 |date, re|ntal_dat|
|000050a0| 65 2c 2e 2e 2e 0d 0a 0d | 0a 46 75 6c 6c 20 53 79 |e,......|.Full Sy|
|000050b0| 6e 74 61 78 3a 0d 0a 25 | 43 68 69 6c 64 41 74 74 |ntax:..%|ChildAtt|
|000050c0| 73 28 3c 73 65 70 61 72 | 61 74 6f 72 3e 2c 3c 66 |s(<separ|ator>,<f|
|000050d0| 75 6e 63 74 69 6f 6e 3e | 2c 3c 70 72 65 66 69 78 |unction>|,<prefix|
|000050e0| 3e 29 0d 0a 0d 0a 46 75 | 6c 6c 20 53 79 6e 74 61 |>)....Fu|ll Synta|
|000050f0| 78 20 45 78 70 61 6d 6c | 65 3a 0d 0a 25 43 68 69 |x Expaml|e:..%Chi|
|00005100| 6c 64 41 74 74 73 28 22 | 20 6f 72 20 22 2c 75 70 |ldAtts("| or ",up|
|00005110| 64 61 74 65 2c 25 43 68 | 69 6c 64 29 0d 0a 45 78 |date,%Ch|ild)..Ex|
|00005120| 70 61 6e 73 69 6f 6e 3a | 0d 0a 75 70 64 61 74 65 |pansion:|..update|
|00005130| 28 4d 4f 56 49 45 5f 52 | 45 4e 54 41 4c 5f 52 45 |(MOVIE_R|ENTAL_RE|
|00005140| 43 4f 52 2e 72 65 6e 74 | 69 6e 67 5f 63 75 73 74 |COR.rent|ing_cust|
|00005150| 6f 6d 65 72 29 20 6f 72 | 0d 0a 75 70 64 61 74 65 |omer) or|..update|
|00005160| 28 4d 4f 56 49 45 5f 52 | 45 4e 54 41 4c 5f 52 45 |(MOVIE_R|ENTAL_RE|
|00005170| 43 4f 52 2e 6d 61 73 74 | 65 72 5f 6e 75 6d 62 65 |COR.mast|er_numbe|
|00005180| 72 29 20 6f 72 0d 0a 75 | 70 64 61 74 65 28 4d 4f |r) or..u|pdate(MO|
|00005190| 56 49 45 5f 52 45 4e 54 | 41 4c 5f 52 45 43 4f 52 |VIE_RENT|AL_RECOR|
|000051a0| 2e 6d 6f 76 69 65 5f 63 | 6f 70 79 5f 6e 75 6d 62 |.movie_c|opy_numb|
|000051b0| 65 72 29 20 6f 72 0d 0a | 75 70 64 61 74 65 28 4d |er) or..|update(M|
|000051c0| 4f 56 49 45 5f 52 45 4e | 54 41 4c 5f 52 45 43 4f |OVIE_REN|TAL_RECO|
|000051d0| 52 2e 72 65 6e 74 61 6c | 5f 72 65 63 6f 72 64 5f |R.rental|_record_|
|000051e0| 64 61 74 65 29 20 6f 72 | 0d 0a 75 70 64 61 74 65 |date) or|..update|
|000051f0| 28 4d 4f 56 49 45 5f 52 | 45 4e 54 41 4c 5f 52 45 |(MOVIE_R|ENTAL_RE|
|00005200| 43 4f 52 2e 72 65 6e 74 | 61 6c 5f 72 65 63 6f 72 |COR.rent|al_recor|
|00005210| 64 5f 64 61 74 65 29 20 | 6f 72 20 2e 2e 2e 00 25 |d_date) |or ....%|
|00005220| 43 68 69 6c 64 41 74 74 | 73 28 22 2c 20 22 2c 2c |ChildAtt|s(", ",,|
|00005230| 40 69 6e 73 29 00 43 68 | 69 6c 64 50 4b 44 65 63 |@ins).Ch|ildPKDec|
|00005240| 6c 00 08 00 25 43 68 69 | 6c 64 50 4b 44 65 63 6c |l...%Chi|ldPKDecl|
|00005250| 28 29 00 42 61 73 69 63 | 20 53 79 6e 74 61 78 3a |().Basic| Syntax:|
|00005260| 0d 0a 25 43 68 69 6c 64 | 50 4b 44 65 63 6c 28 3c |..%Child|PKDecl(<|
|00005270| 6f 6c 64 20 70 72 65 66 | 69 78 3e 2c 3c 6e 65 77 |old pref|ix>,<new|
|00005280| 20 70 72 65 66 69 78 3e | 29 0d 0a 0d 0a 42 61 73 | prefix>|)....Bas|
|00005290| 69 63 20 53 79 6e 74 61 | 78 20 45 78 61 6d 70 6c |ic Synta|x Exampl|
|000052a0| 65 3a 0d 0a 25 43 68 69 | 6c 64 50 4b 44 65 63 6c |e:..%Chi|ldPKDecl|
|000052b0| 28 2c 40 69 6e 73 29 0d | 0a 45 78 70 61 6e 73 69 |(,@ins).|.Expansi|
|000052c0| 6f 6e 3a 0d 0a 40 69 6e | 73 5f 72 65 6e 74 69 6e |on:..@in|s_rentin|
|000052d0| 67 5f 63 75 73 74 6f 6d | 65 72 20 69 6e 74 2c 0d |g_custom|er int,.|
|000052e0| 0a 40 69 6e 73 5f 6d 61 | 73 74 65 72 5f 6e 75 6d |.@ins_ma|ster_num|
|000052f0| 62 65 72 20 69 6e 74 2c | 0d 0a 40 69 6e 73 5f 6d |ber int,|..@ins_m|
|00005300| 6f 76 69 65 5f 63 6f 70 | 79 5f 6e 75 6d 62 65 72 |ovie_cop|y_number|
|00005310| 20 69 6e 74 2c 0d 0a 40 | 69 6e 73 5f 72 65 6e 74 | int,..@|ins_rent|
|00005320| 61 6c 5f 72 65 63 6f 72 | 64 5f 64 61 74 65 20 64 |al_recor|d_date d|
|00005330| 61 74 65 74 69 6d 65 0d | 0a 0d 0a 46 75 6c 6c 20 |atetime.|...Full |
|00005340| 53 79 6e 74 61 78 3a 0d | 0a 25 43 68 69 6c 64 50 |Syntax:.|.%ChildP|
|00005350| 4b 44 65 63 6c 28 3c 6f | 6c 64 20 70 72 65 66 69 |KDecl(<o|ld prefi|
|00005360| 78 3e 2c 3c 6e 65 77 20 | 70 72 65 66 69 78 3e 2c |x>,<new |prefix>,|
|00005370| 3c 73 65 70 61 72 61 74 | 6f 72 3e 29 0d 0a 0d 0a |<separat|or>)....|
|00005380| 46 75 6c 6c 20 53 79 6e | 74 61 78 20 45 78 61 6d |Full Syn|tax Exam|
|00005390| 70 6c 65 3a 0d 0a 25 43 | 68 69 6c 64 50 4b 44 65 |ple:..%C|hildPKDe|
|000053a0| 63 6c 28 2c 40 69 6e 73 | 2c 22 2c 20 22 29 0d 0a |cl(,@ins|,", ")..|
|000053b0| 45 78 70 61 6e 73 69 6f | 6e 3a 0d 0a 40 69 6e 73 |Expansio|n:..@ins|
|000053c0| 5f 72 65 6e 74 69 6e 67 | 5f 63 75 73 74 6f 6d 65 |_renting|_custome|
|000053d0| 72 20 69 6e 74 2c 0d 0a | 40 69 6e 73 5f 6d 61 73 |r int,..|@ins_mas|
|000053e0| 74 65 72 5f 6e 75 6d 62 | 65 72 20 69 6e 74 2c 0d |ter_numb|er int,.|
|000053f0| 0a 40 69 6e 73 5f 6d 6f | 76 69 65 5f 63 6f 70 79 |.@ins_mo|vie_copy|
|00005400| 5f 6e 75 6d 62 65 72 20 | 69 6e 74 2c 0d 0a 40 69 |_number |int,..@i|
|00005410| 6e 73 5f 72 65 6e 74 61 | 6c 5f 72 65 63 6f 72 64 |ns_renta|l_record|
|00005420| 5f 64 61 74 65 20 64 61 | 74 65 74 69 6d 65 0d 0a |_date da|tetime..|
|00005430| 00 25 43 68 69 6c 64 50 | 4b 44 65 63 6c 28 40 64 |.%ChildP|KDecl(@d|
|00005440| 65 6c 2c 40 69 6e 73 29 | 00 43 68 69 6c 64 50 4b |el,@ins)|.ChildPK|
|00005450| 00 09 00 25 43 68 69 6c | 64 50 4b 28 29 00 42 61 |...%Chil|dPK().Ba|
|00005460| 73 69 63 20 53 79 6e 74 | 61 78 3a 0d 0a 25 43 68 |sic Synt|ax:..%Ch|
|00005470| 69 6c 64 50 4b 28 29 0d | 0a 0d 0a 42 61 73 69 63 |ildPK().|...Basic|
|00005480| 20 53 79 6e 74 61 78 20 | 45 78 61 6d 70 6c 65 3a | Syntax |Example:|
|00005490| 0d 0a 25 43 68 69 6c 64 | 50 4b 28 29 0d 0a 45 78 |..%Child|PK()..Ex|
|000054a0| 70 61 6e 73 69 6f 6e 3a | 0d 0a 72 65 6e 74 69 6e |pansion:|..rentin|
|000054b0| 67 5f 63 75 73 74 6f 6d | 65 72 2c 20 6d 61 73 74 |g_custom|er, mast|
|000054c0| 65 72 5f 6e 75 6d 62 65 | 72 2c 20 6d 6f 76 69 65 |er_numbe|r, movie|
|000054d0| 5f 63 6f 70 79 5f 6e 75 | 6d 62 65 72 2c 20 72 65 |_copy_nu|mber, re|
|000054e0| 6e 74 61 6c 5f 72 65 63 | 6f 72 64 5f 64 61 74 65 |ntal_rec|ord_date|
|000054f0| 0d 0a 0d 0a 46 75 6c 6c | 20 53 79 6e 74 61 78 3a |....Full| Syntax:|
|00005500| 0d 0a 25 43 68 69 6c 64 | 50 4b 28 3c 73 65 70 61 |..%Child|PK(<sepa|
|00005510| 72 61 74 6f 72 3e 2c 3c | 66 75 6e 63 74 69 6f 6e |rator>,<|function|
|00005520| 3e 2c 3c 70 72 65 66 69 | 78 3e 29 0d 0a 0d 0a 46 |>,<prefi|x>)....F|
|00005530| 75 6c 6c 20 53 79 6e 74 | 61 78 20 45 78 70 61 6d |ull Synt|ax Expam|
|00005540| 6c 65 3a 0d 0a 25 43 68 | 69 6c 64 50 4b 28 22 20 |le:..%Ch|ildPK(" |
|00005550| 6f 72 20 22 2c 75 70 64 | 61 74 65 2c 25 43 68 69 |or ",upd|ate,%Chi|
|00005560| 6c 64 29 0d 0a 45 78 70 | 61 6e 73 69 6f 6e 3a 0d |ld)..Exp|ansion:.|
|00005570| 0a 75 70 64 61 74 65 28 | 4d 4f 56 49 45 5f 52 45 |.update(|MOVIE_RE|
|00005580| 4e 54 41 4c 5f 52 45 43 | 4f 52 2e 72 65 6e 74 69 |NTAL_REC|OR.renti|
|00005590| 6e 67 5f 63 75 73 74 6f | 6d 65 72 29 20 6f 72 0d |ng_custo|mer) or.|
|000055a0| 0a 75 70 64 61 74 65 28 | 4d 4f 56 49 45 5f 52 45 |.update(|MOVIE_RE|
|000055b0| 4e 54 41 4c 5f 52 45 43 | 4f 52 2e 6d 61 73 74 65 |NTAL_REC|OR.maste|
|000055c0| 72 5f 6e 75 6d 62 65 72 | 29 20 6f 72 0d 0a 75 70 |r_number|) or..up|
|000055d0| 64 61 74 65 28 4d 4f 56 | 49 45 5f 52 45 4e 54 41 |date(MOV|IE_RENTA|
|000055e0| 4c 5f 52 45 43 4f 52 2e | 6d 6f 76 69 65 5f 63 6f |L_RECOR.|movie_co|
|000055f0| 70 79 5f 6e 75 6d 62 65 | 72 29 20 6f 72 0d 0a 75 |py_numbe|r) or..u|
|00005600| 70 64 61 74 65 28 4d 4f | 56 49 45 5f 52 45 4e 54 |pdate(MO|VIE_RENT|
|00005610| 41 4c 5f 52 45 43 4f 52 | 2e 72 65 6e 74 61 6c 5f |AL_RECOR|.rental_|
|00005620| 72 65 63 6f 72 64 5f 64 | 61 74 65 29 00 25 43 68 |record_d|ate).%Ch|
|00005630| 69 6c 64 50 4b 28 22 20 | 6f 72 20 22 2c 75 70 64 |ildPK(" |or ",upd|
|00005640| 61 74 65 29 00 43 68 69 | 6c 64 46 4b 44 65 63 6c |ate).Chi|ldFKDecl|
|00005650| 00 0a 00 25 43 68 69 6c | 64 46 4b 44 65 63 6c 28 |...%Chil|dFKDecl(|
|00005660| 29 00 42 61 73 69 63 20 | 53 79 6e 74 61 78 3a 0d |).Basic |Syntax:.|
|00005670| 0a 25 43 68 69 6c 64 46 | 4b 44 65 63 6c 28 3c 6f |.%ChildF|KDecl(<o|
|00005680| 6c 64 20 70 72 65 66 69 | 78 3e 2c 3c 6e 65 77 20 |ld prefi|x>,<new |
|00005690| 70 72 65 66 69 78 3e 29 | 0d 0a 0d 0a 42 61 73 69 |prefix>)|....Basi|
|000056a0| 63 20 53 79 6e 74 61 78 | 20 45 78 61 6d 70 6c 65 |c Syntax| Example|
|000056b0| 3a 0d 0a 25 43 68 69 6c | 64 46 4b 44 65 63 6c 28 |:..%Chil|dFKDecl(|
|000056c0| 2c 40 69 6e 73 29 0d 0a | 45 78 70 61 6e 73 69 6f |,@ins)..|Expansio|
|000056d0| 6e 3a 0d 0a 40 69 6e 73 | 5f 6d 61 73 74 65 72 5f |n:..@ins|_master_|
|000056e0| 6e 75 6d 62 65 72 20 69 | 6e 74 2c 0d 0a 40 69 6e |number i|nt,..@in|
|000056f0| 73 5f 6d 6f 76 69 65 5f | 63 6f 70 79 5f 6e 75 6d |s_movie_|copy_num|
|00005700| 62 65 72 20 69 6e 74 0d | 0a 0d 0a 46 75 6c 6c 20 |ber int.|...Full |
|00005710| 53 79 6e 74 61 78 3a 0d | 0a 25 43 68 69 6c 64 46 |Syntax:.|.%ChildF|
|00005720| 4b 44 65 63 6c 28 3c 6f | 6c 64 20 70 72 65 66 69 |KDecl(<o|ld prefi|
|00005730| 78 3e 2c 3c 6e 65 77 20 | 70 72 65 66 69 78 3e 2c |x>,<new |prefix>,|
|00005740| 3c 73 65 70 61 72 61 74 | 6f 72 3e 29 0d 0a 0d 0a |<separat|or>)....|
|00005750| 46 75 6c 6c 20 53 79 6e | 74 61 78 20 45 78 61 6d |Full Syn|tax Exam|
|00005760| 70 6c 65 3a 0d 0a 25 43 | 68 69 6c 64 46 4b 44 65 |ple:..%C|hildFKDe|
|00005770| 63 6c 28 2c 40 69 6e 73 | 2c 22 2c 20 22 29 0d 0a |cl(,@ins|,", ")..|
|00005780| 45 78 70 61 6e 73 69 6f | 6e 3a 0d 0a 40 69 6e 73 |Expansio|n:..@ins|
|00005790| 5f 6d 61 73 74 65 72 5f | 6e 75 6d 62 65 72 20 69 |_master_|number i|
|000057a0| 6e 74 2c 0d 0a 40 69 6e | 73 5f 6d 6f 76 69 65 5f |nt,..@in|s_movie_|
|000057b0| 63 6f 70 79 5f 6e 75 6d | 62 65 72 20 69 6e 74 00 |copy_num|ber int.|
|000057c0| 25 43 68 69 6c 64 46 4b | 44 65 63 6c 28 2c 40 69 |%ChildFK|Decl(,@i|
|000057d0| 6e 73 29 00 43 68 69 6c | 64 46 4b 00 0b 00 25 43 |ns).Chil|dFK...%C|
|000057e0| 68 69 6c 64 46 4b 28 29 | 00 42 61 73 69 63 20 53 |hildFK()|.Basic S|
|000057f0| 79 6e 74 61 78 3a 0d 0a | 25 43 68 69 6c 64 46 4b |yntax:..|%ChildFK|
|00005800| 28 29 0d 0a 0d 0a 42 61 | 73 69 63 20 53 79 6e 74 |()....Ba|sic Synt|
|00005810| 61 78 20 45 78 61 6d 70 | 6c 65 3a 0d 0a 25 43 68 |ax Examp|le:..%Ch|
|00005820| 69 6c 64 46 4b 28 29 0d | 0a 45 78 70 61 6e 73 69 |ildFK().|.Expansi|
|00005830| 6f 6e 3a 0d 0a 6d 61 73 | 74 65 72 5f 6e 75 6d 62 |on:..mas|ter_numb|
|00005840| 65 72 2c 20 6d 6f 76 69 | 65 5f 63 6f 70 79 5f 6e |er, movi|e_copy_n|
|00005850| 75 6d 62 65 72 2c 2e 2e | 2e 0d 0a 0d 0a 46 75 6c |umber,..|.....Ful|
|00005860| 6c 20 53 79 6e 74 61 78 | 3a 0d 0a 25 43 68 69 6c |l Syntax|:..%Chil|
|00005870| 64 46 4b 28 3c 73 65 70 | 61 72 61 74 6f 72 3e 2c |dFK(<sep|arator>,|
|00005880| 3c 66 75 6e 63 74 69 6f | 6e 3e 2c 3c 70 72 65 66 |<functio|n>,<pref|
|00005890| 69 78 3e 29 0d 0a 0d 0a | 46 75 6c 6c 20 53 79 6e |ix>)....|Full Syn|
|000058a0| 74 61 78 20 45 78 70 61 | 6d 6c 65 3a 0d 0a 25 43 |tax Expa|mle:..%C|
|000058b0| 68 69 6c 64 46 4b 28 22 | 20 6f 72 20 22 2c 75 70 |hildFK("| or ",up|
|000058c0| 64 61 74 65 2c 25 43 68 | 69 6c 64 29 0d 0a 45 78 |date,%Ch|ild)..Ex|
|000058d0| 70 61 6e 73 69 6f 6e 3a | 0d 0a 75 70 64 61 74 65 |pansion:|..update|
|000058e0| 28 4d 4f 56 49 45 5f 52 | 45 4e 54 41 4c 5f 52 45 |(MOVIE_R|ENTAL_RE|
|000058f0| 43 4f 52 2e 6d 61 73 74 | 65 72 5f 6e 75 6d 62 65 |COR.mast|er_numbe|
|00005900| 72 29 20 6f 72 0d 0a 75 | 70 64 61 74 65 28 4d 4f |r) or..u|pdate(MO|
|00005910| 56 49 45 5f 52 45 4e 54 | 41 4c 5f 52 45 43 4f 52 |VIE_RENT|AL_RECOR|
|00005920| 2e 6d 6f 76 69 65 5f 63 | 6f 70 79 5f 6e 75 6d 62 |.movie_c|opy_numb|
|00005930| 65 72 29 2e 2e 2e 00 25 | 43 68 69 6c 64 46 4b 28 |er)....%|ChildFK(|
|00005940| 22 20 6f 72 20 22 2c 75 | 70 64 61 74 65 29 00 43 |" or ",u|pdate).C|
|00005950| 68 69 6c 64 4e 4b 44 65 | 63 6c 00 0c 00 25 43 68 |hildNKDe|cl...%Ch|
|00005960| 69 6c 64 4e 4b 44 65 63 | 6c 28 29 00 42 61 73 69 |ildNKDec|l().Basi|
|00005970| 63 20 53 79 6e 74 61 78 | 3a 0d 0a 25 43 68 69 6c |c Syntax|:..%Chil|
|00005980| 64 4e 4b 44 65 63 6c 28 | 3c 6f 6c 64 20 70 72 65 |dNKDecl(|<old pre|
|00005990| 66 69 78 3e 2c 3c 6e 65 | 77 20 70 72 65 66 69 78 |fix>,<ne|w prefix|
|000059a0| 3e 29 0d 0a 0d 0a 42 61 | 73 69 63 20 53 79 6e 74 |>)....Ba|sic Synt|
|000059b0| 61 78 20 45 78 61 6d 70 | 6c 65 3a 0d 0a 25 43 68 |ax Examp|le:..%Ch|
|000059c0| 69 6c 64 4e 4b 44 65 63 | 6c 28 2c 40 69 6e 73 29 |ildNKDec|l(,@ins)|
|000059d0| 0d 0a 45 78 70 61 6e 73 | 69 6f 6e 3a 0d 0a 40 69 |..Expans|ion:..@i|
|000059e0| 6e 73 5f 72 65 6e 74 61 | 6c 5f 64 61 74 65 20 64 |ns_renta|l_date d|
|000059f0| 61 74 65 74 69 6d 65 2c | 0d 0a 40 69 6e 73 5f 64 |atetime,|..@ins_d|
|00005a00| 75 65 5f 64 61 74 65 20 | 64 61 74 65 74 69 6d 65 |ue_date |datetime|
|00005a10| 2c 2e 2e 2e 0d 0a 0d 0a | 46 75 6c 6c 20 53 79 6e |,.......|Full Syn|
|00005a20| 74 61 78 3a 0d 0a 25 43 | 68 69 6c 64 4e 4b 44 65 |tax:..%C|hildNKDe|
|00005a30| 63 6c 28 3c 6f 6c 64 20 | 70 72 65 66 69 78 3e 2c |cl(<old |prefix>,|
|00005a40| 3c 6e 65 77 20 70 72 65 | 66 69 78 3e 2c 3c 73 65 |<new pre|fix>,<se|
|00005a50| 70 61 72 61 74 6f 72 3e | 29 0d 0a 0d 0a 46 75 6c |parator>|)....Ful|
|00005a60| 6c 20 53 79 6e 74 61 78 | 20 45 78 61 6d 70 6c 65 |l Syntax| Example|
|00005a70| 3a 0d 0a 25 43 68 69 6c | 64 4e 4b 44 65 63 6c 28 |:..%Chil|dNKDecl(|
|00005a80| 2c 40 69 6e 73 2c 22 2c | 20 22 29 0d 0a 45 78 70 |,@ins,",| ")..Exp|
|00005a90| 61 6e 73 69 6f 6e 3a 0d | 0a 40 69 6e 73 5f 72 65 |ansion:.|.@ins_re|
|00005aa0| 6e 74 61 6c 5f 64 61 74 | 65 20 64 61 74 65 74 69 |ntal_dat|e dateti|
|00005ab0| 6d 65 2c 0d 0a 40 69 6e | 73 5f 64 75 65 5f 64 61 |me,..@in|s_due_da|
|00005ac0| 74 65 20 64 61 74 65 74 | 69 6d 65 2c 2e 2e 2e 00 |te datet|ime,....|
|00005ad0| 25 43 68 69 6c 64 4e 4b | 44 65 63 6c 28 40 64 65 |%ChildNK|Decl(@de|
|00005ae0| 6c 2c 40 69 6e 73 29 00 | 43 68 69 6c 64 4e 4b 00 |l,@ins).|ChildNK.|
|00005af0| 0d 00 25 43 68 69 6c 64 | 4e 4b 28 29 00 42 61 73 |..%Child|NK().Bas|
|00005b00| 69 63 20 53 79 6e 74 61 | 78 3a 0d 0a 25 43 68 69 |ic Synta|x:..%Chi|
|00005b10| 6c 64 4e 4b 28 29 0d 0a | 0d 0a 42 61 73 69 63 20 |ldNK()..|..Basic |
|00005b20| 53 79 6e 74 61 78 20 45 | 78 61 6d 70 6c 65 3a 0d |Syntax E|xample:.|
|00005b30| 0a 25 43 68 69 6c 64 4e | 4b 28 29 0d 0a 45 78 70 |.%ChildN|K()..Exp|
|00005b40| 61 6e 73 69 6f 6e 3a 0d | 0a 72 65 6e 74 61 6c 5f |ansion:.|.rental_|
|00005b50| 64 61 74 65 2c 20 64 75 | 65 5f 64 61 74 65 2c 2e |date, du|e_date,.|
|00005b60| 2e 2e 0d 0a 0d 0a 46 75 | 6c 6c 20 53 79 6e 74 61 |......Fu|ll Synta|
|00005b70| 78 3a 0d 0a 25 43 68 69 | 6c 64 4e 4b 28 3c 73 65 |x:..%Chi|ldNK(<se|
|00005b80| 70 61 72 61 74 6f 72 3e | 2c 3c 66 75 6e 63 74 69 |parator>|,<functi|
|00005b90| 6f 6e 3e 2c 3c 70 72 65 | 66 69 78 3e 29 0d 0a 0d |on>,<pre|fix>)...|
|00005ba0| 0a 46 75 6c 6c 20 53 79 | 6e 74 61 78 20 45 78 70 |.Full Sy|ntax Exp|
|00005bb0| 61 6d 6c 65 3a 0d 0a 25 | 43 68 69 6c 64 4e 4b 28 |amle:..%|ChildNK(|
|00005bc0| 22 20 6f 72 20 22 2c 75 | 70 64 61 74 65 2c 25 43 |" or ",u|pdate,%C|
|00005bd0| 68 69 6c 64 29 0d 0a 45 | 78 70 61 6e 73 69 6f 6e |hild)..E|xpansion|
|00005be0| 3a 0d 0a 75 70 64 61 74 | 65 28 4d 4f 56 49 45 5f |:..updat|e(MOVIE_|
|00005bf0| 52 45 4e 54 41 4c 5f 52 | 45 43 4f 52 2e 72 65 6e |RENTAL_R|ECOR.ren|
|00005c00| 74 61 6c 5f 64 61 74 65 | 29 20 6f 72 0d 0a 75 70 |tal_date|) or..up|
|00005c10| 64 61 74 65 28 4d 4f 56 | 49 45 5f 52 45 4e 54 41 |date(MOV|IE_RENTA|
|00005c20| 4c 5f 52 45 43 4f 52 2e | 64 75 65 5f 64 61 74 65 |L_RECOR.|due_date|
|00005c30| 29 20 6f 72 2e 2e 2e 00 | 25 43 68 69 6c 64 4e 4b |) or....|%ChildNK|
|00005c40| 28 22 2c 22 2c 2c 40 69 | 6e 73 29 00 4e 6f 74 6e |(",",,@i|ns).Notn|
|00005c50| 75 6c 6c 46 4b 00 0e 00 | 25 4e 6f 74 6e 75 6c 6c |ullFK...|%Notnull|
|00005c60| 46 4b 28 29 00 42 61 73 | 69 63 20 53 79 6e 74 61 |FK().Bas|ic Synta|
|00005c70| 78 3a 0d 0a 25 4e 75 74 | 6e 75 6c 6c 46 4b 28 3c |x:..%Nut|nullFK(<|
|00005c80| 63 68 69 6c 64 20 74 61 | 62 6c 65 3e 2c 3c 6e 6f |child ta|ble>,<no|
|00005c90| 74 20 6e 75 6c 6c 20 65 | 78 70 72 65 73 73 69 6f |t null e|xpressio|
|00005ca0| 6e 3e 29 0d 0a 0d 0a 42 | 61 73 69 63 20 53 79 6e |n>)....B|asic Syn|
|00005cb0| 74 61 78 20 45 78 61 6d | 70 6c 65 3a 0d 0a 25 4e |tax Exam|ple:..%N|
|00005cc0| 6f 74 6e 75 6c 6c 46 4b | 28 25 43 68 69 6c 64 2c |otnullFK|(%Child,|
|00005cd0| 22 69 73 20 6e 6f 74 20 | 6e 75 6c 6c 20 61 6e 64 |"is not |null and|
|00005ce0| 22 29 0d 0a 45 78 70 61 | 6e 73 69 6f 6e 3a 0d 0a |")..Expa|nsion:..|
|00005cf0| 4d 4f 56 49 45 5f 52 45 | 4e 54 41 4c 5f 52 45 43 |MOVIE_RE|NTAL_REC|
|00005d00| 4f 52 2e 6d 61 73 74 65 | 72 5f 6e 75 6d 62 65 72 |OR.maste|r_number|
|00005d10| 20 69 73 20 6e 6f 74 20 | 6e 75 6c 6c 20 61 6e 64 | is not |null and|
|00005d20| 0d 0a 4d 4f 56 49 45 5f | 52 45 4e 54 41 4c 5f 52 |..MOVIE_|RENTAL_R|
|00005d30| 45 43 4f 52 2e 6d 6f 76 | 69 65 5f 63 6f 70 79 5f |ECOR.mov|ie_copy_|
|00005d40| 6e 75 6d 62 65 72 20 69 | 73 20 6e 6f 74 20 6e 75 |number i|s not nu|
|00005d50| 6c 6c 20 61 6e 64 2e 2e | 2e 0d 0a 0d 0a 46 75 6c |ll and..|.....Ful|
|00005d60| 6c 20 53 79 6e 74 61 78 | 3a 0d 0a 25 4e 6f 74 6e |l Syntax|:..%Notn|
|00005d70| 75 6c 6c 46 4b 28 3c 63 | 68 69 6c 64 20 74 61 62 |ullFK(<c|hild tab|
|00005d80| 6c 65 3e 2c 3c 6e 6f 74 | 20 6e 75 6c 6c 20 65 78 |le>,<not| null ex|
|00005d90| 70 72 65 73 73 69 6f 6e | 3e 2c 3c 70 72 65 66 69 |pression|>,<prefi|
|00005da0| 78 3e 2c 3c 73 65 70 61 | 72 61 74 6f 72 3e 29 0d |x>,<sepa|rator>).|
|00005db0| 0a 0d 0a 46 75 6c 6c 20 | 53 79 6e 74 61 78 20 45 |...Full |Syntax E|
|00005dc0| 78 70 61 6d 6c 65 3a 0d | 0a 25 4e 6f 74 6e 75 6c |xpamle:.|.%Notnul|
|00005dd0| 6c 46 4b 28 69 6e 73 65 | 72 74 65 64 2c 22 69 73 |lFK(inse|rted,"is|
|00005de0| 20 6e 75 6c 6c 22 2c 22 | 77 68 65 72 65 22 2c 22 | null","|where","|
|00005df0| 20 6f 72 22 29 0d 0a 45 | 78 70 61 6e 73 69 6f 6e | or")..E|xpansion|
|00005e00| 3a 0d 0a 77 68 65 72 65 | 0d 0a 20 20 69 6e 73 65 |:..where|..  inse|
|00005e10| 72 74 65 64 2e 6d 61 73 | 74 65 72 5f 6e 75 6d 62 |rted.mas|ter_numb|
|00005e20| 65 72 20 69 73 20 6e 75 | 6c 6c 20 6f 72 0d 0a 20 |er is nu|ll or.. |
|00005e30| 20 69 6e 73 65 72 74 65 | 64 2e 6d 6f 76 69 65 5f | inserte|d.movie_|
|00005e40| 63 6f 70 79 5f 6e 75 6d | 62 65 72 20 69 73 20 6e |copy_num|ber is n|
|00005e50| 75 6c 6c 00 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 25 |ull.%Not|nullFK(%|
|00005e60| 43 68 69 6c 64 2c 22 69 | 73 20 6e 6f 74 20 6e 75 |Child,"i|s not nu|
|00005e70| 6c 6c 20 61 6e 64 22 29 | 00 43 68 69 6c 64 50 61 |ll and")|.ChildPa|
|00005e80| 72 61 6d 44 65 63 6c 00 | 0f 00 25 43 68 69 6c 64 |ramDecl.|..%Child|
|00005e90| 50 61 72 61 6d 44 65 63 | 6c 28 29 00 42 61 73 69 |ParamDec|l().Basi|
|00005ea0| 63 20 53 79 6e 74 61 78 | 3a 0d 0a 25 43 68 69 6c |c Syntax|:..%Chil|
|00005eb0| 64 50 61 72 61 6d 44 65 | 63 6c 28 3c 6f 6c 64 20 |dParamDe|cl(<old |
|00005ec0| 70 72 65 66 69 78 3e 2c | 3c 6e 65 77 20 70 72 65 |prefix>,|<new pre|
|00005ed0| 66 69 78 3e 29 0d 0a 0d | 0a 42 61 73 69 63 20 53 |fix>)...|.Basic S|
|00005ee0| 79 6e 74 61 78 20 45 78 | 61 6d 70 6c 65 3a 0d 0a |yntax Ex|ample:..|
|00005ef0| 25 43 68 69 6c 64 50 61 | 72 61 6d 44 65 63 6c 28 |%ChildPa|ramDecl(|
|00005f00| 2c 40 69 6e 73 29 0d 0a | 45 78 70 61 6e 73 69 6f |,@ins)..|Expansio|
|00005f10| 6e 3a 0d 0a 40 69 6e 73 | 5f 72 65 6e 74 69 6e 67 |n:..@ins|_renting|
|00005f20| 5f 63 75 73 74 6f 6d 65 | 72 20 69 6e 74 2c 0d 0a |_custome|r int,..|
|00005f30| 40 69 6e 73 5f 6d 61 73 | 74 65 72 5f 6e 75 6d 62 |@ins_mas|ter_numb|
|00005f40| 65 72 20 69 6e 74 2c 0d | 0a 40 69 6e 73 5f 6d 6f |er int,.|.@ins_mo|
|00005f50| 76 69 65 5f 63 6f 70 79 | 5f 6e 75 6d 62 65 72 20 |vie_copy|_number |
|00005f60| 69 6e 74 2c 0d 0a 40 69 | 6e 73 5f 72 65 6e 74 61 |int,..@i|ns_renta|
|00005f70| 6c 5f 72 65 63 6f 72 64 | 5f 64 61 74 65 20 64 61 |l_record|_date da|
|00005f80| 74 65 74 69 6d 65 2c 0d | 0a 40 69 6e 73 5f 72 65 |tetime,.|.@ins_re|
|00005f90| 6e 74 61 6c 5f 64 61 74 | 65 20 64 61 74 65 74 69 |ntal_dat|e dateti|
|00005fa0| 6d 65 0d 0a 0d 0a 46 75 | 6c 6c 20 53 79 6e 74 61 |me....Fu|ll Synta|
|00005fb0| 78 3a 0d 0a 25 43 68 69 | 6c 64 50 61 72 61 6d 44 |x:..%Chi|ldParamD|
|00005fc0| 65 63 6c 28 3c 6f 6c 64 | 20 70 72 65 66 69 78 3e |ecl(<old| prefix>|
|00005fd0| 2c 3c 6e 65 77 20 70 72 | 65 66 69 78 3e 2c 3c 73 |,<new pr|efix>,<s|
|00005fe0| 65 70 61 72 61 74 6f 72 | 3e 29 0d 0a 0d 0a 46 75 |eparator|>)....Fu|
|00005ff0| 6c 6c 20 53 79 6e 74 61 | 78 20 45 78 61 6d 70 6c |ll Synta|x Exampl|
|00006000| 65 3a 0d 0a 25 43 68 69 | 6c 64 50 61 72 61 6d 44 |e:..%Chi|ldParamD|
|00006010| 65 63 6c 28 2c 40 69 6e | 73 2c 22 2c 20 22 29 0d |ecl(,@in|s,", ").|
|00006020| 0a 45 78 70 61 6e 73 69 | 6f 6e 3a 0d 0a 40 69 6e |.Expansi|on:..@in|
|00006030| 73 5f 72 65 6e 74 69 6e | 67 5f 63 75 73 74 6f 6d |s_rentin|g_custom|
|00006040| 65 72 20 69 6e 74 2c 0d | 0a 40 69 6e 73 5f 6d 61 |er int,.|.@ins_ma|
|00006050| 73 74 65 72 5f 6e 75 6d | 62 65 72 20 69 6e 74 2c |ster_num|ber int,|
|00006060| 0d 0a 40 69 6e 73 5f 6d | 6f 76 69 65 5f 63 6f 70 |..@ins_m|ovie_cop|
|00006070| 79 5f 6e 75 6d 62 65 72 | 20 69 6e 74 2c 0d 0a 40 |y_number| int,..@|
|00006080| 69 6e 73 5f 72 65 6e 74 | 61 6c 5f 72 65 63 6f 72 |ins_rent|al_recor|
|00006090| 64 5f 64 61 74 65 20 64 | 61 74 65 74 69 6d 65 2c |d_date d|atetime,|
|000060a0| 0d 0a 40 69 6e 73 5f 72 | 65 6e 74 61 6c 5f 64 61 |..@ins_r|ental_da|
|000060b0| 74 65 20 64 61 74 65 74 | 69 6d 65 2c 2e 2e 2e 00 |te datet|ime,....|
|000060c0| 25 43 68 69 6c 64 50 61 | 72 61 6d 44 65 63 6c 28 |%ChildPa|ramDecl(|
|000060d0| 40 64 65 6c 2c 40 69 6e | 73 29 00 50 61 72 65 6e |@del,@in|s).Paren|
|000060e0| 74 50 61 72 61 6d 44 65 | 63 6c 00 10 00 25 50 61 |tParamDe|cl...%Pa|
|000060f0| 72 65 6e 74 50 61 72 61 | 6d 44 65 63 6c 28 29 00 |rentPara|mDecl().|
|00006100| 42 61 73 69 63 20 53 79 | 6e 74 61 78 3a 0d 0a 25 |Basic Sy|ntax:..%|
|00006110| 50 61 72 65 6e 74 50 61 | 72 61 6d 44 65 63 6c 28 |ParentPa|ramDecl(|
|00006120| 3c 6f 6c 64 20 70 72 65 | 66 69 78 3e 2c 3c 6e 65 |<old pre|fix>,<ne|
|00006130| 77 20 70 72 65 66 69 78 | 3e 29 0d 0a 0d 0a 42 61 |w prefix|>)....Ba|
|00006140| 73 69 63 20 53 79 6e 74 | 61 78 20 45 78 61 6d 70 |sic Synt|ax Examp|
|00006150| 6c 65 3a 0d 0a 25 50 61 | 72 65 6e 74 50 61 72 61 |le:..%Pa|rentPara|
|00006160| 6d 44 65 63 6c 28 2c 40 | 69 6e 73 29 0d 0a 45 78 |mDecl(,@|ins)..Ex|
|00006170| 70 61 6e 73 69 6f 6e 3a | 0d 0a 40 69 6e 73 5f 6d |pansion:|..@ins_m|
|00006180| 61 73 74 65 72 5f 6e 75 | 6d 62 65 72 20 69 6e 74 |aster_nu|mber int|
|00006190| 2c 0d 0a 40 69 6e 73 5f | 6d 6f 76 69 65 5f 63 6f |,..@ins_|movie_co|
|000061a0| 70 79 5f 6e 75 6d 62 65 | 72 20 69 6e 74 2c 0d 0a |py_numbe|r int,..|
|000061b0| 40 69 6e 73 5f 67 65 6e | 65 72 61 6c 5f 63 6f 6e |@ins_gen|eral_con|
|000061c0| 64 69 74 69 6f 6e 20 76 | 61 72 63 68 61 72 28 31 |dition v|archar(1|
|000061d0| 30 29 0d 0a 0d 0a 46 75 | 6c 6c 20 53 79 6e 74 61 |0)....Fu|ll Synta|
|000061e0| 78 3a 0d 0a 25 50 61 72 | 65 6e 74 50 61 72 61 6d |x:..%Par|entParam|
|000061f0| 44 65 63 6c 28 3c 6f 6c | 64 20 70 72 65 66 69 78 |Decl(<ol|d prefix|
|00006200| 3e 2c 3c 6e 65 77 20 70 | 72 65 66 69 78 3e 2c 3c |>,<new p|refix>,<|
|00006210| 73 65 70 61 72 61 74 6f | 72 3e 29 0d 0a 0d 0a 46 |separato|r>)....F|
|00006220| 75 6c 6c 20 53 79 6e 74 | 61 78 20 45 78 61 6d 70 |ull Synt|ax Examp|
|00006230| 6c 65 3a 0d 0a 25 50 61 | 72 65 6e 74 50 61 72 61 |le:..%Pa|rentPara|
|00006240| 6d 44 65 63 6c 28 2c 40 | 69 6e 73 2c 22 2c 20 22 |mDecl(,@|ins,", "|
|00006250| 29 0d 0a 45 78 70 61 6e | 73 69 6f 6e 3a 0d 0a 40 |)..Expan|sion:..@|
|00006260| 69 6e 73 5f 6d 61 73 74 | 65 72 5f 6e 75 6d 62 65 |ins_mast|er_numbe|
|00006270| 72 20 69 6e 74 2c 0d 0a | 40 69 6e 73 5f 6d 6f 76 |r int,..|@ins_mov|
|00006280| 69 65 5f 63 6f 70 79 5f | 6e 75 6d 62 65 72 20 69 |ie_copy_|number i|
|00006290| 6e 74 2c 0d 0a 40 69 6e | 73 5f 67 65 6e 65 72 61 |nt,..@in|s_genera|
|000062a0| 6c 5f 63 6f 6e 64 69 74 | 69 6f 6e 20 76 61 72 63 |l_condit|ion varc|
|000062b0| 68 61 72 28 31 30 29 00 | 25 50 61 72 65 6e 74 50 |har(10).|%ParentP|
|000062c0| 61 72 61 6d 44 65 63 6c | 28 40 64 65 6c 2c 40 69 |aramDecl|(@del,@i|
|000062d0| 6e 73 29 00 00 51 00 00 | 00 00 00 00 00 00 00 00 |ns)..Q..|........|
|000062e0| 50 61 72 65 6e 74 00 11 | 00 25 50 61 72 65 6e 74 |Parent..|.%Parent|
|000062f0| 00 42 61 73 69 63 20 53 | 79 6e 74 61 78 3a 0d 0a |.Basic S|yntax:..|
|00006300| 25 50 61 72 65 6e 74 0d | 0a 0d 0a 42 61 73 69 63 |%Parent.|...Basic|
|00006310| 20 53 79 6e 74 61 78 20 | 45 78 61 6d 70 6c 65 3a | Syntax |Example:|
|00006320| 0d 0a 25 50 61 72 65 6e | 74 0d 0a 45 78 70 61 6e |..%Paren|t..Expan|
|00006330| 73 69 6f 6e 3a 0d 0a 4d | 4f 56 49 45 5f 43 4f 50 |sion:..M|OVIE_COP|
|00006340| 59 00 25 50 61 72 65 6e | 74 00 43 68 69 6c 64 00 |Y.%Paren|t.Child.|
|00006350| 12 00 25 43 68 69 6c 64 | 00 42 61 73 69 63 20 53 |..%Child|.Basic S|
|00006360| 79 6e 74 61 78 3a 0d 0a | 25 43 68 69 6c 64 0d 0a |yntax:..|%Child..|
|00006370| 0d 0a 42 61 73 69 63 20 | 53 79 6e 74 61 78 20 45 |..Basic |Syntax E|
|00006380| 78 61 6d 70 6c 65 3a 0d | 0a 25 43 68 69 6c 64 0d |xample:.|.%Child.|
|00006390| 0a 45 78 70 61 6e 73 69 | 6f 6e 3a 0d 0a 4d 4f 56 |.Expansi|on:..MOV|
|000063a0| 49 45 5f 52 45 4e 54 41 | 4c 5f 52 45 43 4f 52 00 |IE_RENTA|L_RECOR.|
|000063b0| 25 43 68 69 6c 64 00 4a | 6f 69 6e 46 4b 50 4b 00 |%Child.J|oinFKPK.|
|000063c0| 13 00 25 4a 6f 69 6e 46 | 4b 50 4b 28 29 00 42 61 |..%JoinF|KPK().Ba|
|000063d0| 73 69 63 20 53 79 6e 74 | 61 78 3a 0d 0a 25 4a 6f |sic Synt|ax:..%Jo|
|000063e0| 69 6e 46 4b 50 4b 28 3c | 63 68 69 6c 64 20 74 61 |inFKPK(<|child ta|
|000063f0| 62 6c 65 3e 2c 3c 70 61 | 72 65 6e 74 20 74 61 62 |ble>,<pa|rent tab|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.