Bug Report: SQL Window and single record

ScottMattes

Member³
I just printed the single record view of my query and got weird results.

There are 22 fields in the result set, but when I printed the record fields 22 and 20 were blank and the contents of field 20 was in field 21's place.

The query and the single record all fit on one page.

The grid is printed like expected.

This is what I see

screen paper
a 1 a 1
b 1 b 1
c 1 c 1
d 1 d 1
e 1 e 1
f 1 f 1
g 1 g 1
h 1 h 1
i 1 i 1
j 1 j 1
k 1 k 1
l 1 l 1
m 1 m 1
n 1 n 1
o 1 o 1
p 1 p 1
q 1 q 1
r 1 r 1
s 1 s 1
t 1
u 1 t 1
v 1
 
I cannot reproduce this. Do you have a reproducible case? If so, can you send me the table definition and query?
 
Alas I can't send anything about the actual problem, but I'll see if I can create a reproduceable version.

Looking through the trash can for the output I found another where field 20 of 21 was missing. I notice that in that one I had sorted the fields in descending order (in case that is a clue).
 
Back
Top