BorlandTalk.com

Roger · Guest

I am using an Oracle database to populate a jdbList using a picklist.
The jdbList uses a queryDataSet on a table called companyRole with the
columnName set to the ROLE_ID. I have a picklist on the companyRole
that is used to populate the list with the names of the company roles
(client, consultant, etc.)
I want to be able to get the ROLE_ID when a user selects a company in
the list.
For this I use:
int selected = dmFundRoles.getQdsCompanyRole().getBigDecimal("ROLE_ID").intValue();

What I get is:
On first access, ROLE_ID returns the ID of the first companyRole in
the list regardless of which company I click on. If I click on another
company, the ID returned is that of the last company selected and NOT
the one currently selected.

To clarify, Here is the table.

ROLE_ID NAME
---------- -------------------------
1 Client
2 Consultant
3 Custodian
4 Guarantor
5 Investment Manager
6 Issuer
7 Record Keeper
8 Trustee
9 Transfer Agent

Say I click on RecordKeeper when I first access the list. The ID
returned will be 1.
Now, if I were to select any other name in the list, it will return an
ID of 7 - that of the previously selected name.
How does one get the current ID of a selected item in the list?

Thank you for your help in advance.
- Roger