Is there any simple way to randomise the row order of an array? I have a bunch of records of image names and ROWIDs I want to use in a slideshow and I'd like them to appear in order, selected at random once.
I realise I could use the @RANDOM function with a HIGH of @NUMROWS, grab that record, @DELROW from existing array and @ADDROW to a new array and do that recursively until I'd been through the whole array but thought there might be a function for that already: <@RANDOMISE ARRAY=myarray> or <@SORT ARRAY=myarray ROWS="* RAND"> Wayne Irvine ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
