In my test application, I have a DBGrid component which can see data from my table both before and after I compile my application. Another DBGrid component sees the data after it has been selected by an SQL statement. The selected data is a column of Strings.
However, I have two DBListBoxes, one connected like each of the two DBGrids. However in neither case does any data flow into the DBListBox, either before or after.
procedure TfrmDB2SS.mnuElectionsClick(Sender: TObject);
begin
with dmoVSRead.edElectionsQry do begin
SQL.Clear;
SQL.Add ('select electionName from Elections '
+' where electionID = 2');
ExecSQL;
ShowMessage('RecordCount: '+IntToStr(RecordCount));
end;
dbGrid1.AutoAdjustColumns;
ShowMessage ('DBLookupListBoxes.Counts (1/2): '
+IntToStr(DBLookupListBox1.Count)
+'/'+IntToStr(DBLookupListBox2.Count));
end;
[/font]
What do I need to do to get the data to flow into these data controls which are not DBGrids?