Hello everybody,
I hve a doubt abot this SQL_Query can be possible
- <CCONTABLE action="SQL_QUERY">
<TABLE>CCONTABLE</TABLE>
<access>SELECT C.CUENTA_CONTABLE,C.INDICADOR_IVA,C.CVE_POSFINAN,C.APLICA_IVA FROM CCONTABLE C WHERE '0000107536' BETWEEN C.CLIENTE_INI AND C.CLIENTE_FIN AND c.CLAVE_CARGOCRED = '$CLAVE_CARGOCRED$' AND nvl('32011',4043) BETWEEN C.PRODUCTO_INI AND C.PRODUCTO_FIN AND C.IVA = '$IVA$AND '05-NOV-2008' BETWEEN C.FINIV AND C.FFINV</access>
- <key1>
<CLAVE_CARGOCRED>990</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
- <key1>
<CLAVE_CARGOCRED>701</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
- <key1>
<CLAVE_CARGOCRED>600</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
- <key1>
<CLAVE_CARGOCRED>704</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
- <key1>
<CLAVE_CARGOCRED>712</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
- <key1>
<CLAVE_CARGOCRED>890</CLAVE_CARGOCRED>
<IVA>15.00</IVA>
</key1>
</CCONTABLE>
as you can see I need many keys, now is this possible?, thanks in advance for your suggestions.
Regards,
Julio Cesar