Hi, List.
 
I have several map layers, 1 being streets (made up of segments) and the
other Bus Stops.  I'm selecting bus stops along routes and was relying
on the order in which they were clicked to be the stopping order.  So,
when saving the stops, I select the selection into a named query table,
then do a loop through the query, and attribute the record order to the
resultant Stop record.
 
Alas, I've found the query's order to bear no resemblance to the
clicking order of the selection.  e.g.
 
Stops clicked order:  31380, 31450, 30140, 33158, 30020,
 
Becomes, in the query:  30140, 30020, 33158, 31450, 31380.
 
There's no index set on the Stops table (not that I can figure out how
to do it) and the other fields in the query (such as lat/long, street
refs etc.) show no sign of being in any order.
 
Can anybody help with a method of ensuring the correct order, or is
there some event trigger I can set, on the selection click, whereby I
can keep a count and details of the object?
 
'Ppreciate it muchly
 
Terry McDonnell

Reply via email to