Index: trunk/DataCheck/Processing/BuildSequences.sh
===================================================================
--- trunk/DataCheck/Processing/BuildSequences.sh	(revision 18756)
+++ trunk/DataCheck/Processing/BuildSequences.sh	(revision 18757)
@@ -30,4 +30,22 @@
 esac
 
+# update run counts in SequenceInfo table
+# runs in sequence
+query="UPDATE SequenceInfo LEFT JOIN RunInfo USING(fNight, fSequenceID) "
+query=$query"SET fNumRuns=(SELECT COUNT(*) FROM RunInfo "
+query=$query"WHERE fSequenceID=SequenceInfo.fSequenceID AND fNight=SequenceInfo.fNight) "
+printprocesslog "INFO Updating SequenceInfo with number of runs."
+sendquery
+# raw files avail ISDC
+query="UPDATE SequenceInfo LEFT JOIN RunInfo USING(fNight, fSequenceID) "
+query=$query"SET fNumRawfilesAvailISDC=(SELECT COUNT(*) FROM RunInfo "
+query=$query"LEFT JOIN RawFileAvailISDCStatus USING(fNight, fRunID) "
+query=$query"WHERE fSequenceID=SequenceInfo.fSequenceID AND fNight=SequenceInfo.fNight "
+query=$query"AND NOT ISNULL(RawFileAvailISDCStatus.fStartTime) "
+query=$query"AND NOT ISNULL(RawFileAvailISDCStatus.fStopTime) "
+query=$query"AND ISNULL(RawFileAvailISDCStatus.fReturnCode)) "
+printprocesslog "INFO Updating SequenceInfo with number of available files."
+sendquery
+
 finish