arvindmewara
New member
- Joined
- May 26, 2008
- Messages
- 3
- Programming Experience
- Beginner
hello all ,
i want to generate random question for my application which i will show on my quiz form.
everytime when user start application it will show question in random order(sequence should be different).
i using ms access database,
Dim adp As New OleDbDataAdapter("select * from exam where sno = (SELECT CAST(rand() * count(*) as int) + 1 from exam)", con)
i try above code for random question generation but i m getting this error:
IERROINFO.GETDESCRIPTION failed with E_FAIL(0*80004005)
thanks
i want to generate random question for my application which i will show on my quiz form.
everytime when user start application it will show question in random order(sequence should be different).
i using ms access database,
Dim adp As New OleDbDataAdapter("select * from exam where sno = (SELECT CAST(rand() * count(*) as int) + 1 from exam)", con)
i try above code for random question generation but i m getting this error:
IERROINFO.GETDESCRIPTION failed with E_FAIL(0*80004005)
thanks