No Prompt Field Name Specified For Drop Down List In Page Definition

This is because in the page field properties of the field “Field” the field value is left blank in the prompt properties. This can be fixed by setting FIELDNAME as List Box in record field properties.

Note: Don't forget to rebuild/alter the record.

Peoplecode for dropdown

 Local SQL &SQL;

/* Clearing all existing values that were with AddDropDownItem() */

RECORD.FIELDNAME.ClearDropDownList();

/* Creating SQL for fetching values to be added to the drop down */

&SQL = CreateSQL("SELECT A.FIELD2 FROM PS_RECORD2 A WHERE A.FIELD3= :1", &para1, &out2);

While &SQL.Fetch(&out2)

   /* Adding each row from the SQL's output to the drop down  */

   N_RUNCNTL_SCI.INFOSILEM_DBNAME.AddDropDownItem(&out2, &out2);

End-While;