Skip to Content
0
Former Member
Jun 09, 2009 at 08:40 PM

JDBC Adapter Sender - problem

21 Views

Guys,

Im trying to execute one select command from Oracle in jdbc adapter sender, but the one return full result (no filter by where)

Example:

SELECT * FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P' AND CD_CORTE BETWEEN (SELECT MIN(CD_CORTE) FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') AND (SELECT MIN(CD_CORTE) +150 FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') order by cd_nota_debito

The sql command execute SELECT * FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P', but dont filter the others parammeters (AND CD_CORTE BETWEEN (SELECT MIN(CD_CORTE) FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') AND (SELECT MIN(CD_CORTE) +150 FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') )

Can anybody help me? Please.