Hi,
I have an application working in Windows, developed in VB5 using RDO method
to access data.
I use a parametrised query that is correctly working on e PC with Office97
installed.
When is installed Office2000 I receive the error:

07002:[MYSQL][ODBC 3.51 Driver]
[mysqld-3.23.53 max] SQLBindParameter not used for all parameter

The incriminated procedure is:

Dim Qy as New RdoQuery
Dim Rs as RdoResultSet
With Qy
       Set .ActiveConnection = Cns
       .SQL = "select FLD1,FLD2,FLD3 from TABLE1 WHERE FLD1 >=?"
       .RowsetSize = 1
       .rdoParameters(0).Name = "FLD1"
       .rdoParameters(0) = Null
       .rdoParameters(0).Type = rdTypeCHAR
      SET Rs= .OpenResultset(RdOpenKeySet,RdConcurRowVer) ' <1>


End With

The error rise executing line <1>

Thank
Enzo Baldo

Enzo Baldo

__________________________________________________________________
Tiscali ADSL SENZA CANONE:
Attivazione GRATIS, contributo adesione GRATIS, modem GRATIS,
50 ore di navigazione GRATIS.  ABBONARTI TI COSTA SOLO UN CLICK!
http://point.tiscali.it/adsl/index.shtml




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to