Dynamic data window to create success, but the window cannot populate the data normally, fonts are also small, how to change? O reference program!!!!!
String ls_errors, ls_sql_syntax
String ls_presentation, ls_dwsyntax
Ls_sql_syntax="SELECT * FROM PJNR"
Ls_presentation="style (type=grid)"
Ls_dwsyntax=SQLCA. SyntaxFromSQL (ls_sql_syntax ls_presentation, ls_errors)
//generate dynamic DataWindow statement
IF Len (ls_errors) & gt; 0 THEN
MessageBox (" error ", "SyntaxFromSQL () error:" + ls_errors)
RETURN
END the IF
//create the data window object
Dw_pjb. Create (ls_dwsyntax ls_errors)//table here have been generated,,,
Dw_1. SetTransObject (SQLCA)
Dw_pjb. SetTransObject (SQLCA)
Dw_1. Retrieve ()
Dw_pjb. Retrieve ()
//the following statement is dynamically set data window properties
The integer li_colcount, j
String ls_columnheader [40], ls_columnname ls_expr
Li_colcount=integer (dw_pjb. The describe (datawindow. Column. "count"))
//get the total number of columns of data window
Dw_pjb. Object. The datawindow.
the font=12Dw_pjb. Object. Datawindow. Color=RGB (149176204)
Dw_pjb. Modify (ls_expr)

CodePudding user response:

Ls_dwsyntax find the better replacement

CodePudding user response:

Change the font size syntax
The Modify (" & lt; Columnname> . The Font. Height='& lt; Negative number for points, positive number for PBUs (i.e. for - 10=10 points, 10=10 PBUs> '
")