I am checking the text item in oracle form using if statement and an AND condition. Here is my code under the when button pressed. I need the correct syntax suggestion.
BEGIN
IF
:LAND_MANAGEMENT.COMPANY AND
:LAND_MANAGEMENT.LAND_TYPE AND
:LAND_MANAGEMENT.DEED_NO AND
:LAND_MANAGEMENT.LAND_TITLE AND
:LAND_MANAGEMENT.LAND_SELLER_NAME AND
:LAND_MANAGEMENT.LAND_AREA AND
:LAND_MANAGEMENT.DEED_VALUE AND
:LAND_MANAGEMENT.ACTUAL_COAST AND
:LAND_MANAGEMENT.REGISTRATION_COAST IS NOT NULL THEN
commit_form;
GO_BLOCK('RECORDVIEW');
EXECUTE_QUERY();
GO_BLOCK('LAND_MANAGEMENT');
create_record;
Clear_block(no_validate);
FIRST_RECORD;
GO_ITEM('LAND_MANAGEMENT.COMPANY');
END IF;
END;
Aucun commentaire:
Enregistrer un commentaire