Using UPDATE like in MSSQL SERVER

[Alberto Rodríguez]

Hello,

I have changed from MS SQL Server 7 to MySQL 4.0, so I`m trying to adapt some applications to the new BD. My problem, right now is that I can not UPDATE various register of any table in the way I just do it using ASP with MS SQL Server, I mean, before with SQLServer i UPDATE as folow:

strSQL="SELECT * FROM TBL WHERE TBLUSRID="&vTBLUSRID

TBL.Open mCmd,,2,2

if TBL.eof then
vErrDes="ERROR."
TBL.Close
else
Do until TBL.eof
TBL("FIELD_04")=vFIELD_04
TBL("FIELD_05")=vFIELD_05
TBL("FIELD_06")=vFIELD_06
TBL.movenext
loop
TBL.UpDate
TBL.Close
end if

I get an error for this last with MySQL and it works with SQL SRV.

"Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties"

Right now I just can UPDATE only one register but not various as I need an it is using the folowing cod:

strSQL = "UPDATE TBL SET "
strSQL = strSQL & "FIELD_04="&vFIELD_04&" , "
strSQL = strSQL & "FIELD_05='"&vFIELD_05&"' , "
strSQL = strSQL & "FIELD_06='"&vFIELD_06&"'"
strSQL = strSQL & " WHERE TBLUSRID="&vTBLUSRID

TBL.Open mCmd,,2,2

Thanks.