0

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

3
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by tomii
0

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

0

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

Run-time Error '40002'

No other text message.

0

Tried as rdoRS("products_publisher")

But still hangs there...

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.