AnsweredAssumed Answered

sql rowid

Question asked by AllanCrump on Feb 28, 2011
Latest reply on Mar 5, 2011 by AllanCrump

Title

sql rowid

Post

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?

Outcomes