thanks Larry and Jan. Adding an autonum solved the problem and now my
application works... dare I say PERFECTLY!!!!!!!
Have a great day!
Jan 2
----- Original Message -----
From: Lawrence Lustig
To: RBASE-L Mailing List
Sent: Tuesday, October 13, 2009 10:43 AM
Subject: [RBASE-L] - Re: Variable Lookup Listview
Everything works great EXCEPT on the temp table's VLL, the checks appear in
a somewhat random order. I issue a PROPERTY table REFRESH 'TRUE' with each
click and have tried using a PROPERTY temptable CLOSE , then OPEN, then
REFRESH, and it doesn't refresh the list in the order it is appended to the
temp table. I have also included PROPERTY VLL REFRESHLIST 'TRUE' after each
click, but nothing puts the checks in the order selected. What am I missing???
If you don't include some kind of ORDER BY instruction in your SQL you are
never guaranteed to have a particular order in your results. Specifically,
there is no concept of "natural order" in SQL and you should never expect
results to come back in the order they were INSERTed.
To solve your problem create an autonumbered ID column on your temp table and
ORDER BY that column in the list view WHERE clause. The autonumber will serve
as a proxy value for the order in which rows were INSERTed into the table.
--
Larry
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.421 / Virus Database: 270.14.13/2432 - Release Date: 10/13/09
06:35:00
