| Dan Pressnell 2006-03-08, 9:55 pm |
| I've uploaded the file "Basic SQL Handling Setup.zip" to icetips.com.
This app shows some typical SQL handling in getting aggregate data (group
by, count, sum, etc.)
It also shows how the equivalent of such SQL things can be handled with
non-SQL systems, such
as TPS files, by using a little code for queue processing. See the two
"BrowseByCity" procedures, which
in this case display exactly the same information to the user.
Everything is Clarion straight out of the box, no add-ons, no 3rd-party
tools.
About this data file: This is an old database of Texas schools that I
have had for some time that
was downloaded from the web. I have removed phone numbers and email
addresses.
This is for both Clarion 5.5 and Clarion 6.x. I've got lots of comments in
the code, and I think this app is not too threatening to those who are not
yet into SQL,.
Dan
|