>When I ran this from the command window as a normal sql statement, with tables open, it returned some values, but when I ran the same using SQL Pass Through, it returned different values for the same fields. Are there any concers about the functionality available in each mode?
>
>What am I doing Wrong?
>
>TIA.
>
>SELECT PRODUCTO ,;
>SUM(IIF(MONTH(FACTURAS.FECHA)=1,CANTIDAD*IIf(FACTURAS.Tipodcto='NC' ,-1,1),0)) AS CANTIDAD_ENERO ,;
>SUM(IIF(MONTH(FACTURAS.FECHA)=2,CANTIDAD*IIf(FACTURAS.Tipodcto='NC' ,-1,1),0)) AS CANTIDAD_FEBRERO ;
>FROM MVTOFAC INNER JOIN FACTURAS ON MVTOFAC.FACTURA = FACTURAS.FACTURA ;
>GROUP BY 1 ;
>WHERE NOT INLIST(FACTURAS.LOGIN,"BEXPORTA") AND INLIST(FACTURAS.TIPODCTO,"FA","NC","FR") AND BETWEEN(FACTURAS.FECHA,{01/03/2000},{01/02/2001}) AND NOT MVTOFAC.SERVICIO into cursor xyz
When you send this sql passthrough, what is the back end?
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California