Page 1 of 1

how to read data from MySQL table...

Posted: Thu Aug 27, 2009 11:47 am
by rakeshthp
Hello friends..

I am developing a database application.. i got a simple table called customer with the following schema..

cid integer, cname varchar(25), caddress text, ccontact varchar(15)

I am using mysql.. I went through this example and started with a code.. http://docs.wxwidgets.org/stable/wx_odbcoverview.html

I am able to read other three fields from the table... But the customer id field is not giving me proper result... if the id is 1, it is showing some unwanted value like -182342..

Eagerly waiting for responses..

Thanks in advance
Rakesh Patil

Posted: Fri Aug 28, 2009 7:54 am
by illnatured
Can you show your code?

Posted: Fri Aug 28, 2009 9:21 am
by ilovasz
Hi,
according to http://wiki.wxwidgets.org/ODBC, wxODBC has been removed from wxWidgets 2.8+
You should take a look at the wxDatabaseLayer component.
You can find it here:
http://wxcode.sourceforge.net/components/databaselayer/

Other alternatives are
wxDba (http://debea.net/trac/wiki/WxDba)
wxMySQL (http://ttanalytics.nm.ru/wxcomponents/w ... index.html)

LI

Posted: Fri Aug 28, 2009 10:32 am
by rakeshthp
hi ilovasz..

Thanks for those links.. I'll try with it and get back to you...

Thanks once again..

Posted: Fri Aug 28, 2009 11:28 am
by ilovasz
You're welcome

LI

Posted: Sat Aug 29, 2009 1:40 pm
by TrV
Here is something about DatabaseLayer which mays interest you: http://dev.arqendra.net/#dbl

Posted: Sat Oct 10, 2009 2:24 am
by wxTNewb
Other alternatives are
wxDba (http://debea.net/trac/wiki/WxDba)
I have a question abut wxDba. recently I've tried it, but for some reason, it depends on wxODBC.... I'm not so sure this is an alternative as yet...

So my question is why does it depend on wxODBC?

Posted: Sat Oct 10, 2009 10:15 am
by vsp
I have downloaded and built wxMySql. It seems to be good and works fine.

Thanks.