Dynamic Datawindow creation
************************************************
// Composite Style is not supported in it
// You need to create a datawindow dw_all_pws with with out dataobject
// Default --> dw_syntax_str = SQLCA.SyntaxFromSql(ls_sql_stm, "style(type=grid)", errors)
string ls_select
string ls_where
string ls_dwsyntax
string ls_err,ls_presentation
ls_select = "select s_no,password_type from passwords"
ls_presentation=&
"style( type=Grid &
Horizontal_spread = 25 &
Header_bottom_margin = 15 &
Header_top_margin = 15 ) &
datawindow( units=2 &
Color= 67108864) &
column( Font.Face='system' &
Font.Height=-10 &
Font.Weight=700) &
text( Font.Face='system' &
Font.Height=-10 &
Font.Weight=700 &
Border=6)"
ls_dwsyntax = SQLCA.SyntaxFromSQL ( ls_select, ls_presentation, ls_err )
dw_all_pws.Create ( ls_dwsyntax, ls_err ) --> Returns 1 if it is success
IF ls_err <> '' THEN
MessageBox ( "error - Syntax", ls_err )
ELSE
dw_all_pws.SetTransObject ( SQLCA )
dw_all_pws.Retrieve()
END IF
// This will be usefull while creating the reports. Users can select the number of the columns that the report need to have
Venkatesh Guptha
