Code doesn't work

sharon95

I'm trying this:

TableMonth.SETFILTER(Month , FORMAT(DATE2DMY(TableFiscal.DOB , 2)));
FiscalCode += FORMAT(TableMonth.Letter);
MESSAGE('%1',TableMonth.Letter);

the message is empty.... why? thank you!

Wisa123

TableMonth.SETFILTER(Month , FORMAT(DATE2DMY(TableFiscal.DOB , 2)));
IF TableMonth.FINDFIRST THEN BEGIN
  FiscalCode += FORMAT(TableMonth.Letter);
  MESSAGE('%1',TableMonth.Letter);
END;

Try this. If you don't even get a message theres something wrong with your filter.

Slawek_Guzek

Where is TableMonth.FIND* ?

sharon95

@Slawek_Guzek it doesn't work

Wisa123

TableMonth.SETFILTER(Month , FORMAT(DATE2DMY(TableFiscal.DOB , 2)));
IF TableMonth.FINDFIRST THEN BEGIN
  FiscalCode += FORMAT(TableMonth.Letter);
  MESSAGE('%1',TableMonth.Letter);
END;

Try this. If you don't even get a message theres something wrong with your filter.

serdarulutas

I don't have the codebase but is TableFiscal.DOB a function? If it is a field, did you try "TableFiscal.findfirst;" at the beginning?