\r
//get data from database\r
String strQuery = \r
- "SELECT TOP 20002 Name.* , RefDetail.RefDetailId, RefDetail.RefFk, " +\r
+ "SELECT Name.* , RefDetail.RefDetailId, RefDetail.RefFk, " +\r
" RefDetail.FullRefCache, RefDetail.FullNomRefCache, RefDetail.PreliminaryFlag AS RefDetailPrelim, RefDetail.Details, " + \r
" RefDetail.SecondarySources, RefDetail.IdInSource " +\r
" FROM Name LEFT OUTER JOIN RefDetail ON Name.NomRefDetailFk = RefDetail.RefDetailId AND Name.NomRefDetailFk = RefDetail.RefDetailId AND " +\r