SELECT #getQueryString()# WHERE currencyChangeRate.idCurrencyFrom= AND currencyChangeRate.idCurrencyTo= AND currencyChangeRate.dateRegistration=( SELECT MAX(dateRegistration) FROM currencyChangeRate AS CCR WHERE CCR.idCurrencyFrom=currencyChangeRate.idCurrencyFrom AND CCR.idCurrencyTo=currencyChangeRate.idCurrencyTo ) SELECT #getQueryString()# WHERE currencyChangeRate.dateRegistration=( SELECT MAX(dateRegistration) FROM currencyChangeRate AS CCR WHERE CCR.idCurrencyFrom=currencyChangeRate.idCurrencyFrom AND CCR.idCurrencyTo=currencyChangeRate.idCurrencyTo AND CCR.dateRegistration <= ) SELECT #getQueryString()# WHERE 1=1 AND currencyChangeRate.idCurrencyFrom= AND currencyChangeRate.idCurrencyTo= AND currencyChangeRate.dateRegistration=( SELECT MAX(dateRegistration) FROM currencyChangeRate AS CCR WHERE CCR.idCurrencyFrom=currencyChangeRate.idCurrencyFrom AND CCR.idCurrencyTo=currencyChangeRate.idCurrencyTo ) ORDER BY #arguments.orderBy##module.list.orderBy# INSERT INTO currencyChangeRate ( idCurrencyFrom, idCurrencyTo, idEmployee, value, dateRegistration ) VALUES ( , , NULL, , ) INSERT INTO currencyChangeRate ( idCurrencyFrom, idCurrencyTo, idEmployee, value, dateRegistration ) VALUES ( , , NULL, , ) Details: " & cfcatch.Detail>