|
| Iniciado por guest, 16,sep. 2016 00:36 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 16,septiembre 2016 - 00:36 |
Hi 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 MArk |
| |
| |
| | | |
|
| | | | |
| | |
|