Error in Query?
-
var sStock = from S in QryGen.T_Stocks join R in QryGen.T_RG_Masters on S.F_RGMaster_ID equals R.F_RGMaster_Id where ( ( S.F_Thick > dEnThick && (S.F_Width >= dMinWidth && S.F_Width <= dMinWidth) && (S.F_Length >= dMinLength && S.F_Length <= dMaxLength) ) || ( S.F_Length > dEnLength && (S.F_Thick >= dMinThick && S.F_Thick <= dMaxThick) && (S.F_Width >= dMinWidth && S.F_Width <= dMaxWidth) } ) && S.F_GradeMaster_Id == iGradeMasterId && S.F_STATUS == true && S.F_CMP_ID == globalvar.g_iCmpId select new { S.f_stock_id, S.F_BAR_NUMBER, S.F_Thick, S.F_Width, S.F_Length, S.F_Lot_Number, R.F_RG_PageNo, S.F_RESERVE_STATUS, S.F_STOCK_DATE }; Can any one correct the query for me. Thanks in Advance!
Have A Nice Day! Murali.M Blog
-
var sStock = from S in QryGen.T_Stocks join R in QryGen.T_RG_Masters on S.F_RGMaster_ID equals R.F_RGMaster_Id where ( ( S.F_Thick > dEnThick && (S.F_Width >= dMinWidth && S.F_Width <= dMinWidth) && (S.F_Length >= dMinLength && S.F_Length <= dMaxLength) ) || ( S.F_Length > dEnLength && (S.F_Thick >= dMinThick && S.F_Thick <= dMaxThick) && (S.F_Width >= dMinWidth && S.F_Width <= dMaxWidth) } ) && S.F_GradeMaster_Id == iGradeMasterId && S.F_STATUS == true && S.F_CMP_ID == globalvar.g_iCmpId select new { S.f_stock_id, S.F_BAR_NUMBER, S.F_Thick, S.F_Width, S.F_Length, S.F_Lot_Number, R.F_RG_PageNo, S.F_RESERVE_STATUS, S.F_STOCK_DATE }; Can any one correct the query for me. Thanks in Advance!
Have A Nice Day! Murali.M Blog
var sStock = from S in QryGen.T_Stocks
join R in QryGen.T_RG_Masters on S.F_RGMaster_ID equals R.F_RGMaster_Id
where
(
(
S.F_Thick > dEnThick
&& (S.F_Width >= dMinWidth && S.F_Width <= dMinWidth)
&& (S.F_Length >= dMinLength && S.F_Length <= dMaxLength)
) ||
(
S.F_Length > dEnLength
&& (S.F_Thick >= dMinThick && S.F_Thick <= dMaxThick)
&& (S.F_Width >= dMinWidth && S.F_Width <= dMaxWidth)
}
) &&
S.F_GradeMaster_Id == iGradeMasterId && S.F_STATUS == true && S.F_CMP_ID == globalvar.g_iCmpId
select new { S.f_stock_id, S.F_BAR_NUMBER, S.F_Thick, S.F_Width, S.F_Length, S.F_Lot_Number, R.F_RG_PageNo, S.F_RESERVE_STATUS, S.F_STOCK_DATE };The line in bold looks wrong. I assume what you really meant to put here was:
&& (S.F_Width >= dMinWidth && S.F_Width <= dMaxWidth)
Deja View - the feeling that you've seen this post before.