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
