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.