using a function within an SQL query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i want to feed a random seed into my query therefore i implemtented a
function called Randomizer() into a module.

function randomizer() as integer
Static alreadydone as integer
if alreadydone = false then randomize: alreadydone = true
Randomizer = 0
End Function

IN my SQL statement i have:

SELECT ....
FROM .....
WHERE Randomizer() = 1

However i get the following compiler error:

Compile error. in query expression 'randomizer() = 1'.

I dont understand why? Please help.

Joshua Weir
 
I just realized that it is the 'Randomize' statement in the randomizer
function, if i comment this out, my query works! Does anyone know why this
wouldnt work?
 
Back
Top