Exceptions been thrown when reading a "Double" column

Question

Original User: mswedgar

Hi,

I've been suffered by a strange problem, I'm using FileGeoDatabase and reading a table, but the exception is thrown when getting the value, please see the sample from the attachment(sample code and FGDB dlls), can anybody help on this?

P.S. As the max size of rar is 2.0MB so I have to split the file into two parts.

Regards,
Edgar

GeoDatabaseIssue.part02.rar

GeoDatabaseIssue.part01.rar

MB_Coastal_Zone_1.jpg

MB_Coastal_Zone_2.jpg

Screen Shot 2021-12-10 at 3.39.48 PM.png

Katie_Decker_0-1639179559954.png

MaoEdgar · Answer

Thanks for your reply, that solves my problem.

Thanks,
Edgar

Anonymous User · Answer

Original User: vangelo

Looking at the table from ArcCatalog, there are only 33 non-NULL rows (of 1850),
so that makes me think it could be a null-handling issue -- you really should test
row.IsNull before getting the value.

I'm curious why you're using a DOUBLE to store values which are inherently SHORT
(I won't be around for the Y32K crisis, and neither will file geodatabases), or at least
integer of some kind (no rounding errors and range tests).

- V

MaoEdgar · Answer

Thanks for your reply, here is my code and attached is the data, I'm using the FGDB API version 1.2.0.136.
            Geodatabase geodatabase = Geodatabase.Open(@../Database/FSD.gdb);
            Table gdbTable = geodatabase.OpenTable("Sewerlines");

RowCollection rows = gdbTable.Search("ORIG_CONS_YR", "", RowInstance.Recycle);
            foreach (var item in rows)
            {
                item.GetDouble("ORIG_CONS_YR");
            }

Thanks,
Edgar

FSD.gdb.zip

Image2.png