pcsoft.us.windevCopyright 2026, PC SOFT16 Sep 2016 00:36:00 Z16 Sep 2016 00:36:00 ZHi all The cast function has no Boolean type which is causing me a problem with sql queries, and trying to display in a browsing table. Here's my code myFilter is Data Source sQuery is string = [ SELECT DISTINCT tbl_MYOB_SaleLines.lin_ItemUid AS guid, tbl_MYOB_SaleLines.lin_ItemNumber AS code, tbl_MYOB_SaleLines.lin_ItemName AS Name, CAST( 1 AS integer ) AS YesNo FROM tbl_MYOB_SaleLines ORDER BY code ASC ] if HExecuteSQLQuery(myFilter,sQuery) hreadfirst(myFilter) BuildBrowsingTable(Tab_RunReport.Table_Filter6,myFilter,taFillTable) else info("no records selected") end {"Table_Filter6._COL4"}..InputType = typCheckBox Now I set the browsing table column to checkbox but the display of the checkbox is 00 $ 00 for each line, so must be related to the integer as displays ok if I use a Boolean field from the table. ( adding a Boolean field to each data file is my current work around... ) Any comments appreciated. Thanks MArk30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59585-cast-type-boolean/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)