I am populating a ListBox via the SQLQuery property of the
DatabaseQuery control. The Listbox is defined with 9 columns, with a
heading. The SQLQuery is:
SELECT T2RepNbr, T2Obs1, T2Obs2, T2Obs3, T2Obs4, T2Obs5, T2Obs6,
T2Obs7, T2Obs8 FROM RandBlockData
Rather than getting 1 database record per line, the first record in
the database gets duplicated on each line of the ListBox. If there
are 4 lines in the database, the first line gets duplicated 4 times.
If there are 3 lines in the database, the first line gets duplicated
3 times. I have checked the database and each line is unique. My
Bindings and DatabaseQuery appear to be okay.
I've populated ListBoxes from a database before, and I'm sure this is
a very simple problem. But I'm just not seeing it. I posted this
earlier but did not get any responses. I hope the world is not as
baffled as I am.
Any suggestions would be appreciated. Thanks.
TJ
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
