Populating one combobox in Delphi 7 from another?

5 pts.
Tags:
ComboBox
Delphi
Delphi 7.0
SQL
I have one combobox in which you select an option. What is the sql used in the query to restrict the second combobox depending on the first value. All I seem able to get is: [SELECT Name_Of_Race FROM Races WHERE Name_Of_Allegiance = DBLookupComboBox1.Value] Here, when I press the button to set the first combobox as the selected value, the second one appears but with no values in it. I have replaced DBLookupCombobox1.Value with a correct value and the second combobox behaved as expected, so I can only presume I am using an incorrect identifier. If anyone could help it would be much appreciated. Thanks ! :)

Answer Wiki

Thanks. We'll let you know when a new response is added.

You might need to use the ‘text’ property instead of ‘value’.

Also, you might need to concatenate quotes before and after DBLookupComboBox1.text, since you are comparing strings.

————————–

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following