vb + mysql

[anand3245]

If RSProd.State = 1 Then RSProd.Close
RSProd.Open "select * from ProductMaster where productid='" & CboRawcode & "'", UniCls.conn, adOpenStatic, adLockPessimist ic

If RSProd.RecordCo unt > 0 Then

getting runtime error Data provider or other service returned an E_FAIL status in
mysql 5.0

[danp129]

I think you'll need a client side cursor to get the recordcount.