Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RandyD

    Finding duplicates using SQL

    add this also: and b.date >= :P_firstdate and b.date <= :P_enddate hth Randy
  2. RandyD

    Capturing User Name

    use the USER pseudocolumn: e.g. select USER from DUAL; hth Randy
  3. RandyD

    INSERT date format - help!

    insert into UPS_OUT (CUSTOMER_IDENTIFIER, DATE_ORDERED, ORDER_KEY, SERVICE_TYPE, BILLING_OPTION, NOTIFY_OPTION, NOTIFY_TYPE, NOTIFY_EMAIL, SHIP_NAME, SHIP_STREET, SHIP_CITY, SHIP_STATE, SHIP_ZIP, SHIP_COUNTRY, PACKAGE_TYPE) values ('&quot; + identifier + &quot;',to_date('2000-12-01...
  4. RandyD

    UTL_TCP

    There is a tool called ezdbmail that does this for you and is Oracle version independent. check out www.ezdbmail.com there is a free version to try. hth randy
  5. RandyD

    updating a table automatically at a particular time

    a followup point... what I meant was, if you use a rule during your manual update that says for example: if start_dt and start_tm (why these are two seperate columns is another question) are older than sysdate, and end_dt is null, then assign the status of 700 (Open) to the record, then you can...
  6. RandyD

    Adding comboBox to CaptionBar

    Also read up on DialogBar. It is a resource definable implementation of these kind of controls in dockable bars... hth Randy
  7. RandyD

    Help with the ListView class

    First get the handle to the ListCtrl, (GetListCtrl) then use the ListCtrl functions to InsertColumn and InsertItem and SetItemText, etc... hth Randy
  8. RandyD

    Handle Zip file with Visual C++

    This is a side note: but Java has built in zip management. Is the restriction for C++ that strong? Randy
  9. RandyD

    graphics

    Most objects that can be displayed have a method that controls color. i.e. SetBkColor( RGB(0,0,0)) etc. Look in the MFC documentation to see how to control color for your particular class. if you are painting into a Device Contect then you need to also draw the objects yourself...
  10. RandyD

    Email procedure error--TCPConnection

    If you give up, try the utility EZDBMail... www.ezdbmail.com it works well. Randy
  11. RandyD

    updating a table automatically at a particular time

    Maybe your status column is not really appropriate. Is it a derived value? in other words, do you always know by rules associated with the dates what the status should be? In this case, you can just select a status text based on the date rules at query time. This could be a callable function...
  12. RandyD

    Sending email using Oracle 8i

    Also check out a cool utility called EZDBMail www.ezdbmail.com it works on Oracle 7 and 8, and you dont have to learn smtp. just insert some data to a table ,and then a mail is formatted and sent. Randy

Part and Inventory Search

Back
Top