// // (1) check LAST forward rates in FW_RATE // goon = true; sqlstr = "select t1.f_date, t1.f_no " + ", t1.f_bid" + ", t1.f_offer" + ", t2.f_curr_desc " + "from fw_rate t1, fw_currency t2 " + "where (t1.f_curr_code = t2.f_curr_code) " + "ORDER BY t1.f_no "; cursor = database.cursor ( sqlstr ); next_ok = false; if (cursor.next()) { var w_date = cursor.f_date; dd = w_date.substring(6,8); mm = w_date.substring(4,6); yy = w_date.substring(0,4); next_ok = true; } if (! next_ok) { write (" Sorry, data not available ! \n"); goon = false; } else {
FORWARD RATES
DATE:
write (dd, "/", mm, "/", yy);
For indicative rate only

while (next_ok) { w_bid = cursor.f_bid; w_offer = cursor.f_offer; if (isWhitespace(w_bid) || isEmpty(w_bid)) w_bid = "-"; if (isWhitespace(w_offer) || isEmpty(w_offer)) w_offer = "-"; if (! cursor.next()) next_ok = false; } // next...
Currency PREMIUM
BID OFFER
write (cursor.f_curr_desc); write (w_bid); write (w_offer);

NOTES :
These rates are indicative rates.
If you have any questions, please contact Treasury Department. tel 208-5201-4
} // next_ok

designed by scit