Brian Gubb
|
| Posted: 05/31/2002, 12:56 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0041_01C208DD.FA3A13E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Is there a site I can go to learn SQL examples for CodeCharge, so that I =
don't have to bother everyone here with very basic questions?
Brian Gubb
------=_NextPart_000_0041_01C208DD.FA3A13E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Is there a site I can go to learn SQL examples for =
CodeCharge,=20
so that I don't have to bother everyone here with very basic=20
questions?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian Gubb</FONT></DIV></BODY></HTML>
------=_NextPart_000_0041_01C208DD.FA3A13E0--
|
|
|
 |
Shawn Mason
|
| Posted: 05/31/2002, 7:07 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0164_01C2088B.01825430
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Most examples are on www.GotoCode.com . Buy a good Sql book, look at =
the examples, and go to it. This community is here to help provided you =
are willing to invest yourself.
Shawn Mason
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad7ac7$a9c$1@news.codecharge.com...
Is there a site I can go to learn SQL examples for CodeCharge, so that =
I don't have to bother everyone here with very basic questions?
Brian Gubb
------=_NextPart_000_0164_01C2088B.01825430
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Most examples are on <A=20
href=3D"http://www.GotoCode.com">www.GotoCode.com</A> . Buy a =
good Sql=20
book, look at the examples, and go to it. This community is here =
to help=20
provided you are willing to invest yourself.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Shawn Mason</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ad7ac7$a9c$1@news.codecharge.com">news:ad7ac7$a9c$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>Is there a site I can go to learn SQL examples for =
CodeCharge, so that I don't have to bother everyone here with very =
basic=20
questions?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian Gubb</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0164_01C2088B.01825430--
|
|
|
|
Dave Rexel
|
| Posted: 06/10/2002, 4:46 PM |
|
Hello Brian
I would like to suggest
http://www.sqlcourse.com/
as an excellent online site to learn useful SQL
Hopefuly after the above you will try the following and be able to
understand and eventually master the SQL queries that you want CCS to
operate on.
Keep the site open beside CCS to refer to when you need an SQL explanation.
(There are other sites but this one really covers a lot of ground
effectively)
***************************************************
Fun and painless learning:
- advanced SQL with the CCS Query Builder
***************************************************
In CCS any project, anytime... (make a connection point to your required DB
1st)
Create new blank page, hit CTRL+END in design view and bring up the Grid
Form Builder from the Toolbox
Now hit Next after choosing the connection that points to your DB
Choose any table, add all it's fields and press finish.
Stop right there! Because this is where we actually start.
(Do not bother with anything else)
In Project Explorer find this new form and
look for the Datasource field in the Properies Panel
Start the the CCS Query Builder by pressing the button with 3 dots.
Welcome to a very cool learning tool 
the CCS DataSource Dialog and the CCS Query Builder :
Press the little + table-icon near the upper-left corner.
Bring up two tables and drag a fieldname to one in another table
You should see a line joining the two fields if you've dragged properly.
Hit Review Data to see what CCS will output
Now choose only the checkboxes of the fields you are interested in.
Hit Review Data to see what CCS will output this time
When you see an interesting result
Hit the SQL button to see what syntax has been generated.
Cool stuff :
- right-click on the lines joining fields to change the joins
check out and decode the generated SQL
- back in the DataSource dialog
change the DataSource Type dropdown to SQL
now you can edit the generated SQL
I started with generating the bookstore Solution
Bought a lot of books from myself <|
(love filling those shopping carts)
More prosaicly, filling the DB with info to be queried.
and then had some fun as above
My favourite query to date:
SELECT SUM(quantity) AS rich_dave
FROM bs_orders
WHERE member_id = 4
Had to insert only the SUM(xyz) bit by hand but thats the subject of a long
raving rant in another thread.
Sorry for the long post, hope it helps.
(I would make a Flash tutorial if I had the time.)
Greetings,
Dave
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:ad7ac7$a9c$1@news.codecharge.com...
Is there a site I can go to learn SQL examples for CodeCharge, so that I
don't have to bother everyone here with very basic questions?
Brian Gubb
|
|
|
|
|
