46 Tips and Tricks Of PowerBuilder Datawindow

1. How to make the column of the stored file directory display pictures?

Answer: Select the display as picture property of the corresponding column to be true

2. How to copy the data of the selected row of grid type to the system clipboard?

Answer:

string ls_selected
ls_selected = dw_1.Object.DataWindow.Selected.Data
clipbord (ls_selected)

string ls_selected

ls_selected = dw_1.Object.DataWindow.Selected.Data

clipbord (ls_selected)

3: How to change the column position of GRID data window (common for novices)

Answer: Preview first, and then drag in the preview window.

4. How to set the DW background color?

Answer: Change the value of color in DW’s editsource

5. How to change Grid style to free format?

Answer: In DW’s editsource, change processing = 1 to 0

6. To create a new table A but the style is the same as the existing table B style, how to quickly set table A to table B style?

Answer: Copy B table C, change the table name and field name to A table in editsource in DW of C table, then

7. How to realize multi-column header of gird style datawindow?

Answer: add text to the header band, and set the band attribute to the foreground to save, edit source modify the text x and width attribute expression as follows:

x = "100 ~ t integer (describe ('firstcol.x')" width = "100 ~ tinteger (describe ('lastcol.x'))-integer (describe ('firstcol.x')) + integer (describe ( 'lastcol.width'))

1	x = "100 ~ t integer (describe ('firstcol.x')" width = "100 ~ tinteger (describe ('lastcol.x'))-integer (describe ('firstcol.x')) + integer (describe ( 'lastcol.width'))

8. How to filter records whose display value is specified value in dddw editing style?

Answer:

dw_1.setfilter ("lookupdisplay ('column_name') = '" + ls_display_value_your + "'")
dw_1.filter ()

1 2	dw_1.setfilter ("lookupdisplay ('column_name') = '" + ls_display_value_your + "'") dw_1.filter ()

9. How to set a column of datawindow to be empty?

Answer:

string ls_temp []
setnull (ls_temp)
dw_1.objec t.columnname.primary.current = ls_temp

string ls_temp []

setnull (ls_temp)

dw_1.objec t.columnname.primary.current = ls_temp

10. How to set different color intervals for single and double rows of datawindow?

Answer: Write

if (mod (getrow (), 2) = 1, rgb (255,0,0), rgb (0,255,0))

1	if (mod (getrow (), 2) = 1, rgb (255,0,0), rgb (0,255,0))

it is the current line The three colors indicate that the expression is as follows:

if (getrow () = current (), rgb (255,0,0), if (mod (getrow (), 2) = 1, rgb (0,0,255), rgb ( 0,255,0)))

1	if (getrow () = current (), rgb (255,0,0), if (mod (getrow (), 2) = 1, rgb (0,0,255), rgb ( 0,255,0)))

11. How to get the datawindowo bject with the specified name?

Answer:

DWObject ldwo_use, ldwo_abc
ldwo_use = dw_1.Object
ldwo_abc = ldwo_use .__ get_attribute ("t_1", FALSE)//t_1 is the name of the text object in datawindow

DWObject ldwo_use, ldwo_abc

ldwo_use = dw_1.Object

ldwo_abc = ldwo_use .__ get_attribute ("t_1", FALSE)//t_1 is the name of the text object in datawindow

12. How to scale the print size of datawindow?

Answer:

dw_1.objec t.datawindow.zoom = 150 or dw_1.objec t.datawindow.zoom = 75

1	dw_1.objec t.datawindow.zoom = 150 or dw_1.objec t.datawindow.zoom = 75

13. How to filter datawindow based on the filtered data?

Answer:

dw_1.setfilter (dw_1.describe ("datawindow.table.filter") + your_join + your_new_filter)
dw_1.filter ()

1 2	dw_1.setfilter (dw_1.describe ("datawindow.table.filter") + your_join + your_new_filter) dw_1.filter ()

14. How to display dynamic time in datawindow?

Answer: Set up a calculation domain, the expression is string (datetime (today (), now ()), ‘yyyy year mm month dd day hh point mm minute ss seconds’), and set the datawindow property

dw_1.Object.DataWindow. Timer_Interval = 500

1	dw_1.Object.DataWindow. Timer_Interval = 500

