• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Find columns in my app that are set to enable autocomplete

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

Resolved Find columns in my app that are set to enable autocomplete

  1. Advice
0
Votes
Undo
  1. Tracy Lamb
    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.

TIA,

Tracy

  1. DataWindow
  2. PowerBuilder (Appeon)
Customized Install Location of CloudAppLauncher on...
Drag and Drop Files in PB2022
Accepted Answer
Tracy Lamb
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:

autocompletemode=suggest 

autocompletemode=append 

autocompletemode=suggestappend 

autocompletemode=none 

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!

~~~Tracy

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

Comment
There are no comments made yet.
Responses (3)
John Fauss
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":

    https://docs.appeon.com/pb2022r3/datawindow_reference/XREF_54577_dddw_property.html

Best regards, John

Comment
There are no comments made yet.
Roland Smith
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.

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.