Codejock Developer Community : Updating values in Columns http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 16 May 2026 01:30:21 +0000 Sun, 29 Oct 2006 04:36:42 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5372 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Updating values in Columns : Hi,The problem looks to be that...]]> http://forum.codejock.com/forum_posts.asp?TID=5372&PID=16860&title=updating-values-in-columns#16860 Author: sserge
Subject: 5372
Posted: 29 October 2006 at 4:36am

Hi,

The problem looks to be that you're searching for row index (your method FindRowIndex), and then trying to access a Record by its index (DownloadQueue.Records(FoundIndex)). It's not the same, and this could be a problem. 

You may have to perform additional transformation: 

FoundRowIndex = FindRowIndex(Connection(Index).Fingerprint)
FoundIndex = frmDownloadQueue.DownloadQueue.Rows(FoundRowIndex).Record.Index


--
WBR,
Serge
]]> Sun, 29 Oct 2006 04:36:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=5372&PID=16860&title=updating-values-in-columns#16860 <![CDATA[Updating values in Columns : Hi, In my code i update a value...]]> http://forum.codejock.com/forum_posts.asp?TID=5372&PID=16846&title=updating-values-in-columns#16846 Author: rdeboer
Subject: 5372
Posted: 27 October 2006 at 11:43am

Hi,
 
In my code i update a value in a column like this:
 
FoundIndex = FindRowIndex(Connection(Index).Fingerprint)
 
If FoundIndex > -1 Then
            NumberCompleted = frmDownloadQueue.DownloadQueue.Records(FoundIndex).Item(9).Value
            frmDownloadQueue.DownloadQueue.Records(FoundIndex).Item(9).Value = NumberCompleted + 1
            frmDownloadQueue.DownloadQueue.Populate
            
End If
 
 
 
The value is updated randomly in 4 seperate tasks for about 200 times.
 
The first xxx times it updates without problems, after that it gives a 'Runtime error 5' Invalid procedure when i want to update the value:
 
NumberCompleted = frmDownloadQueue.DownloadQueue.Records(FoundIndex).Item(9).Value
 
I'm sure the value is OK, and the row exists.
 
What could be wrong here?
 
 
 
]]> Fri, 27 Oct 2006 11:43:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=5372&PID=16846&title=updating-values-in-columns#16846