Hi all and thanks all for replying. Here is the down and drity on this
whole thing.
The BINDING from the DatabaseQuery to the Listbox caused the problem. You
can NOT use any coded SQLQuery to a ListBox that has a BINDING to it.
That is why the code I wrote and others that helped me NEVER worked. I
disabled the BINDING and WOW! It all WORKED! And a bonus as the ListBox
Headers worked as well.
So, after some off line help form Norman P, we found out that the Binding
was causing all the trouble. The Binding process is great for a newbie like
me starting out with a small app. But now that I am reaching out, I need to
dump the Binding process and just code the SQLQuery. It all works now and
even with a bit more help I realized that I can use the same code to bring
the ListBox up on startup.
This is strange as this was just a side project but the results from this
will aid me in finish creating the other 2 projects that are even larger.
To: Tim Hare - The mdList.AddRow "This" was me trying to see if it would
populate that listbox cell and it never did. Once I found out it was the
Binding, I dump all of the binding JUNK and the code that i had written with
others finally worked.
To: Jeffery Martin - Thanks to the reply as it all counts, I have only
RB2005r4 Pro but I see many that have the RB2006r4 are having issues.
BTW to clear things up, when i talk about the "BINDINGS" I am talking about
the DatabaseQuery Object that binds with a ListBox. I have now removed all
DatabaseQuery Object to ListBox Bindings and now I will ONLY hand code the
SQLQuerys into the code myself
Thanks to all the replied.
Jonathon
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.4/475 - Release Date: 10/13/2006
_______________________________________________
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>
