Daynote ,Svenson

Sjon
 
-- Home -- Links -- To do -- Calendar -- The Gang -- The Undeniables --

  -- Yesterday -- Week view -- Tomorrow  

MM-clxxiii     Wednesday

 

2000-06-21

 


At last a break in the weather. Still warm 20°C but with lots of clouds on a blue background. While predominantly sunny the temperature is not pushed over the top. And a few light showers cool down the evening. Just the type of weather I like best.

We applied all possible and impossible means to break the wall . After the dust settled the wall still stands, hardly scratched.

While Wilbert and I were spilling our time Ronny stumbled over another obstacle. In our database all (~most~) key fields are filled with uppercase values, the AS/400 is case sensitive in most places (except for its command language). In TeleSales we have a few filter screens where the user can restrict a selection on non-key fields. The data actually contains lowercase but the querry-argument passed by Progress is always turned into uppercase.
A similar problem was solved a few months ago however in that case it was a sub string operation. Now it is a database access and the solution we have means that the file will be accessed without using the existing index. This is of course killing the performance and unacceptable on any substantial file. (The case at hand is just a small file so it's bearable, a worst case of about 200 records but we have much bigger files.)

In between I check out how the prices are calculated for return orders with a related order. Depending on the way some codes are set up (local responsibility) the price and conditions of the original order are used and only adapted for the possible different quantities, or the prices are reloaded from the item file (or price-list or contract or ...). For normal returns the original price (from the order) should be used. In Germany that doesn't seem to be the case.
Maybe they have their codes not set up correctly. We will see tomorrow.

Again no time was left for the VAL adaptation program.

 

Football :

Spain - Yugoslavia : 4 - 3
Netherlands - France : 3 - 2

My site transfer seems to be more or less complete. Brian noticed a broken link to the Calendar (I didn't know any one else went that way). Somehow the leading 'C' became capitalised where it used to be lowercase (I upload from a Win98 box so you can guess where that C came from). On a UNIX (Linux on Cobalt Raq) that makes it a different file.
I expect some more of this type of errors. Sadly I am not using FrontPage or another HTML tool so I can only blame myself.

And the www. is no longer required. I mentioned the problem to Masset and I got a mail late yesterday evening that he had changed something on the server making it optional. So there is no need to change any bookmarks or links. Tom had already changed the daynotes.com links and I had changed the links trough out my site. All unnecessary but there is no need to change back.


Adios
-- Yesterday -- This week -- Tomorrow --

Swijsen © 2000