Can't get records to show in Tlist

[cj29bball]

I am trying to use the populate_list built-in to display records from a record group. When I run the form i never see any of the records in the database but I know they are there. Here is the code:
DECLARE
group_id RecordGroup;
list_id Item := Find_Item('SELECT_CITY_TLIST');
status NUMBER;

BEGIN
group_id :=
Create_Group_From_Query('City_Group',
'SELECT to_char(Branch.BrchCity), to_char(Branch.BrchCity) FROM Branch WHERE
Branch.BrchState = :GLOBAL.STATE_SELECT');

status := Populate_Group('City_Group');
Populate_List(list_id, group_id);
END;

 

[lewisp]

You need to change your query to

[tt]'SELECT to_char(Branch.BrchCity), to_char(Branch.BrchCity) FROM Branch
WHERE Branch.BrchState = ''' || :GLOBAL.STATE_SELECT || '''');[/tt]