SQL Forms

This is a Zope wizard!
This is a front end for managing SQL tables.
From Zope interface you design your SQL table,
then create the table and that's all.
The result is that you can add/list/edit your data
by web in one minute, right after you design field list.

Honeyd CC - Honeyd Control Center is a zope application
based on one SQL Forms object
and some SQL Forms Reporter objects.

I saw that sql forms + reporter are good for
admin purposes only (you can quick create, fill and
list tables and also you can quick learn dtml
programming looking into generated methods).

But to do a nice application you must build your own.
My generated sql forms are available quick but also are ugly (standard html forms).

Download and install the demo file!

Features

Automatically generate list,add,edit methods
You have special fields (non SQL fields) with incremental values,
useful for primary key and made in a portable SQL format
Select security check script for each list,add,edit method
edit fields, create/drop table
Change fields display order
use standard HTML form fields and some new fields (select, list and date) to fill the forms
list and select fields are build from other SQL tables (by a query)

Common mistakes

Avoid to use reserved SQL fieldnames such as id,name,date,type,int,file,text,user,all
Check sql field size (avoid to be too small) or data will be truncated
Update options but don't edit directly the list,add,edit methods
Update options when you get an error

Avoid to use invalid names or chars into names (like " or ')

Title	Type	Modified	Status

3.1	Software Release	2003-06-10	published
3.2	Software Release	2003-06-10	published
3.3	Software Release	2003-06-10	published
3.4	Software Release	2003-06-10	published
3.5	Software Release	2003-06-10	published
demo	Software Release	2003-10-17	published