Database question

[Lightseeker]

I've got a database that has one table for students and each class the students take. There are 44 classes that the students take, each having a grade, status, and comments. I use an mshflexgrid to edit just the grades, status and comments. The course names and numbers are static so they're hard coded.

If I use an array of textboxes (to simulate a grid) with their datafields set, the database can contain lots of grades, status, and comments entries. But if I use the flexgrid, then read the entries into an array or collection, I get "error: record too large" on the update process. The textbox array is too slow and the flexgrid causes the error...?

The project uses DAO and it's not a school project, just one I wrote for one of my instructors so he could keep track of his students rather than keeping track of them on paper. He has the textbox array working copy but I wanted to give him the ability to use the grid.

Does anyone know a way to stop this from happening??

Lightseeker

 

[zemp]

For the flex grid I like to update one row or record at a time. This avoids large updates but does cause more calls to the database. However the calls are small so it works well.

I keep my data in an array and use the row number to track which array elemet I am on. When I move to a new row I check to see if changes have been made to the last row and do my update before the new row is ready to be edited. I use the enter cell event and check my flags, one for the row (or array elemnt) and one for changes. If there have been changes and the user has switched rows then I update.

Hope this helps. Thanks and Good Luck!

zemp

 

[Lightseeker]

Thanks zemp.

I appreciate your advice. I hadn't thought about using an array's elements to represent the grid and using flags to check for changes. That's a good idea

I'm workin on it now and I'll post how it goes