Monday, 5 September 2011
Sysbase Advantage Database - Using triggers to keep a history
I recently wrote an article about how to use triggers to keep a history of changes made to database records. This is very useful is you want to keep a trail of record changes for example I have used this to keep a trial of stock and where stock has moved from and to, also keeping a history of what has happened to a customer's order. I think most commercial databases would benefit from doing this and because it is done at the database end it means that once it is done it will always keep a history rather than writing logging into software applications. Click here to go to the article.
Friday, 5 August 2011
iPad - How to take a screenshot of the display
While doing developments for the iPad it is often a user will report an issue or make a request. I've found that asking them to take a screenshot an emailing it a very useful tool on the iPad. To take a screenshot just follow these steps.
- Press and hold down the home button, this is the button on the front of the iPad.
- Press the power button on the top, this will cause the screen to flash confirming the screenshot has been taken.
- Go into 'Photos' and you should see the image of the screenshot allowing you to email the image.
Wednesday, 13 July 2011
Samsung D6530 LED TV Review
I recently bought a Samsung D6530 40 inch TV for roughly £750. The TV was delivered in a slim large box which was packaged well. The TV was quick to setup which took about 20 minutes, and required just a phillips screw driver.
The TV is very slim and the edge of the picture to the edge of the TV is very small both approx width of a thumb. The TV is supplier with a good quality brushed steel stand, I was glad not to get the black glass one.
Once I had connected the correct cables I switched the TV on and it soon tried to connect to my wireless router, I entered the password and it downloaded the latest software updates. After the TV had updated the software and restarted I started to play around with it. The TV picture is very impressive and could easily see it was better than other TVs I had seen recently, because it is LED I thought the black colour in the picture was very black. The HD channels looked great and there is a clear difference between HD and the normal channels. The sound is good but nothing special, I think I might look into connecting an additional sound system to it.
The TV is 3D so I bought some glasses, I believe this is a technology that needs improving, but compared to the cinema is OK. There is an option to convert standard 2D pictures to 3D, this option varies depending on the programme you are watching, but generally I think I will not be using this.
What I was most impressed with apart from the great picture is how it connects to the internet and my PC. Samsung have something they call Smart Hub, this opens a screen with loads of options. There is a panel that displays your apps similar to Apple products. There are various Apps like You Tube, BBC iPlayer, LoveFilm, Skype and Twitter that come pre-installed, out of these I think the most impressive is the BBC iPlayer app. The Smart Hub also gives you the option for something they call AllShare, which allows you to connect other devices to the TV wirelessly. I installed Samsung's PC Share Manager and selected the directories I wanted to see and started the server. I then went downstairs and there was a message on the TV saying that it could see the server, I could then play videos, music and pictures that where located on my PC on my TV wirelessly, which I think is very clever.
In conclusion I think my new TV is great, here is a list of pros and cons:
Pros - Fantastic picture, very slim, easy to use, internet connectivity.
Cons - 3D is OK but not great, remote control feels a little cheap.
Specifications
The TV is very slim and the edge of the picture to the edge of the TV is very small both approx width of a thumb. The TV is supplier with a good quality brushed steel stand, I was glad not to get the black glass one.
Once I had connected the correct cables I switched the TV on and it soon tried to connect to my wireless router, I entered the password and it downloaded the latest software updates. After the TV had updated the software and restarted I started to play around with it. The TV picture is very impressive and could easily see it was better than other TVs I had seen recently, because it is LED I thought the black colour in the picture was very black. The HD channels looked great and there is a clear difference between HD and the normal channels. The sound is good but nothing special, I think I might look into connecting an additional sound system to it.
The TV is 3D so I bought some glasses, I believe this is a technology that needs improving, but compared to the cinema is OK. There is an option to convert standard 2D pictures to 3D, this option varies depending on the programme you are watching, but generally I think I will not be using this.
What I was most impressed with apart from the great picture is how it connects to the internet and my PC. Samsung have something they call Smart Hub, this opens a screen with loads of options. There is a panel that displays your apps similar to Apple products. There are various Apps like You Tube, BBC iPlayer, LoveFilm, Skype and Twitter that come pre-installed, out of these I think the most impressive is the BBC iPlayer app. The Smart Hub also gives you the option for something they call AllShare, which allows you to connect other devices to the TV wirelessly. I installed Samsung's PC Share Manager and selected the directories I wanted to see and started the server. I then went downstairs and there was a message on the TV saying that it could see the server, I could then play videos, music and pictures that where located on my PC on my TV wirelessly, which I think is very clever.In conclusion I think my new TV is great, here is a list of pros and cons:
Pros - Fantastic picture, very slim, easy to use, internet connectivity.
Cons - 3D is OK but not great, remote control feels a little cheap.
Specifications
- 400 Hz
- Resolution 1920 x 1080
- Built in Wi-Fi
- 4 HDMI
- USB 2.0 x 3
- Freeview HD
- 3D with 2D to 3D conversion
- Dimensions - width = 1248mm, height = 805mm, depth = 30mm max
Monday, 11 July 2011
News of the World rebadged to Sun On Sunday
News of the Worlds owners News International are clearly planning planning on continuing producing a similar Sunday newspaper. They last week bought the SunOnSunday.co.uk and TheSunOnSunday.co.uk domain names so will really just rebadge the News of the World. It will be interesting how long News International will wait before producing the new Sun on Sunday newspaper.
Friday, 8 July 2011
How to report software bugs
I have written an article about how users should report software bugs, here is a basic summary.
1) Do not leave out any facts.
2) Remember more information is always better than less.
3) When an error occurs, stop what you are doing and write down as much information as possible.
4) Make sure it is an error and not a feature.
5) Be very specific on what windows and buttons are pressed.
2) Remember more information is always better than less.
3) When an error occurs, stop what you are doing and write down as much information as possible.
4) Make sure it is an error and not a feature.
5) Be very specific on what windows and buttons are pressed.
Click here to link to the full article
Thursday, 7 July 2011
WordPress blog links not working
On one of my wordpress blogs, all of a sudden the links to the blog articles did not work. Looking at the URL of the link it was adding a '/%' to the end of the URL. The way to fix this problem is to go into the 'Permalink' setting of the blog and change it. For some reason the setting had changed to custom and added a '/%' to the end of the URL.
Thursday, 16 June 2011
Using iPad / iPhone as remote mouse
Recently I have been doing some development work on the iPad and iPhone, while doing this I started thinking of ideas for my own App. One of the ideas was that the iPad touch screen works very similar to my MacBook's trackpad, but is larger, so I thought it would be great to be able to use my iPad as the trackpad for my MacBook, my first thought was how it would communicate between the devices and I thought Bluetooth was the solution. Someone has already beaten me to this idea and come up with an App that does this, it is called 'Remote Mouse', if you do a search in the App Store you will find it. You will also need to go to their web site and download the software that needs to be installed on the computer, it can also be installed on a PC. It does not use Bluetooth but uses WiFi, it is a clever app and I am glad I did not spend much time looking into developing one.
Tuesday, 14 June 2011
iWeb problem with jQuery
I recently produced a web site using iWeb on the Apple Mac, it was a quick and easy way of producing a basic web site, which looks good. I wanted to make a couple of changes to it and have a couple of paragraphs expand when a user click a caption. To do this I used jQuery (innerfade), which I have used on other web sites, I found that jQuery conflicts with the iWebSite.js. To get around the problem I did the following:
<script type="text/javascript">
var $j = jQuery.noConflict();
$j(document).ready(function(){....
</script>
Using noConflict fixed the problem and the fade worked fine.
<script type="text/javascript">
var $j = jQuery.noConflict();
$j(document).ready(function(){....
</script>
Using noConflict fixed the problem and the fade worked fine.
Subscribe to:
Posts (Atom)
