Lazarus or Delphi can do what you want, but you have to code it
yourself, but luckily it's not that difficult
becasue of the database stuff is all based on the tdataset framework.
I do automatic form generation from a table in PG Lightning Admin and
it's not that difficult at all.
You simply loop through the fields and depending on what type they are
you dynamically create
the visual components/widgets you need.
I could probably whip up a simple example in Lazarus if you wanted.
Later,
Tony
webb.sprague@xxxxxxxxx wrote:
So far, here are the candidates: Andromeda, Lazarus, and Rekall.
I was probably fairly inarticulate in my first post, but none of these
seem to meet my criteria for automatic generation of forms based on the
database definition. Most of the above frameworks have a good deal
more functionality than I need, at least at first. Really I want to be
able to open, say, ipython and type:
Someobject.form(table='sometablename', times=3)
(Maybe at the SQL prompt: "> \form name=name times=3")
And have it give cycle three times through a reasonable (though
possibly still imperfect) form for entering three rows in table
sometablename. I don't want to do any developing except for finding
out the table names in the database. I don't want to drag and drop
forms into a visual editor and hook them up with procedures, and any
extra processing should be done inside the database via triggers,
defaults, etc (so the system would have to handle rollbacks and notices
gracefully). Speed of data entry is the most important thing in the
form and form chain itself. I have some ideas for chaining together
forms when there are FK's, but I will talk about that later.
I think it may be up to me at this point. Would anyone else find this
useful?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
