1. 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.

Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 16 September 2019 09:52 AM UTC
  2. PowerBuilder
  3. # 1

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

HTH/Michael 

Comment
  1. Arthur Foux
  2. Monday, 16 September 2019 16:17 PM UTC
Thank You Michael.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 16 September 2019 15:18 PM UTC
  2. PowerBuilder
  3. # 2

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
  1. Arthur Foux
  2. Monday, 16 September 2019 16:16 PM UTC
Thank You Chris.
  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.