What source? FoxPro, Sybase, Oracle...?


>I´m using a connection to an Odbc Source.
>SQL PT looks like:
>Cn = SqlConnect(Mysource)
>sqlstatement = "select producto....."
>SqlExec(cn,SqlStatement,Mycursor)
>
>>>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?