Hi,

The following query endS with different result sets if you use interclient or the new typ4 driver.

SELECT A.CODIGO, A.DESCRIPCION, A.SUBRUBRO,
     SUM(S.CANTIDAD) AS STOCK, SUM(R.CANTIDAD) AS VENTAS
FROM ARTICULOS A
    JOIN STOCK S ON S.ARTICULO = A.CODIGO
    JOIN ROTACION R ON R.ARTICULO = A.CODIGO
WHERE A.PROVEEDOR = 'UNI'
GROUP BY A.CODIGO, A.DESCRIPCION, A.SUBRUBRO
ORDER BY A.DESCRIPCION

With interclient I get 2445 rows, but with the new driver only 6 rows are retrieved.

I wrote a simple program using the type 4 driver and was worried because the result seemed incredible. Then I switched the connection URL and driver name and automagically all the data appeared on screen. The rest of the program remained untouched, only the driver name and URL.

Can anybody tell me what's wrong?

Thanks,

Rodolfo

-- 

 MAXPROGRAMS
 IBM Business Partner
 Microsoft MSDN Business Connection Partner
 rmraya@...
 http://www.maxprograms.com