Schultz’s PowerBuilder Notes

ItemError Event


Return codes

Return Code

Action

0

Reject the data value and display an error message

1

Reject the data value and do not display a message

2

Accept the data value

3

Reject the data value but let the focus change

Continue reading

Advertisements

May 29, 2008 Posted by | DataWindow Control | , , , , , | 1 Comment

ItemChanged Event


Return codes

Return Code

Action

0

Accept the data value

1

Reject the data value

2

Reject the data value but let the focus change

Continue reading

May 29, 2008 Posted by | DataWindow Control | , , , , , , , , | Leave a comment

Populating Dropdown DataWindows


When are DDDWs populated automatically?

  • A Retrieve() is issued and the DDDW does not have a result set
  • A row is Inserted

Continue reading

May 29, 2008 Posted by | 2. Datawindows, Drop Down Data Window (DDDW) | , | Leave a comment

DataWindow Script Techniques


How do I set a property for an entire column?

Modify(“shft_id.visible = 0”)

Modify(“shft_desc.protect = 1”)

Continue reading

May 26, 2008 Posted by | 2. Datawindows, Datawindow PowerScript | , , , , , , , , , , , , , , , , , , , , , , , , , , , | 8 Comments

System Functions


Evaluate( )

The evaluate( ) function is available for use with Describe( ). Evaluate( ) lets you evaluate DataWindow expressions within a script using data in the DataWindow. It has the following syntax:

Continue reading

May 26, 2008 Posted by | Powerscript | , , , , , , , , , , | Leave a comment

InterDataWindow Communication


RowsCopy

RowsCopy will copy the contents of one datawindow/datastore to another. The RowStatus flags for each row will be NewModified!

Continue reading

May 26, 2008 Posted by | Datawindow PowerScript | , , , , | Leave a comment

Row Selection


GetSelectedRow(long)

Reports the number of the next highlighted row after a specified row in a DataWindow control or DataStore object. Argument is the row after which you want to search for the next selected row. Specify 0 to begin searching at the first row

Continue reading

May 26, 2008 Posted by | Datawindow PowerScript | , , | Leave a comment

Dynamic DataWindows


How do I build a DataWindow dynamically?

  1. Build the SQL statement for the DataWindow object as a string and describe he form and presentation style of the DataWindow object
  2. Associate the new DataWindow object with a DataWindow control

Continue reading

May 26, 2008 Posted by | 2. Datawindows | , , , , , , , , , , , | 5 Comments

Printing a DataWindow


Print Events

  • PrintStart
  • PrintPage
  • PrintEnd

In the PrintPage event, a RETURN 1 will skip the next page to be printed.

Continue reading

May 25, 2008 Posted by | Datawindow PowerScript | , , , , , | 2 Comments