C\AL Type conversion trouble

InnerCode

Hi,

I'm getting stuck on the following problem.

I've the table "Service Order Cost Plus Entry" as Data Source. Then in the "Service Order Cost Plus Entry - OnAfterGetRecord" section are the following C\AL Locals declared:
lvServiceLedgerEntry = type: record, table "Service-Ledger Entry" (11012819)
lvEntryNo = type: integer

So I want to set a filter on lvServiceLedgerEntry."Entry No." = "Entry No. Service Ledger" with the following code:
lvServiceLedgerEntry.SETFILTER("Entry No.", "Entry No. Service Ledger");
That gives a type conversion error Text := Integer

So I've to convert lvServiceLedgerEntry."Entry No." into a integer.
The case is that EVALUATE(lvEntryNo, lvServiceLedgerEntry."Entry No.") doesn't work because it sees the column as integer and not as text.

How can I apply the filter? Thanks in advance.

Regards,
InnerCode

mohana_cse06

so lvServiceLedgerEntry."Entry No." is a text field and "Entry No. Service Ledger" is a integer field?
Did you try
lvServiceLedgerEntry.SETFILTER("Entry No.", FORMAT("Entry No. Service Ledger"));

mohana_cse06

so lvServiceLedgerEntry."Entry No." is a text field and "Entry No. Service Ledger" is a integer field?
Did you try
lvServiceLedgerEntry.SETFILTER("Entry No.", FORMAT("Entry No. Service Ledger"));

InnerCode

Many thanks mohana_cse06!
I was staring for hours on this problem.

mohana_cse06

Probably due to Friday

Juha

When you set a simple filter you should use SETRANGE and not SETFILTER.

lvServiceLedgerEntry.SETRANGE("Entry No.", "Entry No. Service Ledger");


/Juha