15. How to make the color of the active window of the title bar of the datawindow control with the title bar?

Answer: External function definition:

funcation logn SetActiveWindow (long hwnd) Library "user32.dll"

1	funcation logn SetActiveWindow (long hwnd) Library "user32.dll"

Clicked event code of datawindow control:

setactivewindow (handle (this))

1	setactivewindow (handle (this))

16. How to set the current line indicator of datawindow?

Answer: Create a calculated column in datawindow, the expression is ”, and move the calculated column to the first column of datawindow, in the datawindow control
Write code in the rowfocuschanged event:
SetRowFocusIndicator (hand!) Or setrowfucsindicator (p_1)//p_1 is the picture control name on the window

17. How to open dddw through code?

Answer: Define external function reference declaration

SUBROUTINE keybd_event (int bVk, int bScan, int dwFlags, int dwExtraInfo) LIBRARY "user32.dll"

1	SUBROUTINE keybd_event (int bVk, int bScan, int dwFlags, int dwExtraInfo) LIBRARY "user32.dll"

The code is as follows: [constant integer VK_F4 = 115

dw_1.SetFocus ()
dw_1.SetColumn ("dept_head_id")//Set the current dddw
keybd_event (VK_F4,0,0,0)//press the F4 key
keybd_event (VK_F4,0,2,0)//release F4 key

dw_1.SetFocus ()

dw_1.SetColumn ("dept_head_id")//Set the current dddw

keybd_event (VK_F4,0,0,0)//press the F4 key

keybd_event (VK_F4,0,2,0)//release F4 key

18. How to print the contents of datawindow to a file?

Answer:

dw_1.objec t.datawindow.print.fileName = "c:\temp.prn"
dw_1.print ()

1 2	dw_1.objec t.datawindow.print.fileName = "c:\temp.prn" dw_1.print ()

19. How to set the initial value of dddw?

Answer:

dw_1.objec t.columnname.Initial = "your_initial_value"

1	dw_1.objec t.columnname.Initial = "your_initial_value"

20. How to display only different data?

Answer:

dw_1.filter ("isnull (columnname [-1]) and columnname <> columnname [-1]")
dw_1.filter ()

1 2	dw_1.filter ("isnull (columnname [-1]) and columnname <> columnname [-1]") dw_1.filter ()

21. How to make the datawindow with title bar immovable?

Answer: Write the following code in the custom event ue_nchittest (pbm_nchittest) of datawindow:
Return 1

22. How to create a calculated column based on the column in the Nth column in the N-UP display style?

Answer: If the column has two columns, number and price, and is displayed as two columns, the expression of the cost calculation column in the first column is number * price, and the expression of the cost_1 calculation column in the second column is number [1] * price [ 1]

23. How to clear the items in ddlb or edit.codetable?

Answer:

dw_1.Object.columnname.Values = ""

1	dw_1.Object.columnname.Values = ""

24. How to rotate the specified column font 90 degrees?

Answer:

dw_1.objec t.columnname.font.Escapement = "900"

1	dw_1.objec t.columnname.font.Escapement = "900"

25. How to get the sql code of datawindow?

Answer: SQL code can be obtained through the following four methods:

string szselect
szselect = dw_1.describe ("datawindow.table.select")
szselect = dw_1.describe ("datawindow.table.sqlselect")
szselect = dw_1.describe ("datawindow.table.select.attribute")
szselect = dw_1.getsqlselect ()

string szselect

szselect = dw_1.describe ("datawindow.table.select")

szselect = dw_1.describe ("datawindow.table.sqlselect")

szselect = dw_1.describe ("datawindow.table.select.attribute")

szselect = dw_1.getsqlselect ()

27. How to obtain the capacity of the virtual storage occupied by the datawindow object?

Answer: Use datawindow.storage property
Example: In the retrievewind event of the datawindow control, write the following code:

long lstorage
lstorage = long (dw_1.objec t.datawindow.storage)
if lstorage> 50000 then dbcancel ()

long lstorage

lstorage = long (dw_1.objec t.datawindow.storage)

if lstorage> 50000 then dbcancel ()

28. How to continuously print two data windows on the same paper?

Answer:

dw_1.objec t.datawindow.print.filename = "temp.prn"
dw_2.objec t.datawindow.print.filename = "temp.prn"
dw_1.print()
dw_2.print()

dw_1.objec t.datawindow.print.filename = "temp.prn"

dw_2.objec t.datawindow.print.filename = "temp.prn"

dw_1.print()

dw_2.print()

29. How to set the record number in each group after datawindow grouping?

Answer: Create a calculated column, the expression is

getrow ()-first (getrow () for group 1) +1

1	getrow ()-first (getrow () for group 1) +1

30. How can I edit only the newly added rows in datawindow?

Answer: Write the following expressions in all column’s protect attribute expressions:

if (isrownew (), '0', '1')

1	if (isrownew (), '0', '1')

31. Except for loops, is there a better way to count the number of selected rows in the data window?

It is generally used to count the number of selected lines in the data window. Is there a better way? In fact, this question is not very useful in application. Discuss it, it is still beneficial to activate your thinking.
Method one:

long ll_Selected ll_Selected = long (dw_1.describe ("evaluate ('sum (if (IsSelected (), 1, 0) for all)', 1)"))

1	long ll_Selected ll_Selected = long (dw_1.describe ("evaluate ('sum (if (IsSelected (), 1, 0) for all)', 1)"))

Method two:

long ll_Selected ll_Selected = long (dw_1.describe ("evaluate ('count (IsSelected () for all)', 1)"))

1	long ll_Selected ll_Selected = long (dw_1.describe ("evaluate ('count (IsSelected () for all)', 1)"))

Method three:

upperbound (dw_1.Object.Data.Selected)

1	upperbound (dw_1.Object.Data.Selected)

32. Q: How to make PB only print the current record, it is a data window made in Free format!

answer:

DataStore ldt_temp
Long ll_Row, ll_Rows

ll_Rows = dw_XX.RowCount()
If ll_Rows = 0 Then Goto the_end
If ll_Rows = 1 Then
	dw_XX.Print()
	Goto the_end
End If

dw_XX.SetRedraw(False)
ldt_temp = Create DataStore
ldt_temp.DataObject = dw_XX.DataObject
ll_Row = dw_XX.GetRow()
dw_XX.RowsMove(1, ll_Rows, Primary!, ldt_temp, 1, Primary!)
ldt_temp.RowsMove(ll_Row, ll_Row, Primary!, dw_XX, 1, Primary!)
dw_XX.Print()
dw_XX.RowsMove (1, 1, Primary!, ldt_temp, ll_Row, Primary!)
ldt_temp.RowsMove (1, ll_Rows, Primary!, dw_XX, 1, Primary!)

Destroy ldt_temp
dw_XX.SetRedraw (True)
the_end:

//Only need to copy the above script into the printing part, dw_XX is the printed free data window, this method can ensure that the data in dw_XX including sort and other attributes will not change before and after printing, but the efficiency is low It should not be used in a data window with a large amount of data. Of course, considering that the printing itself is relatively slow, so 3000 lines of data can be used in this way and accepted by users. If there is a grid data window shared with dw_XX on the same window and displayed simultaneously with dw_XX, you need to setRedraw () with dw_one

DataStore ldt_temp

Long ll_Row, ll_Rows

ll_Rows = dw_XX.RowCount()

If ll_Rows = 0 Then Goto the_end

If ll_Rows = 1 Then

dw_XX.Print()

Goto the_end

End If

dw_XX.SetRedraw(False)

ldt_temp = Create DataStore

ldt_temp.DataObject = dw_XX.DataObject

ll_Row = dw_XX.GetRow()

dw_XX.RowsMove(1, ll_Rows, Primary!, ldt_temp, 1, Primary!)

ldt_temp.RowsMove(ll_Row, ll_Row, Primary!, dw_XX, 1, Primary!)

dw_XX.Print()

dw_XX.RowsMove (1, 1, Primary!, ldt_temp, ll_Row, Primary!)

ldt_temp.RowsMove (1, ll_Rows, Primary!, dw_XX, 1, Primary!)

Destroy ldt_temp

dw_XX.SetRedraw (True)

the_end:

//Only need to copy the above script into the printing part, dw_XX is the printed free data window, this method can ensure that the data in dw_XX including sort and other attributes will not change before and after printing, but the efficiency is low It should not be used in a data window with a large amount of data. Of course, considering that the printing itself is relatively slow, so 3000 lines of data can be used in this way and accepted by users. If there is a grid data window shared with dw_XX on the same window and displayed simultaneously with dw_XX, you need to setRedraw () with dw_one

38. How does the field automatically wrap at the same time and automatically height?

39. How to make the dw column immovable and the column width not adjustable?

Answer: Write if row = 0 then return 1 end if in the cilcked event of datawindow

40. The cursor jumps to a row and column in the data window

Answer:

dw_1.scrolltorow (ll_row) 
dw_1.setcolumn (ll_column)

1 2	dw_1.scrolltorow (ll_row) dw_1.setcolumn (ll_column)

41 How to make the cursor point to the first line of each page?

Answer:

long ll_firstrowonpage = long (dw_1.describe ("datawindow.firstrowonpage"))
dw_1.scrolltorow (ll_firstrowonpage)
dw_1.setrow (ll_firstrowonpage)

long ll_firstrowonpage = long (dw_1.describe ("datawindow.firstrowonpage"))

dw_1.scrolltorow (ll_firstrowonpage)

dw_1.setrow (ll_firstrowonpage)

42. How does Grid’s window fix the first column?

1. Select the HSplitScroll property of data OBJECT
2. In the constructor event:

dw_1.Object.DataWindow.HorizontalScrollSplit = integer (dw_1.describe ("# 1.width"))//width of the first column

1	dw_1.Object.DataWindow.HorizontalScrollSplit = integer (dw_1.describe ("# 1.width"))//width of the first column

3. In the scrollhorizontal event:

Int i
If pane = 1 Then
	i = Integer (This.Object.datawindow.horizontalscrollposition2)
	If i < 1 Or IsNull (i) Then Return
	If scrollpos > 0 Then
		This.Object.datawindow.horizontalScrollPosition = 0
	End If
Else
	i = Integer (This.Object.datawindow.HorizontalScrollSplit)
	If i < 1 Or IsNull (i) Then Return
	If i > scrollpos Then
		This.Object.datawindow.horizontalscrollposition2 = i
	End If
End If

Int i

If pane = 1 Then

i = Integer (This.Object.datawindow.horizontalscrollposition2)

If i < 1 Or IsNull (i) Then Return

If scrollpos > 0 Then

This.Object.datawindow.horizontalScrollPosition = 0

End If

Else

i = Integer (This.Object.datawindow.HorizontalScrollSplit)

If i < 1 Or IsNull (i) Then Return

If i > scrollpos Then

This.Object.datawindow.horizontalscrollposition2 = i

End If

43: How to prohibit modification of the column width of the grid data window

Answer: In the Clicked event of the Grid data window, add:

If row = 0 Then return 1

1	If row = 0 Then return 1

44: grid data window change column width event:

Answer: event: pbm_lbuttondown, pbm_mousemvoe, pbm_lbuttonup
in case:
pbm_lbuttondown: Press the left mouse button in the title bar of the data window (getrow () = 0 and GetObjectAtPointer = your title), and make a note;
pbm_mousemvoe: the mouse moves, and a mark is being recorded;
pbm_lbuttonup: At this time, the left mouse button is up, and then determine whether the position of the last column has changed, and if so, write your script.

45: How to judge whether the content of the data window is modified

Answer:

if dw_wh.deletedcount () + dw_wh.modifiedcount ()> 0 then
integer li_ret
li_ret = messagebox ("Note", "The data has been modified, are you saving it?", Question!, YesNoCancel!)

if dw_wh.deletedcount () + dw_wh.modifiedcount ()> 0 then

integer li_ret

li_ret = messagebox ("Note", "The data has been modified, are you saving it?", Question!, YesNoCancel!)

46: How to get the controls and lines under the mouse cursor in the data window

Answer: Create a custom event, the event number pbm_dwnmousemove, the event has parameters row, dwo

Get From The Internet

Good Luck!

Tagged:DataWindow PowerBuilder PowerScript Tips & Tricks

46 Tips and Tricks Of PowerBuilder Datawindow

About The Author

PassWords

About Us

Profile

Connect With Us

Visitors Statistics

Related Post:

About The Author

PassWords

About Us

Tags

Profile

Connect With Us

Visitors Statistics