Hi all
OS X 10.3.8 with Servoy 2.2 rc3. I have a sybase solution related to a MySQL database which has two tables. The MySQL database drives a website. Sybase handles a contact management form and a stock book (items for sale - with pictures, prices, details, lengths etc.) In the main Sybase stock book, you can press a button "add to website" which creates the related record in MySQL and the item is instantly on the site via php. there is also a remove from website - and sold items are automatically removed from the website (the stock book marks them as sold and the php search excludes sold items. One function of this system is to present prices in and $. My stock book (and related MySQL database) have a price which is then multiplied by an "exchange rate" which is stored by keeping it in a further related sybase table (administration). Administration is a form / table which allows me as a developer to sell this same solution to more than one customer, there is a relationship from all accessible forms to my private administration form which stores the database "owner" and preferences for their solution (such as exchange rate). The trouble I have is that although the price is multiplied by the exchange rate perfectly, it doesn't happen until I visit the record (not load the record as part of a found set - but rather actually view the record.) This calculation therefore does not affect all $ prices on the sybase (or MySQL) database when I change the exchange rate other than on the record I am on (and any other record that I load and view). My question is what loop should I use to go through all records to actively change the calculated result?
Thanks for any help you can give, sorry my question is convoluted, just trying to provide all the facts.
Bevil Templeton-Smith