• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Retrieve a record by entering a value in a datwindow column

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.