SyntaxFromSQL - how do i specify font height
- New
- How-to
-
Tom Mangano
- PowerBuilder
- Friday, 7 August 2026 09:57 PM UTC
when using SQLCA.SyntaxFromSQL to dynamically create a datawindow, the default font height is 8
i'm trying to change it to 10
as_sql = 'select * from dummy'
ls_syntax = 'Style(Type=Grid) datawindow(Color= 12632256)' // valid - height = 8
ls_new_syntax = SQLCA.SyntaxFromSQL( as_sql, ls_syntax[ lp ], ls_error_syntaxfromSQL ) - no error
all of these examples fail
ls_syntax = 'Style(Type=Grid) datawindow(Color= 12632256) font(height=-10)' // invalid
ls_syntax = 'Style(Type=Grid) datawindow(Color= 12632256) font(height="-10")' // invalid
ls_syntax = 'Style(Type=Grid) datawindow(Color= 12632256) font.height="-10")' // invalid
ls_syntax = 'Style(Type=Grid) datawindow(Color= 12632256) font.height=-10)' // invalid
i've exported a simple datawindow and looked at the font settings which lead to the attempts listed above
thanks for any help
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.