Re: CREATE TABLE and input widgets from DB schema object

Kind of long term plan for Gtk_MDB_Designer, at present it creates a sligtly modified MDB xml schema. It will generate from that - SQL create tables statements. - links.ini for DB_DataObjects. on the todo list.. - Hook into DB_DataObjects generator - Generate Simple HTML forms? - this is not as easy as it seems - think about what happens when you update the database - if you've hand modified the HTML, what should it do.... - Hook into a scinitlla editor so you can edit the DataObjects! :) - A full blown UML diagram integrated editor :) Regards Alan Vax#N8 wrote:

I've noticed that the schema of your database is reflected in both the CREATE TABLE commands (and INSERT, UPDATE, etc.) as well as the HTML form input widgets. Among other commonalities, the maximum length should be specified in the VARCHAR(N) and size=n attributes of the tables and HTML forms. Has anyone considered writing a class that could both generate HTML and SQL statements? I've taken a stab at it but it's not close to usable yet.