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@gmail.com 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