It looks like you're new here. Sign in or register to get started.
CASE "carrier type" OF "carrier type"::train: BEGIN amount := 0.30; "extra charges" := distance * amount; END; "carrier type"::truck: BEGIN
Vazid_490 wrote: » Thank you, here carrier type is a text data type not option....the above code is used when a carrier type is option..is am correct..??
CASE "carrier type" OF 'train': BEGIN amount := 0.30; "extra charges" := distance * amount; END; 'truck': BEGIN
Answers
Yes you are right, in the case of a text field do the following
But I would recommend to use an option field.