I am using the bundled Datadirect odbc drivers that came with FM. I have a database of 10,000 English words that my students use to lookup in our dictionary. I would like to randomly select a word from this database for them to practice, but I seem to have run into a syntax snag. Is it possible to fetch only ONE random record from a set of found records? I have tried every imaginable SELECT syntax I can, but not sure how to do this in filemaker sql terms:
$db->Sql( "SELECT COUNT(*) as Cwds FROM ICST = Cwds returns the value of 7000 records in file, so I create a random number:
$rndn = (any random number), i.e. 1203
and I'd like to Fetchrow number 1203, is that even possible? I tried many variations like this one:
SELECT * ROWID() as ROW,English FROM ICST WHERE NVA='N' AND ROW = $rndn
but I am getting nowhere. Ideas?