Custom return order.

[Ruslan Zasukhin]

On 7/23/06 11:09 PM, "Justin Drury" <justin at crunch-recording.com> wrote:

Hi Justin,

> Wondering if there is a provision in Valentina to return results back
> using a vcursor in a custom/random order.  I've tried getting the
> recID's for a result set and then randomizing their position and then
> doing a select where RecID=xxx or RecID=yyy, but the results always
> come back in the original order.  Ideally a select * from xxx order
> by rand(RecID) would be ideal... : )

Well, I have never seen such "feature" in any DBMS.

I think you can simulate what you want using ArraySet.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]