whts wrong with the code?? [resolved]

[azrina]

i try toin arrays together so that it becomes a single array.
but from the code i attached here,
it has syntax errors and i dont know
how to correct the error.
so i hope anyone can help me to correct the code below..tq in advance..

note:the commented line is where the error is
note:getRow(0) is a thing that returns the rows in my record set as a VBScript array

'error
noOfRows = UBound(dbTable.getCol(0) + 1)
'error
noOfColumns = UBound(dbTable.getRow(0) + 1)
 
ReDim combinedLine(noOfRows * noOfColumns - 1)
For i = 0 to noOfRows - 1
currentRow = dbTable.getRow(i)
For j = 0 to noOfColumns - 1
combinedLine(i * noOfColumns + j) = currentRow(j)
Next
Next
 
Call layer.addDataSet(combinedLine, &HCF4040, "Data Sampel").setDataSymbol(cd.SquareSymbol, 5)

[techgnome]

the +1 needs to be OUSIDE the UBOUND....

'error
noOfRows = UBound(dbTable.getCol(0)) + 1
'error
noOfColumns = UBound(dbTable.getRow(0)) + 1

You want to add one to the size after the array size is determined.

TG

[azrina]

thank u for ur reply..
i donno that +1 shoulbe outside the Ubound