pcsoft.us.windevCopyright 2026, PC SOFT9 Oct 2018 10:53:09 Z2 Oct 2018 19:25:28 ZHi I am using a table control to display selected records from a database. The database is used to record visitor entries from different buildings. Each station will see only those records that pertain to the particular building. I am trying to use an embedded query in the table control content section. The building is stored in a global variable gsBuildingQual. The command becomes like this: SELECT visitors.VisitorsID AS VisitorsID, visitors.vis_date AS vis_date, visitors.vis_title AS vis_title, visitors.vis_lname AS vis_lname, visitors.vis_fname AS vis_fname, visitors.vis_idno AS vis_idno, visitors.vis_company AS vis_company, visitors.vis_telno AS vis_telno, visitors.vis_floor AS vis_floor, visitors.vis_purpose AS vis_purpose, visitors.vis_remarks AS vis_remarks, visitors.vis_timein AS vis_timein, visitors.vis_timeout AS vis_timeout, visitors.vis_building AS vis_building FROM visitors WHERE visitors.vis_building = 'gsbuildingqual' It is not working. Tried as param also {gsbuildingqual} . Please help. Thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66868-embedded-query-table-control/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)josegarrido2pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66868-embedded-query-table-control-66872/read.awp9 Oct 2018 10:53:09 ZYou should simplify the problem. The first thing you should test it's if the query does works. In the query editor itself. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66868-embedded-query-table-control-66872/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66868-embedded-query-table-control-66872/read.awpembedded query in table control