Post reply

Dynamic Rate of Exchange

  • September 29, 2006 at 6:43 am

    #68954

    Hi there,

    I've created an application (adp) that deals with the importing of product items. To determine the price of a specific item, I need to multiply the current rate of exchange with the base cost. The price is completely dependant on the rate of exchange. If there is any change in the rate (it can be daily) the prices needs to be  adjusted accordingly.

    This means I have to go to some website each day to verify the exchange rates and then update my database with the new values manualy (UPDATE query).

    If I could create a table in SQL Server and have the exchange rates be changed dynamically, it will save me lots of time.

    Is there a basic method, either quering a web service or Active-X control or any other method that I can use to automate all of this? It should only retreive the values from the web and update the relevant table in my database.

    Thank you

    Niel Venter 

  • September 29, 2006 at 7:29 am

    #663299

    You can always download the page to your hd, then parse it to find the current exchange rate and update a table on the server which fires a trigger that updates all the prices in the DB.  That code could then be called by the windows scheduler.

  • September 29, 2006 at 8:07 am

    #663331

    you're looking for an rss feed such as the one provided at

    http://ansuz.sooke.bc.ca/rippy/exchange/

    MVDBA

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply