.GetRowdata error

[lindir]

Hello guys,

I have an error on the line oDataPLanning.GetRowData(lngColumn) it say: Execution Error '2032465751 (86db08a9)': parameter unvalid   and I don't see why does that because my data record has 4 row and for the error occurs for line 2

Code Select Expand


lngSNKRowIDs = oDataPlanning.GetDataRowIDs("")
'Recherche le nombre de ligne non vide dans le tableau de data
    For lngColumn = LBound(lngSNKRowIDs) To UBound(lngSNKRowIDs)
        varSNKRowData = oDataPlanning.GetRowData(lngColumn)
        Debug.Print varSNKRowData(0)
        bLigneVide = IsNull(varSNKRowData(0))
        If bLigneVide = True Then
        iNbRef = lngColumn - 1
        Exit For
        Else
        bLigneVide = False
        End If
    Next lngColumn

In attachments a shot of my DataRecord

[Yacine]

Just guessing...
- wrong parameter type?
- index exceeds range?

[lindir]

My paramater was a long wich is right and it didn't exceed the index because it was between the UpperBound and Lower bound of the table which is generate by GetDataRowIDs

Anyway I juste destroy the link of the datarecord and recreate the same connection and it now work perfectly I don't why...
I didn't change the code.

Thanks for your help btw!