How to check the database field if null then populate the grid cell with zero else with the value entered in the cell.
while not eof do
grdDeal.Cells[0,iRow] := FieldByName('WORKBASKET_DESC').asString;
if ( FieldByName('PRODUCT_DEAL_NO').asString = null) then
grdDeal.Cells [1,iRow] := 0
grdDeal.Cells [1,iRow] := FieldByName('PRODUCT_DEAL_NO').asString;
grdDeal.Cells[2,iRow] := FieldByName('WORKBASKET_ID').asString;
grdDeal.RowCount := iCount + 1;
Can anyone tell why the above query is returning an error to me.Kinldy tell me what is the correct syntax for the above statements.Please be fast.It should be delivered tomorrow.Thanks in advance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!