Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Programming in SQL

Home Register
Log In
By Programming in SQL
joe_muller
3/20/2015
11:00:48 PM
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.

Thanks,
Joe M.
Seattle

Reply
jeff
3/21/2015
10:35:48 AM
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:
https://www.youtube.com/watch?v=uSw2_TkObFc

There's probably a wealth of more advanced material there. It's just a matter of using the right search phrase.



-jp

.


Reply
joe_muller
3/21/2015
11:00:39 AM
Thanks Jeff! I will get started looking into your suggested sources right away.

Love this program!!!

Joe M.
Seattle

Reply
jeff
3/21/2015
1:55:47 PM
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.


-jp

.


Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com