home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
lan
/
xql211.arj
/
NPATVAP.211
< prev
next >
Wrap
Text File
|
1991-03-21
|
10KB
|
609 lines
. patch #15 fixes problems with MIN/MAX on autoinc field
a cs:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a DS:d86c
PUSH BX
MOV BX,[BP+0E]
MOV DX,[BP+10]
MOV SI,[BP+12]
MOV DI,AX
DEC DI
JZ D887
CMP DI,+0E
JZ D887
CMP DI,+08
JZ D8DF
JMP D8CD
a DS:D8CD
DEC DI
JZ D8A8
. end patch #15
. patch #16 - fixes GPI from scalar function and subst. var.
. in a restriction
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 38 01 1c 03 87 18 24 06 00 00 ff ff 00 00
a ds:8406
;patch 16a - in SetTypeForVar
push cs
mov bx, [15f]
push bx
mov bx, 2b1
push bx
es:
mov bx, [si]
cmp bx, 0
jge 841a
neg bx
retf
nop
a ds:8449
; patch 16b - in SetTypeForVar
push cs
mov cx, [15f]
push cx
mov cx, 2d3
push cx
retf
a cs:100
mov ax,cs
add ax, 4000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 38 01 1c 03 87 18 24 06 00 00 ff ff 00 00
a ds:c74c
; patch 16c - in Substex
mov ax,bx
mov dx,es
nop
nop
nop
nop
a cs:65f1
;patch 16a
cmp bx, 100
je 6609
cmp bx, 306
je 6609
cmp bx, 301
je 6609
cmp bx, 304
jne 660e
mov bx, 260c
push bx
retf
mov bx, 262a
push bx
retf
;patch 16b
es:
mov ax,[si+a]
cmp ax,ffff
je 6628
es:
mov dx,[si+c]
mov bx,[bp-6]
mov cx, 2644
push cx
retf
mov cx, 264b
push cx
retf
. end of patch #16
. patch #18 fixes data truncation in INSERT INTO...SELECT
a cs:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:AFCD
JMP AFED
. end of patch #18
. patch #20
. xDescribe (option 3) does not return secondary field count if the
. join type is cartesion product join.
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 38 01 1c 03 87 18 24 06 00 00 ff ff 00 00
a ds:efda
les bx, [bp-c]
es:
mov ax,[bx]
mov [bp-4],ax
es:
mov ax,[bx+2]
mov [bp-2],ax
es:
add word ptr [bx],2
les bx, [bp+e]
es:
add word ptr [bx],2
es:
mov ax,[bx]
cmp ax,[bp+12]
jl f002
mov word ptr [bp-18],d2
les bx, [bp-10]
es:
mov si,[bx+33]
es:
mov di,[bx+35]
es:
cmp byte ptr [bx+4],2
je f03e
. end of patch #20
. patch #22 - ddExtend with record sizes 511 and 512 return status 28
a cs:100
mov ax,cs
add ax,3000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:1c5b
; patch 22 - in ddExtend
push cs
mov ax, [15f]
push ax
mov ax, 2ed
push ax
retf
nop
a cs:662d
;patch 22
add si,6
cmp si,[bp - 1c]
jle 663b
add byte ptr [bp - 1b],2
jmp 6630
sub si,6
mov ax, c3e6
push ax
retf
. 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 4d 5a 38 01 1c 03 87 18 24 06 00 00 ff ff 00 00
a ds:cca0
; CnvrtAscii
push cs
mov bx, [15f]
push bx
mov bx,32d
push bx
retf
a cs:666d
cmp al,2
jne 6676
mov bx,6f31
jmp 66a0
cmp al,5
je 6682
cmp al,6
je 6682
cmp al,8
jne 6687
mov bx,6f78
jmp 66a0
cmp al,9
jne 6690
mov bx,70ca
jmp 66a0
cmp al,f
je 6698
cmp al,1
jne 669d
mov bx,6ea2
jmp 66a0
mov bx,70f3
push bx
retf
. 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, 4000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 38 01 1c 03 87 18 24 06 00 00 ff ff 00 00
a ds:435f
push cs
mov bx, [15f]
push bx
mov bx, 303
push bx
retf
nop
nop
a cs:6643
;patch 24
MOV BX, ebec ; offset to L15 - 7
PUSH BX
mov es, [bp-48]
mov bx, [bp-46]
es:
cmp byte ptr [bx+6], b
jne 666c
push cx ; strlen
push di
push es
mov di,[bp-4a]
mov es,[bp-4c]
mov cx,ffff
xor ax,ax
repne scasb
not cx
dec cx
mov ax,cx
pop es
pop di
pop cx
retf
. 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 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:fe17
push cs
mov ax, [15f]
push ax
mov ax, 3c3
push ax
retf
nop
nop
a cs:6703
;patch 25
MOV AX, a014 ; offset to L84
PUSH AX
test bx,bx
jz 6717
lea si,[bp-22]
les ax,[si+6]
add bx,ax
es:
inc byte ptr [bx-1]
retf
. 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, 5000
mov ds, ax
r sp
110
g =100 107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
.
. DELETE THE SEMI-COLON FROM THE BEGINNING OF THE FOLLOWING LINES TO
. ENABLE PATCH.
;e DS:c342 2c
;a cs:100
;mov ax,cs
;add ax,3000
;mov ds, ax
;r sp
;110
;g =100 107
;e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
;e DS:adf7 2c
;e DS:ae2f 2c
;e DS:3d53 2c
;e DS:3d9d 2c
. end of patch #26
.
. patch #27 VAP GPI's when workstation is rebooted while a session
. is still active.
a c0bd
mov ax, [15f]
push ax
mov ax, 362
push ax
retf
a 66a2
mov word ptr[4de],-1
xor ax,ax
db c9
pop di
pop es
pop si
pop cx
retf
. end of patch #27
. patch #29 Fixes problems removing supplemental indexes.
a 66b0
LEA BX,[BP-10]
ES:
MOV AX,[SI]
CMP AX,[BX]
JNZ 66C5
TEST BYTE PTR [BX+08],80
JZ 66CA
MOV AX,CD81
JMP 66CD
MOV AX,CDA9
JMP 66CD
MOV AX,CDA4
PUSH AX
RETF
a cs:100
mov ax,cs
add ax, 3000
mov ds, ax
r sp
110
g =100 107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a DS:25f3
PUSH CS
MOV BX,[015F]
PUSH BX
MOV BX,0370
PUSH BX
RETF
NOP
NOP
NOP
. end of patch #29
. patch #30 prevents server GPI for equal comparisons of fields
. of different sizes from different files.
a cs:100
mov ax,cs
add ax, 2000
mov ds, ax
r sp
110
g =100 107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
e DS:9c27 08
a DS:9c5b
ES:
CMP DX,[SI+04]
JA 9C70
MOV BX,[BP+14]
OR BX,[BP+16]
JNZ 9C70
NOP
NOP
. 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 - GPI's server
. - 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, 4000
;mov ds, ax
;r sp
;110
;g =100 107
;e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
;a ds:4469
;jmp 4488
. end of patch #32
.
. 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 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:6c0e
push cs
mov bx, [15f]
push bx
mov bx,38f
push bx
retf
test ax,ax
jne 6c7a
nop
nop
nop
nop
a 66cf
pop bx
push bx
mov ax,cs
push ax
mov ax,3ab
push ax
push bx
mov ax, 1307
push ax
lea bx,[bp-a]
mov cx,ds
es:
mov ax,[si+a]
es:
mov dx,[si+c]
retf
mov dx,ax
mov ax,1399
push ax
xor ax,ax
cmp word ptr [bp-6],110
je 6701
cmp word ptr [bp-6], 111
jne 6702
inc ax
retf
. end of patch #34
. patch #36 Owner name ignored on xRecall
a cs:100
mov ax,cs
add ax,1000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
e ds:a927 90 90 90
. end of patch #36
. patch #40 Field to field comparisons may not return correct records.
a cs:100
mov ax,cs
add ax,2000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:9bf2
jmp 9c76
. end of patch #40
. patch #41 XQLFormat sets display size incorrectly for number masks
a cs:100
mov ax,cs
add ax,4000
mov ds,ax
r sp
110
g =100,107
e cs:100 4D 5A 38 01 1C 03 87 18 24 06 00 00 FF FF 00 00
a ds:ae90
mov ax,[bp-8]
jmp aead
. end of patch #41
. END OF PATCH FILE FOR NW$SQL.VP0
. DO NOT REMOVE THE NEXT TWO LINES!!
w
q