Displaying 1 result from an estimated 1 matches for "auction_d".
Did you mean:
auction_id
2005 Feb 18
1
R crashes on Repeated ODBC Queries
...ue date, the maturity dates, term codes and
IDs for
#the auctions.
the.dates <- day.list(the.date)
cmnd <- paste("SELECT
auction.auction_id as id,
tranche.term_days as term,
tranche.issue_date as issdate,
tranche.term_type_code as termcode,
tranche.maturity_date as matdate,
auction.auction_date as aucdate
FROM
auction,tranche
WHERE
auction.auction_id = tranche.auction_id
AND
auction_type_code like '",auction.type,"%'
AND
auction.auction_date =
",sprintf("'%i-%i-%i'",the.dates[1],the.dates[2],the.dates[3]),";"
,sep="...