Error while modify the line table

newuser

Hi ALL,

I have a header and line table. Using the insertline i inserted a new line. After that i want to edit that line table. After edited while saving the record it shows this error message.

I dont know how ERROR values is going to update the lineno field.

Navision error (10500): You cannot enter 'ERROR))' in Integer. The cursor is in front of the invalid character.

What is the reason or i made any mistake on that. Here is my line table code...


ReturnCode := 0;

FilterString :=
STRSUBSTNO('WHERE(34=CONST(%1),2=CONST(%2))',
DecodeXML.GetValueByFieldIDFromLineData(XMLDocInLine,recActivityLine.FIELDNO("Reference Number")),
DecodeXML.GetValueByFieldIDFromLineData(XMLDocInLine,recActivityLine.FIELDNO("Line No.")));

LineRecordRef.OPEN(DATABASE::Acitivities,FALSE);
LineRecordRef.SETVIEW(FilterString);

xLineRecordRef.OPEN(DATABASE::Acitivities,FALSE);
xLineRecordRef.SETVIEW(FilterString);
IF xLineRecordRef.FIND('-') THEN;

IF SupportFunctions.CompareHashValues(DecodeXML.GetHashValue(XMLDocInLine),LineRecordRef) THEN BEGIN
EncodeXML.AddFieldToValidationDoc(XMLDocValField,recActivityLine.FIELDNO(recActivityLine.Fair));

DecodeXML.ModifyRecord(XMLDocInLine,LineRecordRef,XMLDocValField,DATABASE::Acitivities,
FALSE,TRUE,AdditionalValues[1],AdditionalValues[2]);

LineRecordRef.MODIFY(TRUE);
END ELSE BEGIN
ReturnCode := 20;
END;

LineFieldRef := LineRecordRef.FIELD(recActivityLine.FIELDNO("Reference Number"));
tmpValue := LineFieldRef.VALUE;

SupportFunctions.CreateTempHeadFilterTable(recActivityLine.FIELDNO("Reference Number"),tmpValue,GUID);

SupportFunctions.CreateTempHeadFilterKeys(recActivityLine.FIELDNO("Reference Number"),GUID);


IF the same record i can able to modify using the card form. and is there any time format we have to follow in the EP.


Thanks in advance