IF,Else,End Statement

Rathi · 2016-10-26

Hi all,

CASE gGPOTenderLine."Item Category" OF
gGPOTenderLine."Item Category" :: "FP SWJB":
BEGIN
Item_Category :='MY';
END;
gGPOTenderLine."Item Category":: 'FP SWSIN':
BEGIN
Item_Category := 'SG';
END;
END;

I want do something like this. but its end up with error.
Help me.

mohana_cse06 · 2016-10-26

Add Item_Category := '';
at the beginning of the code.

mohana_cse06 · 2016-10-26

and the error is?

Rathi · 2016-10-26

The error as below

mohana_cse06 · 2016-10-26

gGPOTenderLine."Item Category":: 'FP SWSIN':
your options should be in double quotes like
gGPOTenderLine."Item Category":: "FP SWSIN":

mohana_cse06 · 2016-10-26

what type of variable is Item_Category?

Rathi · 2016-10-26

Item_category = text (declared on page)

if double quotes there will be another error as below.

Actually

gGPOTenderLine."Item Category" is a column name

"FP SWSIN": is one of data under Item Category column

And i want pass the Data to Item_Category Text field (eg: MY or SG)

mohana_cse06 · 2016-10-26

you need to be carefull with spaces and so.
it seems one of the option value is not a=correct
FP SWSIN or FP SWJB.
open the table and go to field Item Category and copy the values from OptionString property

Rathi · 2016-10-26

No, i copied & pasted the cell in coding. There is space between that text.

I'm trying another method,

IF gGPOTenderLine."Item Category" ="FP SWSIN" THEN BEGIN
Item_Category := 'MY'
END
ELSE IF gGPOTenderLine."Item Category" ="FP SWJB" THEN BEGIN
Item_Category := 'SG';
END;

The result i get in Item_Category is all "MY" even though it is fall under
FP SWSIN.

Any solution for it?

mohana_cse06 · 2016-10-26

Add Item_Category := '';
at the beginning of the code.

IF,Else,End Statement

Best Answer

Answers

Categories