Code doesn't work

sharon95 · 2016-11-22

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 · 2016-11-22

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 · 2016-11-22

Where is TableMonth.FIND* ?

sharon95 · 2016-11-22

@Slawek_Guzek it doesn't work

Wisa123 · 2016-11-22

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 · 2016-12-05

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?

Code doesn't work

Best Answer

Answers

Categories