Populate dropdownlistbox from an access db table

Posted on 2008-06-12
Last Modified: 2013-12-26
I'm working w/ Powerbuilder 10.5 and an Access DB.
I've put a dropdownlistbox on a window layout.  I want this listbox to hold all the distinct values in a column from the Access DB table I'm working with.  I've tried several different things that I would've used in VB.Net, but I haven't gotten anything to work yet. I've tried using AddItem and InsertItem in a loop and I've also tried an sql statement.  Any help is very appreciated.

Question by:coperations07
  • 2
LVL 14

Accepted Solution

sandeep_patel earned 350 total points
ID: 21773152
You should use dropdowndatawindow option for it. see below link to create and use dropdowndatawindow...

Let me know if you still have any problem in creating this


Author Comment

ID: 21773172
thanks for the reply!  this has been driving me nuts.

Author Comment

ID: 21781952
Looks like that got me going!


Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
python sqlite question 11 46
Advice on Xojo as a development tool over VB. 4 55
Removing line numbers from left column in config file 7 53 and sql server 4 36
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question