Re: get data into a view from mysql

[Bob Caryl <bob fis-cal com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I can only answer your question in very broad terms. You need to make
sure that the column layout for your TreeModel matches the data that
will be returned by your fetch query.  Then, for each tuple in the
returned dataset, you need to append a new row to the TreeModel and
write into each column in that new row the appropriate field in each
tuple.

As for updating records in the database if data is changed in a
particular row, I would assume that you have data stored in each row
that will allow you to write an insert query for the corresponding
record in the database in order to update its data.

Hope this helps.

/*Bob Caryl*
Fiscal Systems,Inc.
256.772.8920 Ext. 108
http://www.fis-cal.com <http://www.fis-cal.com/>/

/This email message may contain privileged or confidential information.
If you are not the intended recipient, you may not disclose, use,
disseminate, distribute, copy or rely on this message or attachment in
any way. If you received this email message in error, please return by
forwarding the message and its attachment to the sender and then delete
the message and its attachment from your computer.

Neither Fiscal Systems, Inc., nor its affiliates, accept any liability
for any errors, omissions, corruption or virus in the contents of this
message or any attachments that arise as a result of e-mail transmission./



Ken Kasina wrote:
> Hi everyone,
> I'm using mysql++ to connect to database server and retrieve data. I want
> the records displayed in a Treeview. How do I associate the Column Models
> with the retrieved query data. And also assuming i manipulate the data, how
> do I post back the changes into the database. Please help me out.
> 
> Thanks and have a great time wherever you are.
> 
> Kennedy Kasina
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> gtkmm-list mailing list
> gtkmm-list gnome org
> http://mail.gnome.org/mailman/listinfo/gtkmm-list
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFFDpnruCj6XIbb5UIRAiipAJwNcQo8UCc5viCbtoLiOFfI3KCeDACg3VAI
qOvzFXzxeNp7nP2+JOZw/og=
=ZzQ4
-----END PGP SIGNATURE-----

begin:vcard
fn:Robert Caryl
n:Caryl;Robert
org:Fiscal Systems, Inc.
adr:;;102 Commerce Circle;Madison;AL;35758;USA
email;internet:bob fis-cal com
title:Senior Software Design Engineer
tel;work:356-772-8920 X108
x-mozilla-html:TRUE
url:http://www.fis-cal.com
version:2.1
end:vcard