What am I doing wrong?
 
Using the following, I'm getting an error. In fact revNumberOfRecords returns -1 instead of the number of records. This error is not documented. RunRev doc present a possible error as a litteral data ("revDBerr" or something like that.

on mouseUp
    put empty into field "field 1"
    put revOpenDatabase("ODBC","revo","","","") into myDB
    put revQueryDatabase(MyDB,"SELECT * FROM Nouns") into myRecSet
    put revNumberOfRecords(myRecSet) into NbRec
    repeat NbRec times
        put revCurrentRecord(myRecSet) after field "field 1"
        put revDatabaseColumnNamed(myRecSet,"Noun") & cr after field "field 1"
        revMoveToNextRecord myRecSet
    end repeat
    revCloseDatabase MyDB
end mouseUp

Reply via email to