[Tutor] python, wxpython and postgresql

[Michael Langford]

I don't recall a modified flag on controls in wxPython.

If you only want to update that which has changed, you probably have
to keep a copy of the result of the query you filled the control with,
and determine the change from comparing it to the current state of the
control.

These guys may have something more sophisticated:
http://lists.wxwidgets.org/cgi-bin/ezmlm-cgi/11

            --Michael

On Mon, Mar 17, 2008 at 7:31 PM, Bill Mais <bmais at maisco.com> wrote:
> Hey, I thought programming was all about the shortcuts ;-)
>
>  I'm sorry to not be clear.  I've done several excellent python +
>  postgresql tutorials, but the one I have not found is wxPython +
>  postgresql (or any database).
>
>  Specifically, how would you take your sql results and set the values of
>  your wxTextCtrls and wxListCtrls?  For example if the sql select
>  statement returns 20 fields the function would find the wxPython
>  controls with the same name and set their values.
>
>  And how would you build a sql statement with only the wxPython controls
>  that have been modified by the user?  So if only the address field was
>  modified the sql would be: UPDATE table1 SET address = '123 Easy Street'
>  WHERE rec_id = 1
>
>  Thanks again,
>
>
> Bill
>  _______________________________________________
>  Tutor maillist  -  Tutor at python.org
>  http://mail.python.org/mailman/listinfo/tutor
>



-- 
Michael Langford
Phone: 404-386-0495
Consulting: http://www.RowdyLabs.com