With Myoledb Seek Not Work - Xtreme Visual Basic Talk

08-30-2003, 02:26 PM

arieljg

Newcomer

Join Date: Aug 2003

Posts: 4

With Myoledb Seek Not Work

Hi, I have MySql table with an index called "CodigoProceso" with de keys Codigo + Proceso

am trying to find a record using seek, but when it´s execute a receive an error msg, can any one provide me with little help?

the ? rsArticulos.Supports(adSeek) return true

If Not rsArticulos.Index = "CodigoProceso" Then
rsArticulos.Index = "CodigoProceso"
End If
rsArticulos.Seek Array(Val(txtArtCodigo.Text), txtArtProceso.Text), adSeekFirstEQ

08-30-2003, 02:53 PM

xBox

Junior Contributor

Join Date: May 2003

Location: Dubai

Posts: 243

Check it out

Code:

With rst
   .Index = "BrCode"
   .Seek "=", mBraCode
      If .NoMatch = False Then
         frmAdvanceDetails.lblSelectBranch.Caption = ![BrDesc]
      End If
End With

Cheers
xBox

08-30-2003, 03:05 PM

arieljg

Newcomer

Join Date: Aug 2003

Posts: 4

When i execute the .index, i receive the msg 'Error 3251..Current provider does not support the necessary interface for index functionality'

Thanks Ariel

08-30-2003, 03:09 PM

xBox

Junior Contributor

Join Date: May 2003

Location: Dubai

Posts: 243

Which OLEDB PRovider r u using it...

Thanks
xBox

08-30-2003, 03:22 PM

arieljg

Newcomer

Join Date: Aug 2003

Posts: 4

MyOLEDB http://mysql.proserve.nl/portal/sites/item-142.html

08-30-2003, 03:29 PM

xBox

Junior Contributor

Join Date: May 2003

Location: Dubai

Posts: 243

Quote:
Originally Posted by arieljg
MyOLEDB http://mysql.proserve.nl/portal/sites/item-142.html

do onething....

put a ADODC Control.. and create a OLEDB Connection.. check whether this OLEDB it's coming to the list

08-30-2003, 03:56 PM

arieljg

Newcomer

Join Date: Aug 2003

Posts: 4

Quote:
Originally Posted by xBox
Quote:
Originally Posted by arieljg
MyOLEDB http://mysql.proserve.nl/portal/sites/item-142.html

do onething....

put a ADODC Control.. and create a OLEDB Connection.. check whether this OLEDB it's coming to the list

what's i must check?

09-03-2003, 08:54 AM

Squeebee

Centurion

Join Date: Jun 2003

Location: Calgary, Alberta, Canada

Posts: 127

I would reccomend switching to MyODBC as MyOLEDB has been essentially abandoned.

__________________
Regards,
Mike Hillyer
www.vbmysql.com