hi,
Am trying to read affected Records from database.
Code:
string[] readArray = new string[reader.RecordsAffected];
when i'm trying to stored in an array its showing error as,
OverflowException: Number overflow.
mySqlAccess.SingleSelectWhere (System.String tableName, System.String itemToSelect, System.String wCol, System.String wPar, System.String wValue) (at Assets/mySqlAccess.cs:142)
mySqlTest.getDB () (at Assets/mySqlTest.cs:12)
mySqlTest.OnGUI () (at Assets/mySqlTest.cs:19)
is there any other way to find this ??
system
November 13, 2010, 2:54pm
2
Hi
You can't/shouldn't really ignore an OverflowException.
Try debugging and see what reader.RecordAffected value is, my guess is something wrong happening when trying to get the data from the DB and that number will be garbage (either 0, or a very high number)
Hi,
from above question we cant get affected record values from "select statement". we have to get this value after "add,alter,delete" statements...
when you're not modify your database the records affected value in -1...so,it will surely show "overflow exception". we cant avoid this...