VB & Database, Insufficent key column information for updating and refreshing:Too many rows to update

Insufficent key column information for updating and refreshing:Too many rows to update

Author	Message
ache #1 / 3	Insufficent key column information for updating and refreshing:Too many rows to update Hi ! please help me to solve this problem: I'm using a datagrid to edit a recorset. Sometimes, when I've many (almost 10) rows and I try to updatebatch, It says "Insufficent key column information for updating and refreshing:Too many rows to update" Err.Number = -2147467259 is reported by the Microsoft Cursor Engine "Native error:1009" This is a part of the code I'm using: Dim rsGrid As ADODB.Recordset Set rsGrid = New ADODB.Recordset Set dbmago = New adodb.Connection dbmago.CursorLocation = adUseClient dbmago.Mode = adModeShareDenyNone dbmago.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & VB.App.Path _ "\winsmag.mdb" [...] rsGrid.Open "SELECT * FROM RighiTab where sigla = '" & rsTesta("sigla") & "' and _ numero = " & rsTesta("numero"), dbmago, adOpenDynamic, adLockBatchOptimistic [...] .... i work on the datagrid (binded on the rsGrid recordset) when I perform the rsGrid.UpdateBatch I got the error. Anyway if I "Resume Next", all seems work .... More info: I'm not using a disconnected recordset I'm using an Access2000 mdb database My rsGrid recordset is a detail from a master/detail relation structure When I've few rows I do not get any error What's happen ? Any comment ? Help me ! Thanks Franco
Tue, 09 Mar 2004 18:16:57 GMT

FZ #2 / 3	Insufficent key column information for updating and refreshing:Too many rows to update the problem dear friend is not in the stars, but ourselves. The message text is obscure but the meaning is not: you must have primary keys defined and used in the table and the datagrid. Quote: > Hi ! > please help me to solve this problem: > I'm using a datagrid to edit a recorset. > Sometimes, when I've many (almost 10) rows and I try to updatebatch, > It says > "Insufficent key column information for updating and refreshing:Too many > rows to update" > Err.Number = -2147467259 is reported by the Microsoft Cursor Engine > "Native error:1009" > This is a part of the code I'm using: > Dim rsGrid As ADODB.Recordset > Set rsGrid = New ADODB.Recordset > Set dbmago = New adodb.Connection > dbmago.CursorLocation = adUseClient > dbmago.Mode = adModeShareDenyNone > dbmago.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & VB.App.Path _ > "\winsmag.mdb" > [...] > rsGrid.Open "SELECT * FROM RighiTab where sigla = '" & rsTesta("sigla") & "' > and _ > numero = " & rsTesta("numero"), dbmago, adOpenDynamic, adLockBatchOptimistic - Hide quoted text - - Show quoted text - Quote: > [...] > .... i work on the datagrid (binded on the rsGrid recordset) when I perform > the > rsGrid.UpdateBatch > I got the error. Anyway if I "Resume Next", all seems work .... > More info: > I'm not using a disconnected recordset > I'm using an Access2000 mdb database > My rsGrid recordset is a detail from a master/detail relation structure > When I've few rows I do not get any error > What's happen ? Any comment ? Help me ! > Thanks > Franco
Tue, 09 Mar 2004 20:11:47 GMT

ache #3 / 3	Insufficent key column information for updating and refreshing:Too many rows to update thanks... it's my first datagrid ! Franco Quote: > the problem dear friend is not in the stars, but ourselves. The message > text is obscure but the meaning is not: you must have primary keys defined > and used in the table and the datagrid. > > Hi ! > > please help me to solve this problem: > > I'm using a datagrid to edit a recorset. > > Sometimes, when I've many (almost 10) rows and I try to updatebatch, > > It says > > "Insufficent key column information for updating and refreshing:Too many > > rows to update" > > Err.Number = -2147467259 is reported by the Microsoft Cursor Engine > > "Native error:1009" > > This is a part of the code I'm using: > > Dim rsGrid As ADODB.Recordset > > Set rsGrid = New ADODB.Recordset > > Set dbmago = New adodb.Connection > > dbmago.CursorLocation = adUseClient > > dbmago.Mode = adModeShareDenyNone > > dbmago.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & VB.App.Path > _ > > "\winsmag.mdb" > > [...] > > rsGrid.Open "SELECT * FROM RighiTab where sigla = '" & rsTesta("sigla") & > "' > > and _ > > numero = " & rsTesta("numero"), dbmago, adOpenDynamic, > adLockBatchOptimistic > > [...] > > .... i work on the datagrid (binded on the rsGrid recordset) when I > perform > > the > > rsGrid.UpdateBatch > > I got the error. Anyway if I "Resume Next", all seems work .... > > More info: > > I'm not using a disconnected recordset > > I'm using an Access2000 mdb database > > My rsGrid recordset is a detail from a master/detail relation structure > > When I've few rows I do not get any error > > What's happen ? Any comment ? Help me ! > > Thanks > > Franco
Tue, 09 Mar 2004 20:48:44 GMT

Page 1 of 1

[ 3 post ]