Hi Andrea,
I f you can please comment of the following code as per your example ;
ActiveID query = SELECT * FROM public."CRM_Pat" WHERE "active" = true ORDER BY "id"

Code to obtain View1 header information in Window6
identifier is the id/index for the table and is passed to the method as an integer

Window6.View1.lastnameLabel = PostgreSQL1.ActiveID.stringValue(2);
Window6.View1.firstnamelabel = PostgreSQL1.ActiveID.stringValue(3);
Window6.View1.patid = PostgreSQL1.ActiveID.stringValue(1);

where the stringValues are the column index of the CRM_Pat table .
This generates null values for the View1 strings. Any direction is appreciated.