Updating a table

[fblair301]

I have a form that gives a test. The questions are taken from a free table and are used to fill in the form. I don't want to score the test and put the answers into the 'results' table until the student has completed the test.

I have created variable for each response to compare them to the correct answers when I get to the scoring step.

What is the best way to store the test data into the 'results' table. I will be storing the student.id, test.id, test.date, and the response to each question and whether or not it was correct, the final score and whether or not the test has been printed.

What is the right sequence of 'use results', 'append blank', scatter memvar, then the TABLEUPDATE at the end.

Thanks,
Fred

 

[bborissov]

What I would do:
I will set Buffering = 5 && Table buffering for the Result Table. When the student start the test I will append a blank row then bind every control to appropriate field. After Student funished the test issue TableUpdate(). That way no variables are used, no scatter and gather.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.