home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
lan
/
xql211.arj
/
XQLP.211
< prev
next >
Wrap
Text File
|
1991-03-21
|
8KB
|
503 lines
. 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 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:d0fb
mov bx,[bp-16]
mov bx,[bx]
mov [bp-4],bx
mov bx,[bp-16]
mov ax,[bx+2]
mov [bp-2],ax
add word ptr [bx],2
mov bx,[bp-82]
add word ptr [bx],2
mov ax,[bx]
cmp ax,[bp-84]
jl d123
mov word ptr [bp-c],d2
mov bx,[bp-e]
mov si,[bx+2d]
cmp byte ptr [bx+4],2
je d154
cmp word ptr [bp-c],0
. end of patch #20
. patch #22 - ddCreate with record sizes 512 and 511 return status 28
a cs:9ad0
;patch 22 - in ddextend
mov bx, cs
sub bx, 63f
push bx
mov bx, 242
push bx
retf
nop
nop
a cs:3342
;patch 22
MOV BX,CS
ADD BX,63f ; diff to seg of ddextend
PUSH BX
MOV BX,5ee ; offset to L63
PUSH BX
mov ax,[bp-1a]
add ax,6
cmp ax,[bp-16]
jle 335e
add byte ptr [bp-15],2
jmp 3353
retf
. end of patch #22
.
. patch #23 Autoinc field on INSERT INTO subquery
a b75a
push cs
mov bx,cs
sub bx,84a
push bx
mov bx,25f
push bx
retf
nop
nop
a 335f
cmp al,2
jne 3368
mov bx,23f
jmp 3392
cmp al,5
je 3374
cmp al,6
je 3374
cmp al,8
jne 3379
mov bx,274
jmp 3392
cmp al,9
jne 3382
mov bx,388
jmp 3392
cmp al,f
je 338a
cmp al,1
jne 338f
mov bx,1cc
jmp 3392
mov bx,3aa
push bx
retf
. end of patch #23
.
. patch #24 status 282 from xValidate for ZSTRING to be checked
. which is smaller than size indicated in data buffer size
. parameter
a cs:ea74
mov bx, cs
sub bx, 0b0b
push bx
mov bx, 294
push bx
retf
nop
mov bx,[bp-38]
a cs:3394
;patch 24
MOV BX,CS
ADD BX,0b0b ; diff to seg of validdata
PUSH BX
MOV BX,8d1 ; offset to L13 - 3
PUSH BX
mov bx, [bp-38]
cmp byte ptr [bx+6], b
jne 33bc
mov ax, word ptr [bp - 3a] ; call strlen
push cs
mov bx, 2bc
push bx
mov bx, cs
add bx, 27a3
push bx
mov bx, 5a
push bx
retf
cmp byte ptr [bx+6], c
jne 33c3
dec ax
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 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:f780
mov bx, cs
sub bx, 1c0a
push bx
mov bx, 2f4
push bx
retf
nop
a cs:33f4
;patch 25
MOV BX,CS
ADD BX,1c0a ; diff to seg of cmpValues
PUSH BX
MOV BX,5ed ; offset to L79
PUSH BX
test dx,dx
jz 340f
cmp dx,ax
ja 340f
mov bx, [bp-16]
add bx, dx
dec bx
inc byte ptr [bx]
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, 2000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
. DELETE THE SEMI-COLON FROM THE BEGINNING OF THE NEXT LINE TO ENABLE PATCH.
;e ds:bf32 2c
. end of patch #26
. patch #29 Fixes problems removing supplemental indexes
a cs:a251
mov al,20
mov dx,si
mov bx,[bp-30]
a cs:a1e6
push ax
nop
a cs:a264
mov di,[si]
mov [bp-2],di
a cs:a28f
cmp di,[bp-2]
jne a2bb
test byte ptr [bp-6], 80
je a2b6
a cs:a2bb
pop ax
nop
. end of patch #29
. patch #30 prevents workstation from crashing when restrict
. contains equal comparisons of string fields
. of different sizes from different files.
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:531d
mov al, [di+8]
a ds:534d
cmp word ptr [bp+e], 0
jne 535b
nop
nop
nop
nop
nop
a ds:5338
ja 535b
cmp dx,bx
jne 535b
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
. - 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:eb33
;jmp eb45
. 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 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:477c
mov ax,cs
push ax
sub ax,2092
push ax
mov ax,2c4
push ax
retf
a cs:33c4
MOV AX,CS
PUSH AX
MOV ax,2dc
PUSH ax
mov ax,cs
ADD AX,2092
PUSH AX
MOV AX,0CF8
PUSH AX
MOV AX,[SI+06]
LEA DX,[BP-04]
RETF
MOV DX,AX
CMP CX,0110
JZ 33ea
CMP CX,0111
JNZ 33ef
MOV AX,def
JMP 33f2
MOV AX,d68
PUSH AX
RETF
. end of patch #34
.
. patch #35 EMS conflict between Btrieve and XQL
a 4872
mov es,bx
mov ah,49
int 21
es:
mov bx,[2c]
mov es,bx
mov ah,49
int 21
cs:
mov bx,[12]
cs:
mov dx,[10]
a 3825
cs:
call far [10]
a 3622
cs:
call far [10]
a 48e3
cmp al,33
je 48ec
mov ax,3c6
jmp 493c
mov ax,[d7e]
mov es,ax
mov ax,[ef6]
es:
mov [12],ax
mov ax,[eea]
es:
mov [10],ax
. end of patch #35
. beginning of patch #36 - Owner name ignored by xRecall
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
e ds:a166 90 90
. end of patch #36
.
. beginning of patch #37 - xUpdall does not work with BREQUEST
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:7a7d
mov cx,21
jmp 7a8b
. end of patch #37
.
. patch #38 *** OPTIONAL ***
.
. patch to allow XQL to process requests from Windows interface
.
. DELETE THE SEMI-COLON FROM THE BEGINNING OF THE FOLLOWING LINES TO
. ENABLE PATCH.
.
;e cs:4b89 30
.
;a 35f1
;jmp 3410
;cs:
;a 3410
;cmp si,6666
;jne 341c
;cmp di,bbbb
;je 3428
;cmp si,5555
;jne 342a
;cmp di,aaaa
;jne 342a
;mov ds,ax
;mov si,dx
;push cs
;pop es
;jmp 35f4
. end of patch #38
. patch #40 Field to field comparisons may not return correct records
a cs:100
mov ax,cs
add ax, 1000
mov ds, ax
r sp
110
g =100 107
e cs:100 4d 5a 20 00 67 01 ec 0b 00 03 a2 00 ff ff e4 29
a ds:4979
mov si,cs
push si
sub si, 1170
push si
mov si, 310
push si
retf
a cs:3410
mov cx,[bx+5]
and cx,0040
jne 341e
mov cx,[bx+1]
jmp 3421
mov cx,2
add cx,7
add ax,cx
add bx,cx
dec dx
mov si, 189
push si
retf
a ds:53bf
XOR AX,AX
JMP 53C8
MOV AL,[DI+08]
XOR AH,AH
MOV DI,[BP-16]
MOV BX,[BX+04]
MOV [DI],AL
INC DI
MOV [DI],BX
INC DI
INC DI
MOV [BP-16],DI
MOV DI,[BP-10]
MOV BX,[DI+06]
MOV DI,[BP-16]
MOV [DI],BX
ADD WORD PTR [BP-16],+02
NOP
NOP
NOP
. end of patch #40
. END OF PATCH FILE FOR XQLP.EXE
. DO NOT REMOVE THE NEXT TWO LINES!
w
q