I am building an Index server App. On one of the servers here i get a
bizare error when it tries to fill the data adapter. Something about a
field that doesn't cast properly. i am trapping the fillerror event awith
a routine in the docs. The explanation in the error message says that the
data is probably corrupt, but that the row returned properly.
I am bypassing the error with the FillErrorEventHandler and just using
args.Continue = true; to bypass the error. However i want to find out
which field is throwing the error. I suspect a date field that is
"blank" in the filesystem. But i want to confirm this.
the docs gave me a sample to deal with the fill error event and it
starts:
FillError(object sender, FillErrorEventArgs args)
I have found from the args which error code trips the error event. The
Sender object has the row values in it somewhere - i am very new at this
and would like someone to shed some light on how to drill into the sender
object and display the date value in the row with the problem.
the query that is used starts out
SELECT Rank, DocTitle, Filename,Characterization,Write,Size,VPath
FROM SCOPE('DEEP TRAVERSAL OF ""{0}""')...
the write field is the date field. How do i dig its value out of the
object sender?
================================================== ========
Trace.Write("STEP","step1");
this.dbAdapter.SelectCommand.CommandText = Command;
Trace.Write("STEP","step2");
DataSet ds = new DataSet("Results");
Trace.Write("STEP","step2.5");
this.dbAdapter.Fill(ds);
<--never makes it this far -->>
Trace.Write("STEP","step3");