I have one table with a field (SiteVisit_Hits Numer(10)) in Oracle. The table is having only one...

I have one table with a field (SiteVisit_Hits Numer(10)) in Oracle. The table is having only one row My SQL Statement is "Select SITEVISIT_HITS from Configuration_Details" REcordset is RSConfig RSConfig.Open SQLString,Conn,1,2 When i tried to update the field as RSConfig("SITEVISIT_HITS") = RSConfig("SITEVISIT_HITS") + 1 it is giving Type mismatch error When i print the data type as VarType(RSConfig("SITEVISIT_HITS")), it is printing 14(VBDecimal). When i print the value RSConfig("SITEVISIT_HITS") it is printing 0 even though it has the value. When i tried to update the value after converting it to using cLng , it is giving the error RSConfig.Update() Please Help Me When i print the RS