home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
lan
/
sql211.arj
/
NPATNLM.211
< prev
next >
Wrap
Text File
|
1991-01-22
|
13KB
|
656 lines
.
. beginning of patch #1 - incorrect status 43
.
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:62fc eb 35
.
. end of patch #1
.
. beginning of patch #2 - incorrect status 49
.
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:d3f6 f6 40 14 04 74 0b 80 60 14 fb 90 90 90
.
. end of patch #2
. beginning of patch #3 - Abend on CREATE VIEW statement
.
a CS:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:6145 e6 7
e ds:68a5 fc 7
e ds:cb80 e6 7
e ds:cbbd e6 7
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:961b ee 7
e ds:9622 e6 7
e ds:966b 02 8
e ds:9713 fc 7
e ds:9874 e2 7
e ds:98b5 fc 7
e ds:9abe fc 7
e ds:9d2c fc 7
e ds:a33f 02 8
e ds:a349 fc 7
e ds:ba39 8b 9e ae 01 0 0
e ds:ba56 8b 9e ae 01 0 0
e ds:ba76 8b 8e ae 01 0 0
e ds:ba9e cc 7
e ds:badf e6 7
e ds:bae7 8b 86 ae 01 0 0
e ds:bb1f 8b 96 ae 01 0 0 83 c2 16 eb 7 90 90 e8 0 0 0 0 66 89 2
e ds:bb3b 8b 96 ae 01 0 0
e ds:bb6f 8b 8e ae 01 0 0
e ds:c7fa e6 7
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:89a2 d0 7
.
. end of patch #3
. beginning of patch #4 - descending keys
.
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:2080 66 85 db 74 1d eb 12
.
. end of patch #4
. beginning of patch #5 - ALTER TABLE with ZSTRING or LSTRING
.
e cs:fe4e e8 8a 9c 03 00 90 90 90 90 90
e cs:d15e 66 83 7d 42 00 74 0d e8 ca c9 03 00 85 c0 74 77 51 51 eb 66
e cs:ddeb 03
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9ad6 66 83 7d 72 03 75 42 8b 45 de 80 78 14 0a 75 0c
e ds:9ae6 8b 45 ee 0f b6 00 c6 04 07 00 eb 2d 80 78 14 0b
e ds:9af6 75 27 56 57 8b 7d ee 06 8c d8 8e c0 29 c9 49 31
e ds:9b06 c0 f2 ae f7 d1 49 07 41 8b 75 ee 8b 7d e6 d1 e9
e ds:9b16 66 f2 a5 11 c9 f2 a4 5f 5e 8b 45 de 66 8b 48 1b
e ds:9b26 8b 45 e6 89 45 e2 c3 80 7e 14 0a 74 16 80 7e 14
e ds:9b36 0b 74 10 8b 8d 6a fe ff ff 83 c1 64 b8 01 00 00
e ds:9b46 00 eb 02 31 c0 c3
.
. end of patch #5
.
. beginning of patch #6 - Return error on invalid stored SQL statement
.
e cs:e20e 66 83 7e 04 00 0f 85 d8 03 00 00 e8 35 b9 03 00
e cs:e5fc e8 61 b5 03 00 90
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9b4c 66 8b 46 58 66 89 45 fc 0f bf 4d f8 89 f0 c3
e ds:9b5b 66 83 7e 04 00 75 04 66 89 46 58 89 f0 c3
. end of patch #6
.
. beginning of patch #7 - Statement returns status code 809
.
e cs:75b5 eb 27 90 90 90 90
e cs:760e 3d
.
. end of patch #7
.
. beginning of patch #8 - Default Bfloat mask should have 2 exp
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:3dfa 75 08 80 78 06 02 75 02 66 4a 0f bf c2 03 45 f8
e ds:3e0a c6 00 2b 48 90 90 90
.
. end of patch #8
.
. beginning of patch #9 - xRemall problem
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:a857 e8 14 f3 00 00
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9b69 01 c2 89 55 1e 83 7d 32 0 75 06 c7 02 ff ff ff ff c3
.
. end of patch #9
.
. beginning of patch #10 Invalid dates
a CS:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:3e41 0
e ds:3e4e 0
.
. end of patch #10
.
. beginning of patch #11 Invalid syntax for time arithmetic
a CS:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:5eb6 66 83 7d f8 04 74 23 66 81 ff 13 01 0f 84 5b ff
e ds:5ec6 ff ff 90 90 90 90 90 90 90 90 90 90 90
.
. end of patch #11
. beginning of patch #12 XQLFetch previous problem
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:64d3 8b 86 43 03 00 00 6a 00 50 e8 a7 09 01 00 83 c4 08 eb 0d
e ds:64e6 90 90 90 90 90 90 90 90 90 90 90 90 90
.
. End of patch #12
.
. beginning of patch #13 Prevents overwrite of low memory
.
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:6222 c7 43 3a ff ff ff ff 66 c7 43 32 ff ff 66 c7 43 62 01 00
e ds:6235 c7 83 83 01 00 00 05 00 0a 00 8b 82 7a 01 00 00 89 42 16 90 90 90 90
.
. End of patch #13
.
. beginning of patch #15. Incorrect results for min/max on autoinc field
e cs:18ca 8a 65 f8 fe cc 74 1b fe cc 74 34 80 fc 0d 7f 68
e cs:18da 74 10 80 fc 07 74 53 eb 3d 90 90 90 90 90 90 90 90 90
. end of patch #15
.
.
. beginning of patch #16. Scalar function with substitution variable.
.
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:1fe6 8b d7 90
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:b4e0 e8 9d e6 00 00 85 c9 74 1a 90 80 78 11 01 75 37
e ds:b4f0 3a 50 08 75 32 8a 55 fc 88 50 08 8a 55 f8 88 50
e ds:b500 09 eb 24 0f bf 4d f8 0f bf 5d fc 8b 56 06 89 f8
e ds:b510 e8 9f ff ff ff 8b 56 0a 83 fa ff 74 0a e8 88 e6
e ds:b520 00 00 e8 8d ff ff ff
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9b7b 66 81 fb 00 01 74 18 66 81 fb 06 03 74 11 66 81
e ds:9b8b fb 01 03 74 0a 66 81 fb 04 03 74 03 33 c9 c3 b9
e ds:9b9b 01 00 00 00 8b 46 06 c3 0f bf 4d f8 0f bf 5d fc
e ds:9bab 89 f8 c3
. end of patch #16
.
. beginning of patch #17. Changes magic pointer size by 2 in stproc
.
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:613f 52
e ds:7408 52
. end of patch #17
.
. beginning of patch #18 fixes data truncation in INSERT INTO...SELECT
.
e cs:d443 eb 13
end of patch #18
. beginning of patch #19. status 109 on fetch distinct
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9bae 8b 56 06 8a 42 20 66 33 d2 32 e4 66 48 74 14 66
e ds:9bbe 48 74 10 66 48 74 06 66 48 74 02 eb 0c 66 83 ff
e ds:9bce 02 74 12 66 83 ff 03 74 0c 66 83 ff 01 74 06 66
e ds:9bde 83 ff 04 75 02 66 42 c3
e cs:4fb e8 5f 97 04 00 66 85 d2 74 31 90 90
e ds:9c58 53 8b 16 0f b7 52 08 89 f0 bb 01 00 00 00 e8 13
e ds:9c68 f8 fc ff e8 3e ff ff ff 5b c3
. end of patch #19
. patch #20 Secondary field count not returned by xDescribe
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:e5ed 8b 45 42 8b 00 89 45 46 8b 45 42 83 00 02 8b 45
e ds:e5fd 3e 66 83 00 02 66 8b 00 66 3b 45 7e 7c 04 66 bb
e ds:e60d d2 00 80 78 04 02 0f 84 ab 00 00 00
. end of patch #20
.
. beginning of patch #22 - status 28 returned by ddExtend
.
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:d08c e8 5c cb 02 00 66 85 c0 74 06
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9be6 66 8b 45 12 66 05 06 00 66 3b 45 1a 7e 05 66 b8
e ds:9bf6 01 00 c3 66 b8 00 00 c3
.
. end of patch #22
.
. patch #23 Autoinc field on INSERT INTO subquery
.
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:ae56 90 3c 0d 0f 8f 0b 02 00 00 74 1e 90 3c 07
e ds:ae64 0f 84 e3 01 00 00 e9 b1 00 00 00
e ds:ae6f 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90
. end of patch #23
. patch #24 GPI from xValidate for ZSTRING to be checked
. which is smaller than size indicated in data buffer size
. parameter
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:0251 e8 af 99 01 00 90
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9bfe 80 7e 06 0b 75 19 51 57 06 8b 7d d4 8c d8 8e c0
e ds:9c0e 29 c9 49 31 c0 f2 ae f7 d1 49 89 c8 07 5f 59 c3
. end of patch #24
. patch #25 - When searching for all values in a ZSTRING field
. on a BEGINS WITH restriction all records that
. begin with all but the last chracter in the
. specified string are returned.
. If want records that begin with 'abc' then all
. records beginning with 'ab' are returned.
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:f106 03 45 e6 48 fe 00 90
. end of patch #25
. ===========================
. patch #26 *** OPTIONAL ***
.
. Allows use of european format of decimal comma instead of decimal
. point.
.
. This patch is NOT applied unless this patch file is modified.
.
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
. DELETE SEMI-COLON AT THE BEGINNING OF THE FOLLOWING LINES TO ENABLE PATCH.
;e DS:85a4 2c
;a CS:100
;mov ax,cs
;add ax,1000
;mov ds,ax
;r sp
;110
;g =100 107
;e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
;e ds:1e7a 2c
;e ds:1ea1 2c
;e cs:5eaf 2c
;e cs:5f08 2c
. end of patch #26
. patch #29 Fixes problems removing supplemental indexes
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e DS:9c1e 66 30 c0 f6 45 f0 80 74 0b 66 8b 1f 66 3b 5d e8
e DS:9c2e 75 02 66 40 c3
a CS:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e DS:db03 e8 1d c1 02 00 66 85 c0 74 23 90 90
. end of patch #29
.
. patch #30 fixes problem with equal comparison of string fields
. of different sizes from different files.
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e DS:901d 08
e DS:9051 66 3b 48 04 77 0e 83 7d 20 00 75 08 90 90 90 90
. end of patch #30
. patch #32 - *** OPTIONAL ***
. - xValidate causing memory to be over written
. when an invalid field value is given and a view
. has not yet been created
. - if this patch is applied, a view is created
. and an invalid field value is given then the
. XQLStatus will not provide the field name associated
. with the invalid value
.
.
. This patch is NOT applied unless this patch file is modified.
.
.
. DELETE THE SEMI-COLON FROM THE BEGINNING OF THE FOLLOWING LINES TO
. ENABLE PATCH.
;a cs:100
;mov ax,cs
;add ax, 3000
;mov ds, ax
;r sp
;110
;g =100 107
;e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
;e ds:0332 eb 16
. end of patch #32
.
. beginning of patch #33 - Crash on delete of LVAR or NOTE record
.
a CS:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9e6 39 c1 7e 26 29 c1 0f b7 56 10 8b 45 f0 8b 40 22
e ds:9f6 01 c2 0f bf 45 f4 8d 3c 02 30 c0
e ds:a0c 90 90
.
. end of patch #33
.
. patch #34 Status 328 on xRestrict
a CS:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:5e5b e8 da 3d 02 00 66 85 c0 75 0a 90 90 90 90 90 90 90
a CS:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:9c33 8b 56 0a 8b 45 f4 8d 5d fc e8 a1 c1 fd ff 66 8b
e ds:9c43 d8 66 33 c0 66 81 ff 10 01 74 07 66 81 ff 11 01
e ds:9c53 75 02 66 40 c3
. end of patch #34
. patch #36 Owner name ignored by xRecall
a CS:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100 107
e CS:100 4e 65 74 57 61 72 65 20 4c 6f 61 64 61 62 6c 65
e ds:94ac 90 90
. end of patch #36
. END OF PATCHES FOR NWSQL.NLM ver 2.11
. DO NOT REMOVE THESE NEXT TWO LINES !!!!!!
w
q