*!* CREATE CURSOR tt(N1 I,N2 I,N3 I,N4 I,N5 I,N6 I,N7 I,N8 I)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (1,1,1,1,1,1,1,1)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (2,2,2,2,2,2,2,2)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (3,3,3,3,3,3,3,3)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (4,4,4,4,4,4,4,4)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (5,5,5,5,5,5,5,5)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (6,6,6,6,6,6,6,6)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (7,7,7,7,7,7,7,7)
*!* INSERT INTO tt(n1,n2,n3,n4,n5,n6,n7,n8) VALUES (8,8,8,8,8,8,8,8)
IF USED("TT")
SELECT TT
ELSE
USE d:\TT.DBF IN 0
ENDIF
S1=SECONDS()
SELECT INT(T1.N1*10000000 + T2.N2*1000000 + T3.N3*100000 + T4.N4*10000 + T5.N5*1000 + T6.N6*100 + T7.N7*10 + T8.N8) AS NN ;
FROM (SELECT N1 FROM tt WHERE N1<8) as t1 ,;
(SELECT N2 FROM tt WHERE N2<8) as t2 ,;
(SELECT N3 FROM tt WHERE N3<8) as t3 ,;
(SELECT N4 FROM tt WHERE N4<8) as t4 ,;
(SELECT N5 FROM tt WHERE N5<8) as t5 ,;
(SELECT N6 FROM tt WHERE N6<8) as t6 ,;
(SELECT N7 FROM tt WHERE N7<8) as t7 ,;
(SELECT N8 FROM tt WHERE N8<8) as t8 ;
INTO CURSOR T9 READWRITE
?SECONDS()-S1,RECCOUNT()
BROWSE
IF USED("TT")
USE IN TT
ENDIF