Hi Again
I tried finding answers on forums and could not find, that is why I am asking here.
I have an network routing application for classroom scheduling that uses DataLayer as input for Stops.
I have a pre ordered sequence I want the route to be solved, for example MS-325, SS-1253, PF-4214, ENB-202, ES-718
When solving the route however it does not follow the sequence specified in the where clause.
(BLD_ID = 'MS' AND RM_ID = '325') OR (BLD_ID = 'SS' AND RM_ID = '1253') OR (BLD_ID = 'PF' AND RM_ID = '4214') OR (BLD_ID = 'ENB' AND RM_ID = '202') OR (BLD_ID = 'ES' AND RM_ID = '718')
I understand it is following the Record Order the rooms are stored in the table. Also, I tried the ORDER BY statement but doesn�??t seem to have any effect.
Is there a way to order the Route Stops when using a Datalayer?
Thank you very much for all and any help.