Znolk SQL Wizard (c) Philipp Auersperg
Based on Paulo Eduardo Neves' P SQL Input Wizard - special thanks to him
I added support for insert/update/delete and browse and support for ODBC databases

Paulo's original Readme can be found under README.neves 



P MySQL Input Wizard will help you to create database 
interactions. Just select the tables and columns where you want to
insert data and the wizard will create:
       1. A SQL method for browsing data 
       2. A report for browsing data
       3. Forms for inserting,updating and deleting data
       4. A SQL method for each inserting,deleting and updating data
       5. A result page that calls the SQL method
       

You just have to edit the generated pages to make a beautiful user
interface. If want to input data in  more than one table, you'll
probably also have to  edit the SQL Method code to insert the same
value in multiple tables.

Vantages of using the wizard:
	 o You won't have to learn Zope syntax to do it :-)
	 o No need to remember all your database tables and columns
	   names
	 o No more typos when writing your database insert forms and
	   methods
	 o Have consistent naming in forms and SQL variables
	 o Waste your time building a usable interface, instead of  
	   writing repetitive code and looking for DB info

The Wizard is reported to work with MySQL, Oracle 8.0.5 and Sysbase/MS
SQL Server 6.5. It's very easy to adapt to other DBs. To do it take a 
look at comments in file DBInfo/InfoBase.py, and use the implemented
DBs as examples. 

If you make modifications or adapt it to more DBs, please send me what 
you have done. I'll ad it to the official release.

* GETTING IT 
	You can download the wizard from the URL:
	http://www.zope.org

* INSTALL
	To install it just go to your Zope base directory and execute:
	tar -xzvf Znolk*.tar.gz
	Shutdown your Zope and restart it

* LICENSE
	This code is licensed under GNU General Public License. 
	You can read it in this page:
	http://www.gnu.org/copyleft/gpl.html

* USING THE WIZARD
	The use should be obvious. Just select P SQL Wizard in a
	Folder, click ADD and follow the steps.

* COMPATIBILITY
	P SQL Input Wizard has been tested with Zope  2.0.1, 2.1.4 and 2.2.0.  It should 
	work with older versions. I've got complains that it don't
	work with the CVS Zope.
	


Have Fun!

Philipp Auersperg <phil@bluedynamics.com>
Goldegg,Austria 
14.jul.2000

Paulo Eduardo Neves <neves@inf.puc-rio.br>
Rio de Janeiro, 23/04/1999
