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
|