At 1:54 PM -0800 22/11/06, TJ Hanson, PhD wrote:
I am populating a ListBox using the DatabaseQuery control with the SQL:

SELECT T2RepNbr, T2Obs1, T2Obs2, T2Obs3, T2Obs4, T2Obs5, T2Obs6, T2Obs7, T2Obs8 FROM RandBlockData

using

RBQuery.RunQuery                // re-populate the ListBox

Instead of 1 record per line, the ListBox contains the first record of the database, repeated for as many records as there are in the database. So when there are 4 records, the first record is repeated on lines 1 to 4.

I've checked the database and all 4 records are different, so the prob is not 4 duplicate records.

My Bindings and DatabaseQuery appear to be okay.

I've populated ListBoxes before, and I'm sure this is a very simple problem. But I'm just not seeing it.

Any suggestions would be appreciated.  Thanks.

TJ


Yes, never use those bindings features.
It is always better to populate the list yourself.
It's not a lot of code  and you get to avoid all the binding bugs/quirks.
--

Cheers,

Dr Gerard Hammond
MacSOS Solutions
http://www.macsos.com.au
_______________________________________________
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>

Reply via email to