praise God

The deadline is today.

Ha!

Me again… it’s now 5:25AM!! and I’ve been dancing here in the office (I’m all alone in here – the others are down and around the passage)

I have to share… at around 8pm I discovered that none of the balances were correct. Oops! I then went into a hundred panic modes, and then eventually (as is my habit) I asked God to please help, as it would be a bad reflection on Him if I was the one to blame for the co being thrown out.

A little later, it occurred to me to start again (yes, like go back 5 weeks!!!) so I zapped up a program and set it to run. Whilst waiting I looked around the portable harddrive i have kept everything about this project on), and I found a file marked XX.original – now XX is the file I’ve been working with for 5 weeks, and also the file I have just started a run to get.

I copied it across to the server and ran a report on it (4 million transactions) and then set out to check the balance – almost 100%!!! Yay!!! Ok, so how to bridge the 5 week gap? Well, that’s easy, they are copies of the same file, ie that will have the same key. All I have to do is extract the 5 weeks worth of results from the buggy file, and use the key to populate the new file.

I took the idea to the boss, and he says it’s great, and simple! He likes it… from total dog box to being able to actaully give them what they need despite reports taking an hour to run!!!! Whoopee!

He is the One,
He is Jesus
and what does He call me to do now?
to be quiet now, and rest

He is our King,
He is our love,
He is our God who has come
to bring us back to Him…

the words of the song playing now…

Majesty!
Majesty!

well..