Origin Ver. and Service Release (Select Help-->About Origin): 8.6 SR3 64-bit Operating System: Win 7 Pro SP1 64-bit
Hello,
I employ PutRecordset/ReadRecordset functions to import data from SQL databases - everything works fine. However if I try to get the worksheet row number by means Worksheet::GetNumRows function afterwards, it returns always the value of 30 if the number of rows is less than 30. Of course, the problem can be easily solved by means of Dataset::GetSize function, but I'm just curious, whether this limitation of GetNumRows is deliberate.
Origin Worksheet GetNumRows is looking at the currently allocated space, and since each column can potentially have different number of values, you do need to look at individual column to get the actual size. So either Dataset GetSize, of get Column and call GetUpperBound.
GetNumRows() behavior after database import
Posted - 03/15/2017 : 11:58:13 AM
