When using OleDb, from VB.NET, to get data from Visual FoxPro, I cannot get the random generation to work. Basically, if I execute this line from VFP, I will get the expected result. This means at every SQL result, I get a random record sequence order.

SELECT TOP 10 RAND(),Video.Date,Video.Numero,Video.Title,Video.NoVideoT,Video.Notes_E,Video.Notes_F,Master.FirstName,;
 Master.LastName,Program.Title AS Program,Video.NoProgram,Video.NoClass,Video.Url;
 FROM Video;
 INNER JOIN Master ON Video.NoMaster=Master.Numero;
 LEFT JOIN Program ON Video.NoProgram=Program.Numero;
 WHERE Video.Date<=DATE() AND Video.Active;
 ORDER BY 1 DESC

But, if this line is called from VB.NET by the use of the OleDb, I will always get 0.91 for the RAND() value. Is there a way to make that work in that environment?