|| Programming in SQL
|When I started with jcapper I had never worked with SQL before, and thanks to some of the "cheat sheet" posts here I have been able to do pretty well. |
However, I keep noticing new things that I can do with SQL by looking at various posts that show SQL code only. Like using "TOP 600" that Jeff used in a post a couple of days ago. This is too hit and miss of a learning process, so am wondering if anyone can recommend a book or website on SQL programming that would work well with coding in jcapper?
I have no problem putting the time in to learn, but didn't want to get something that doesn't really apply to how we would use SQL in this program.
|On the JCapper 101 Audio & Video page there's an Index link labeled Operating JCapper in SQL Mode.|
Give that link a click and you'll see links to the Table Schema and Cheat Sheet, etc. (No doubt you've likely read through both of them.)
That said - and before spending money on books, courses, etc...
On that same page there are also links to FREE top notch reference material about constructing SQL Expressions on the W3Schools site:
The reason I like the W3Schools tutorials is because they display links to most of the relevant sql commands on the left hand side of their pages.
Hint: Not sure what the TOP (or any other) command does or how to use it in a sql expression? Just click the link for that command to get your answer.
You also might try poking around on Youtube. I found the following video (it's the 1st of a 5 part series) after doing a Google search for the phrase "youtube Access SQL Basics"...
Microsoft Access SQL Part 1 of 5 - Introduction - YouTube:
There's probably a wealth of more advanced material there. It's just a matter of using the right search phrase.
|Thanks Jeff! I will get started looking into your suggested sources right away.|
Love this program!!!
|A word of WARNING that I forgot to add...|
The following is a short list of commands that - if executed - have the ability to alter either the structure of the table or the data in it:
A L T E R
C R E A T E
D E L E T E
D R O P
I N S E R T I N T O
S E L E C T INTO
U P D A T E
The Data Window is programmed to prevent you from accidentally executing some of these...
D R O P and D E L E T E come to mind off the top of my head.
But I'm guessing some of them could be executed without the user being fully aware what he or she is doing.
I STRONGLY advise making a backup copy of your active c:\JCapper\Exe\JCapper2.mdb file FIRST before playing around with any of the above commands.
That way (worst possible case) having a good backup makes it easy to recover in the event you (unknowingly) change something in the table.