|
Updating values in Columns |
Post Reply 
|
| Author | |
rdeboer 
Groupie 
Joined: 29 April 2004 Location: Netherlands Status: Offline Points: 81 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Updating values in ColumnsPosted: 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?
|
|
 |
|
|
sserge
Moderator Group 
Joined: 01 December 2004 Status: Offline Points: 1297 |
Post Options
Thanks(0)
Quote Reply
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:
-- WBR, Serge |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options