using a function within an SQL query

[Joshua Weir]

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

 

[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?