Topic: Using SQL and pushing data into a ComboBox
Hi
This is a similar question that I had but with a twist (I previously could use a GRID to get an SQL reference but now I am using a different Table and only have a combobox as a point of connection)
I want to force an answer into a combobox from a different table. It works with a Textbox, but not with Combobox
The reason behind my crazy, is that I can get the users to use the search button with the combobox (otherwise I wouldn't know how to get around this problem)..
Here are 2 lines of code similar in function but information placed in 2 different formats (TEXTBOX and COMBOBOX) I just get a blank in combobox..
*** From a selection of a condobox = cdClientResource, you will look up the table dbManager of ManagerNameCombined and place it in Combobox
Push to a text box (ClientManagerText)
# 1
fmClient.ClientManagerText.text:=SQLExecute('Select ResManagerText FROM dbResource WHERE id= '+fmclient.cbClientResource.sqlvalue);
Push to a combo box (cbClientManager.)
# 2
fmclient.cbClientManager.text:=SQLExecute('Select ResManagerText FROM dbResource WHERE id= '+fmclient.cbClientResource.sqlvalue);
see ATTACHED PDF. I find it hard to explain my problem.