symbol = S_SYMB from SECURITY where S_CO_ID = co_id and S_ISSUE = issue } else { select co_id = S_CO_ID, exch_id = S_EX_ID, s_name = S_NAME from SECURITY where S_SYMB = symbol select co_name = CO_NAME from COMPANY where = co_id } // Get current pricing information for the security select market_price = LT_PRICE from LAST_TRADE where LT_S_SYMB = symbol // Set characteristics based on the type of trade. select type_is_market = TT_IS_MRKT, type_is_sell = TT_IS_SELL from TRADE_TYPE where TT_ID = trade_type_id // If this is a limit-order, then the requested_price was passed in to the frame, // but if this a market-order, then the requested_price needs to be set to the // current market price. if( type_is_market ) then {
symbol = S_SYMB from SECURITY where S_CO_ID = co_id and S_ISSUE = issue } else { select co_id = S_CO_ID, exch_id = S_EX_ID, s_name = S_NAME from SECURITY where S_SYMB = symbol select co_name = CO_NAME from COMPANY where = co_id } // Get current pricing information for the security select market_price = LT_PRICE from LAST_TRADE where LT_S_SYMB = symbol // Set characteristics based on the type of trade. select type_is_market = TT_IS_MRKT, type_is_sell = TT_IS_SELL from TRADE_TYPE where TT_ID = trade_type_id // If this is a limit-order, then the requested_price was passed in to the frame, // but if this a market-order, then the requested_price needs to be set to the // current market price. if( type_is_market ) then {
tpcx-v_v2.1.0.docx