Wakefield RISC OS Computer Club
Wakefield RISC OS Computer Club

Home
The Club
About the Club
Meetings
Newsletter
Mailing List
Get Involved
Events Diary
Find Us
Join Us
Contact Us
The Show
Wakefield Show
Members
Members' Area
Committee
Free Ads
RISC OS
About RISC OS
RISC OS HowTo

About this Site

[ WROCC Home » Meetings » Past Meetings » March 2009 ]

SQL and the DataPower Database

March 2009 meeting – report by Rick Sterry and Steve Fryatt

Our guest at the March meeting was Nick Mason, an IT consultant operating as Arcamex Ltd. His talk was a short introduction to SQL (Standard Query Language) for databases. The particular database he was using to demonstrate SQL was DataPower 3, which is now developed and distributed by our old friends at R-Comp. However, this talk was much more about SQL than DataPower.

Nick started by explaining that, despite what we may have thought from his name, he was not the drummer from Pink Floyd. He even came prepared with a photograph to help him prove this, although a number of audience members seemed to think that they could see a definite resemblance. With the important issues out of the way, the main part of the talk began.

The first thing that became apparent was that the nice thing about ‘standards’ is that there are so many to choose from! SQL is no different in this respect, and like the programming language BASIC, SQL exists in a number of different ‘flavours’ with much in common, but also many syntactical differences to trap the unwary. Apparently, this helps keep Nick gainfully employed!

DataPower 3 has several different ways of sorting, searching and selecting data. In common with many ‘simple’ databases, the criteria can be entered directly into a layout view; in keeping with its relational abilities, it is also possible to directly access the fields within the tables that make up the database. These make accessing the data a relatively simple matter of drag-and-drop.

Another alternative offered by DataPower is SQL. Switching from the graphical views into SQL causes any existing criteria to be ‘translated’ into SQL, while switching back causes the reverse to happen – to a limited degree, at least. This can be useful for beginners, as it makes it easy to see how different search criteria would be represented in SQL, as well as seeing the effect of new SQL commands through the graphical interface.

Nick then took us through a number of simple examples of how SQL can be used to select and sort data from an example ‘dummy’ database. You can see a similar presentation, with the DataPower file that Nick used and all the examples if you visit Nick’s web site at www.arcamex.com and then click on Products followed by RONWUG Presentations; alternatively, follow the direct link from the members’ area of the club website. We have no audio or video of Nick’s talk, nor a full write-up, but the information you will find on Nick’s site will certainly give you an idea of what it was about.

It was a short talk, perhaps so as not to frighten anyone, and left us wanting to know more. It succeeded in generating enough interest for us to invite Nick back at a later date so he can tackle the subject in a little more depth.

Previous February 2009
A Visit from Professor Steve Furber
Home April 2009
A Visit from Mike Cook
Next

© Wakefield RISC OS Computer Club, 2002-2017 | Contact us

Valid HTML 4.0!

RISC OS