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

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

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

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

Run-time Error '40002'

No other text message.

Tried as rdoRS("products_publisher")

But still hangs there...

Hi,

Can you post , how rdoRS is opened..?

REgards
Veena

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.