Ok, a question on saving…
I have a fpSpread control on a form, that is bound to a mdb database. I’ve selected all the rows from one table, and they display in the spread.
I’ve set the DAutoSave=False, and the user has a 'SAVE’ button that runs the DataSave method.
I’ve also added a few extra rows to the spread, for new records, by setting the .maxrows = fpSpread.DataRowCnt +5
When I add a new record to the first blank row, and click on save, the new record does not get written to the database – if I exit and re-start the program, I can see the record does not exist in the spread. I also checked the mdb file, and the record is not there either.
In the save subroutine, if I loop thru the columns in the row and set the .setcelldirtyflag to true for each cell before I save, when I save, the new record is there, but the record in the previous row of the spread is also updated with the same information.
Does anyone have any suggestions? Or, does anyone have a sample program that can has an add and delete working with a bound fpSpread control? I’m really at a loss here…