File	Date	Author	Commit
aux	1997-11-24	dockes	[d5b229] 0.3 ready ?
doc	1997-11-24	dockes	[cd113a] 0.3 ?
samples	1997-11-24	dockes	[b3547e] 0.3 ready ?
BUGS	1997-11-27	dockes	[be3141] After primarykey->updateindex bug fix
CHANGES	1997-11-23	dockes	[cb5395] configuration update for freebsd
LICENSE	1997-04-25	dockes	[88f404] 1st version
Makefile.in	1997-11-24	dockes	[d69db4] 0.3 ready ?
README	1997-11-21	dockes	[172b48] ntermediary commit, converted to autoconf, not ...
README-DYNAMIC	1997-11-24	dockes	[d69db4] 0.3 ready ?
VERSION	1997-10-23	dockes	[806c5d] ->0.3
configure.in	1997-11-24	dockes	[d69db4] 0.3 ready ?
excludefile	1997-11-21	dockes	[172b48] ntermediary commit, converted to autoconf, not ...
install-sh	1997-11-21	dockes	[c352ce] ntermediary commit, converted to autoconf, not ...
makedist.sh	1997-11-21	dockes	[d0b448] ntermediary commit, converted to autoconf, not ...
mysqltcl.c	1997-11-21	dockes	[144eaf] Use local buffers for mysql handles instead of ...
sqlscreens.tcl	1997-11-24	dockes	[5cfb96] Catch "package require"
tcsq.tcl	1997-11-27	dockes	[48cabc] Nasty bug in the updateindex computation from p...
tkAppInit.c	1997-04-25	dockes	[e1a6fd] 1st version

Read Me

sqlscreens: TCL/TK code to generate database screens

See the installation section in doc/sqlscreens.ascii or
doc/sqlscreens.html

For the very hurried (but this might not work the first time, this is
the first version with autoconf):

./configure
make
make install

- If you're using solaris, the dynamic load version will not work (the
  install will fail because of undefined symbols like__umoddi3) . You
  can use mysqlwish (static link) to test, there are explanations in the
  documentation to get the dynamic version to work.

There are sample applications in the "samples" directory. You can copy
them in another place

See samples/tablescreen.tcl for a minimal example application:
==============================================================
 This is the very minimum possible program, it just generates a
default screen for the table you point it to.

See samples/wines.tcl for a more complete application:
======================================================
 This is a small app to manage a wine cellar. It's not supposed to be
a good wine-cellar managing application, just an exemple of what you
can easily do with sqlscreens, and I happened to have the data
available.

If you want to try this, you should create the tables and load the
data first. 
 You should first create the database and load the data from
 samples/winesload.sql by doing: 
    cd samples
    mysql test < winesload.sql

 You can then start wines.tcl. It has two possible options: -query or
-input, which start slightly different screens for querying the
database or adding data into it.
 
There are 5 tables in the wines db. 
 - "wines" lists the wines,
 - "producers" lists who made them, 
 - "providers" lists where you bought them, 
 - "origins" lists the official wine denominations
 - tastings is for your tasting comments

"origins" would normally be a closed list, created once and very
seldom updated, here it is far from complete and limited to the wines
that are actually there. Still, it is handled as not updateable (that
is, you would use another application, maybe tablescreen, to update
it). 

The application has 5 subscreens. The subscreens are linked so that
querying or inserting in "providers", "producers", "origins" or
tastings will set the corresponding join column in "wines".

Because this is TCL, it would be easy to add more code, for example to
generate lists, statistics, etc... The goal was not to make a complete
application.