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

Resolved Query mode

  1. How-to
0
Votes
Undo
  1. Berit Sandvik
    Berit Sandvik
  2. PowerBuilder
  3. Thursday, 6 October 2022 07:54 AM UTC

Hi,

When using datawindows in query mode that contains dropdowns - the value in the data column is displayed, not the display value. The data column contains the table's primary key which is a sequence no, and the display column contains f.ex. a description column.

When the column containing the dropdown has focus, the correct value being the description is displayed. But when we exit the column, the value displayed changes to the sequence no which is the data column.

Please see attachment showing an example.

This is a problem with all dropdowns when the datawindow is in query mode.

Has anyone else experienced this and found a solution?

Thanks.

Attachments (1)
Dropdown when dw in query mode.JPG Dropdown when dw in query mode.JPG
  1. DataWindow
Ribbonbar vs Web browser
Appeon 2020 multi-browser problem in window 11 (2...
Responses (3)
Berit Sandvik
Berit Sandvik Accepted Answer Pending Moderation
  1. Friday, 7 October 2022 13:44 PM UTC
  2. PowerBuilder
  3. # 1

The query mode is set at runtime, and the SQLCA is set right before turning the datawindow into query mode.

Yes, it only occurs before the retrieval of data in the datawindow. When the data is retrieved, the columns show the correct values (i.e. the display column)

 

Comment
There are no comments made yet.
Berit Sandvik
Berit Sandvik Accepted Answer Pending Moderation
  1. Friday, 7 October 2022 06:19 AM UTC
  2. PowerBuilder
  3. # 2

Thanks your for reply.

No, there is no override edit on the columns. They contain a drop-down datawindow with the rows available for selection.

Comment
mike S
  1. mike S
  2. Friday, 7 October 2022 13:28 PM UTC
trace your code to see what is going on.



can you switch back and forth in your application between querymode on/off? Does it occur only prior to a retrieve? when do you set sqlca on your datawindow?
  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 6 October 2022 13:47 PM UTC
  2. PowerBuilder
  3. # 3

 

 

do you have "override edit" turned on those columns?

 

 

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