|Subject||Different results between Interclient and Typ4 driver|
|Author||Rodolfo M. Raya|
The following query endS with different result sets if you use interclient or the new typ4 driver.
SELECT A.CODIGO, A.DESCRIPCION, A.SUBRUBRO,With interclient I get 2445 rows, but with the new driver only 6 rows are retrieved.
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
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?
-- MAXPROGRAMS IBM Business Partner Microsoft MSDN Business Connection Partner rmraya@... http://www.maxprograms.com