C\AL Type conversion trouble

InnerCode · 2016-01-15

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 · 2016-01-15

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 · 2016-01-15

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 · 2016-01-15

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

mohana_cse06 · 2016-01-15

Probably due to Friday

Juha · 2016-01-15

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

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

/Juha

C\AL Type conversion trouble

Best Answer

Answers

Categories