February 17, 2019
Hot Topics:

Visual Basic Database Tutorial - Part 2

  • November 20, 2002
  • By Karl Moore
  • Send Email »
  • More Articles »

My psychologist always tells me to imagine smooth relaxing sands and blue rippling seas, as I unveil the maniacal details of my crazed programming life. And that's just what we'll be doing in this section - except we don't have a couch. Erm, nor an official Institute of Psychology certificate.

But let's just imagine you wanted to talk to your database - perhaps you want to ask it the telephone number of one of the contacts in your table.

Top Tip: Just in case your memory is as useful as the Pope's wedding tackle, don't forget that a field is a 'box' inside a table - numerous fields make up one table. One or more tables make up a database.

In a perfect world, we'd be able to say "What's the telephone number for Johnny Briggs?" - and the computer would reply, "It's 517-000-238, Karl, you stunningly wonderful person".

Welcome to an imperfect world.

In the world of databases, we talk in a language called SQL, or Structured Query Language.

Top Tip: Never call SQL "Structured Query Language", unless you're writing a report - or are called Karl Moore. Phrases like "I'm just writing a lil' bit of SQL" sound much more impressive and are guaranteed to improve your social status.

To pick a random example, a sentence such as "Show me all the contact names" in English, translates into something like "select ContactName from Contacts" in SQL.

Page 2 of 8

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date