porque me sale este eroor?
Publicado por Reynaldo Herrera (1 intervención) el 02/10/2003 19:42:40
Key column information is insufficient or incorrect. Too many rows where afected by update.
El codigo es el sig:
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "PROVIDER=SQLOLEDB;Data Source=" & nameServer & ";User ID=sa;initial catalog=" & nameInit & ";"
Set adoCloneSabaRS = New ADODB.Recordset
cSql = "SELECT * FROMOM Yza_NoSaba "
adoCloneSabaRS.Open cSql, cn, adOpenDynamic, adLockOptimistic
adoCloneSabaRS.MoveFirst
Do While Not adoCloneSabaRS.EOF
adoCloneSabaRS!Revisado = "N"
adoCloneSabaRS.Update
adoCloneSabaRS.MoveNext
Loop
El codigo es el sig:
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "PROVIDER=SQLOLEDB;Data Source=" & nameServer & ";User ID=sa;initial catalog=" & nameInit & ";"
Set adoCloneSabaRS = New ADODB.Recordset
cSql = "SELECT * FROMOM Yza_NoSaba "
adoCloneSabaRS.Open cSql, cn, adOpenDynamic, adLockOptimistic
adoCloneSabaRS.MoveFirst
Do While Not adoCloneSabaRS.EOF
adoCloneSabaRS!Revisado = "N"
adoCloneSabaRS.Update
adoCloneSabaRS.MoveNext
Loop
Valora esta pregunta


0