Member Avatar for 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

  • 3 Contributors
  • 6 Replies
  • 79 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by tomii

Recommended Answers

All 6 Replies

Member Avatar for aktharshaik

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

Member Avatar for 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

Member Avatar for tomii

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

Run-time Error '40002'

No other text message.

Member Avatar for tomii

Tried as rdoRS("products_publisher")

But still hangs there...

Member Avatar for QVeen72

Hi,

Can you post , how rdoRS is opened..?

REgards
Veena

Member Avatar for 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

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.