VB & Database, Cannot make AddNew method work properly.

Cannot make AddNew method work properly.

Author	Message
Lee Timm #1 / 3	Cannot make AddNew method work properly. I'm using VB6 with SQL 6.5 . When I run the AddNew method the recordset fields seem to update but not the recordcount or underlying database. The code looks like this. Dim FieldList(5) Dim ValueList(5) Set cnn1 = New ADODB.Connection strCnn = "UserID=sa;Password=;DSN=SSITimeSheet;" cnn1.Open strCnn Set rs = New ADODB.Recordset sSQL = "SELECT ManagementName FROM tblManagement" rs.CursorType = adOpenKeyset rs.LockType = adLockOptimistic rs.Open sSQL, cnn1, , , adCmdText FieldList(0) = "DeveloperID" FieldList(1) = "ProjectID" FieldList(2) = "TaskID" FieldList(3) = "tsDate" FieldList(4) = "tsTime" FieldList(5) = "Notes" 'Set the field values ValueList(0) = DeveloperID ValueList(1) = ProjectID ValueList(2) = TaskID ValueList(3) = TaskDate ValueList(4) = TaskTime ValueList(5) = Note rs.AddNew FieldList2, ValueList2 'Update the database rs.Update I have tried this and several other methods, non of which seem to work. Your help will be greatly appreciated. Lee Timms
Fri, 13 Apr 2001 03:00:00 GMT

Michael J. Andre #2 / 3	Cannot make AddNew method work properly. You need to use the UpdateBatch() method when opening the recodset with adLockOptimistic. Update() only "commits" to the recordset, not the underlying database. There is good info on this in the MDAC 2.0 documentation supplied with the resource kit. You can download this from msdn.microsoft.com/data
Fri, 13 Apr 2001 03:00:00 GMT

Richard Lave #3 / 3	Cannot make AddNew method work properly. Quote: >You need to use the UpdateBatch() method when opening the recodset with >adLockOptimistic. >Update() only "commits" to the recordset, not the underlying database. AIUI, UpdateBatch() is only necessary with lock type adLockBatchOptimistic
Sun, 15 Apr 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]