Home » Developer & Programmer » Forms » How to populate listbox with data from database table?
How to populate listbox with data from database table? [message #360088] Wed, 19 November 2008 09:38 Go to next message
mnenchev
Messages: 6
Registered: October 2008
Junior Member
i cant believe that this is so hard to be done, or i am very stupid.
Could someone just give me example how to load a column from table in a list box. The simplest example: DB table TOWNS -> TOWNID, TOWNNAME
How to load all TOWNNAMES in listbox? Is it so hard or i am making big mistakes always?
Please help me.

Report message to a moderator

Re: How to populate listbox with data from database table? [message #360189 is a reply to message #360088] Thu, 20 November 2008 00:38 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Create a 'record_group' using your 'select' statement (make sure it has two columns). Create an LOV based on this 'record_group' making sure that you point the LOV back to the item you want populated. Associate the LOV with the item.

David

Report message to a moderator

Re: How to populate listbox with data from database table? [message #361450 is a reply to message #360088] Wed, 26 November 2008 08:18 Go to previous message
ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester
Member

Other wise you can user add_list_element;

Regards,
Ganesh Jadhav.

Report message to a moderator

Previous Topic: How to make this Hierarchical Tree?
Next Topic: How to Disable or Hide List Item (Poplist)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 08:54:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.