1. Andrew Davis
  2. PowerBuilder
  3. Thursday, 24 January 2019 17:59 PM UTC

Hi ( happy new year !!)

 

I think i must be doing something wrong.

I have a datawindow - which is just a single simple table - with no retrieval arguements

I want to use querymode against it.

So in the open event i set the transaction object

dw_1.settransobject(sqlca)

then I have a command button that turns query mode on

dw_1.Object.DataWindow.QueryMode = "yes"

// it creates 24 lines - as expected

then i put in the account field my account BEN0001

then i have a retrieve button

dw_1.retrieve()

I retrieve all the records - not the query set

i have a button to turn the query off

dw_1.Object.DataWindow.QueryMode = "no"

and all the records are displayed - not the ones i wanted

 

* this exact code works in an older version of pb

any ideas ?

 

Accepted Answer
mike S Accepted Answer Pending Moderation
  1. Thursday, 24 January 2019 18:29 PM UTC
  2. PowerBuilder
  3. # Permalink

dw_1.AcceptText() 

dw_1.Object.DataWindow.QueryMode = "no"

dw_1.retrieve()

Comment
  1. Andrew Davis
  2. Thursday, 24 January 2019 18:33 PM UTC
Genius thanks
  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from 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.