Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Retrieve a record by entering a value in a datwindow column

  1. How-to
0
Votes
Undo
  1. Arthur Foux
    Arthur Foux
  2. PowerBuilder
  3. Monday, 16 September 2019 03:36 AM UTC

How do I enter a key value (such as an employee number) in a column of the DataWindow object, to retrieve that record. Thank You.

SetFormat by script - local settings etc.
Command Line deployment doesn't require database s...
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 16 September 2019 15:18 PM UTC
  2. PowerBuilder
  3. # 1

Hi Arthur;

1) Make sure that the DWO you are using for data entry has the data entry retrieval column's "Tab Order" > 0 (unprotected).

2) Using the ItemChanged event on the DW or another control like a CommandButton (menu, etc), use a GetItemXxxx() command to access the DW's column data that was just entered.

3) From Step #2, now use the Retrieve() command passing in the new key value.

Regards ... Chris

Comment
Arthur Foux
  1. Arthur Foux
  2. Monday, 16 September 2019 16:16 PM UTC
Thank You Chris.
  1. Helpful
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 16 September 2019 09:52 AM UTC
  2. PowerBuilder
  3. # 2

Sounds like query mode. F1-Help has examples of using DataWindow query mode 

HTH/Michael 

Comment
Arthur Foux
  1. Arthur Foux
  2. Monday, 16 September 2019 16:17 PM UTC
Thank You Michael.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.