1. Tracy Lamb
  2. PowerBuilder
  3. Monday, 22 April 2024 13:25 PM UTC

Hi all,

I changed a lot of my drop-down lists to autocomplete style before I realized the implications of setting the column to allow edits.  Is there a way in PB to find all columns set for autocomplete (autocomplete not equal to 0)?  Or maybe all of the datawindows with drop-down-datawindow columns?  Using PB 2022 R3.



Accepted Answer
Tracy Lamb Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2024 12:10 PM UTC
  2. PowerBuilder
  3. # Permalink

So I exported one of the datawindows as suggested by Roland.  Now, I can search the entire app for one of the following:





I didn't realize the implications of using autocomplete... allow edits also has to be enabled.  The dddw's are not simple lists; they are "lookup" tables with a description field (visible) and an id field (invisible) that is saved to the database.

Thank you Roland and John!


 Edited: Took out the spaces before and after the = sign. 

There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 01:49 AM UTC
  2. PowerBuilder
  3. # 1

Hi, Tracy - 

According to the DataWindow Reference publication, I believe you can search for the DDDW.property named "autocompletemode":


Best regards, John

There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 22 April 2024 14:35 PM UTC
  2. PowerBuilder
  3. # 2

Export one of them, then change the setting and export to a different named file. Do a file compare to see what changed. Once you have figured out what the property looks like in the source, you should be able to do a search for it.

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.