VB6 - MySQL

[tomii]

Hi All,

I am using VB6 with mysql database recently. But I am having problem with showing the text type of mysql field value in a Msflexgrid.

Msflexgrid1.TextMatrix(i, 3) = "" & rdoRS.rdoColumns("products_publisher").Value

This line gives error message. Anybody could help me?

Many thanks.

Tomii

[aktharshaik]

post the error message also plz, so that the problem is specific.

[QVeen72]

Hi,

Try This :

Msflexgrid1.TextMatrix(i, 3) = "" & rdoRS("products_publisher")

Make sure, whatever ResultSet you have opened has a Field named "products_publisher"

Regards
Veena

[tomii]

post the error message also plz, so that the problem is specific.

Run-time Error '40002'

No other text message.

[tomii]

Tried as rdoRS("products_publisher")

But still hangs there...

[QVeen72]

Hi,

Can you post , how rdoRS is opened..?

REgards
Veena

[tomii]

Thanks Veena,

I used RDO connection and couldn't retrieve the text type of data, now I use ADO. Works great!

Hi,

Can you post , how rdoRS is opened..?

REgards Veena