This topic is locked

SQL for beginners?

12/7/2006 11:47:49 AM
ASPRunnerPro General questions
G
grinningdog author

Hi

Can anyone recommend an basic SQL tutorial that uses plain English? So far I've only found stuff that may as well be written in Martian!
All I want to do initially is understand how I can present a total of three fields on my list page. They are numbers (up to 3 figures only) and I want to enter them on the add page but also show a total in the list.
At present I've got as far as adding this to my SQL query list
[PredSwim],

[PredBike],

[PredRun],

PredSwim+PredBike+PredRun as Total,
but that just gives me the numbers in sequence. I'm pretty sure I need a SUM command in there but I'll be damned if I can make sense of it
Regards

Bob

Sergey Kornilov admin 12/7/2006

Bob,
it sounds like fields PredSwim, PredBike and PredRun are text fields.

You need to make them numbers in the database and rebuild your project. Nothing else to change.
To learn SQL check our Interactive SQL Tutorial:

http://www.webcheatsheet.com/sql/interactive_sql_tutorial/

G
grinningdog author 12/7/2006

Thank you Sergey, it now works perfectly. I restarted the whole thing from scratch because I kept getting a message saying "type mismatch". Whatever was causing that problem has disappeared now.
I'm sure you get sick of hearing this but... this is astonishing software. It is easily the best investment I've made (and I've bought some real crap over the years). I work for a charity in the UK and we'll now be able to do stuff that we would have had to pay a fortune for (or just not have)
Sadly, it also means you might gets lots more dumb newbie questions <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=13665&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />