Random sorting in a recordset

[logge]

Hi!

Does anyone know how to randomly sort records in a CRecordSet class? (Connected to an Access database)
I heard that the following should work:

m_pSet->m_strSort = "RND()";
m_pSet->Requery();

But all I get is an error that says RND is undefined.

Is there another way?

Thanks!

Peter Logarn

 

[Zyrenthian]

well... I dont know how it could be done with a recordset but you could always just put the data into an array of structs suiting your data and do random swaps.

Matt