Feedback on 7.0.0
Posted: 13.03.2012, 08:11
Hi,
just started some basic tests with the lib. Using fpc(9.30?), firebird 2.5.
1. I need lookup field. Had to add it to inactive dataset. But then other fields are not autobuilt from db(FDefaultFields becomes false). Had to add all the fields manually.
2. dataset has option set to update only changed fields. I edit some field a few times(and save DS each time), then set it to the initial value and save. It fails, because some metadata sql is executed + it is formed invalidly. Field is not recognized as changed? changed option to update all fields - now it works.
3. I have several DS open at the same time, and need to save them together. There is no support for that. I read that old Delphi connection had smth to update several datasets at once. If one ds fails during update, then other is left in invalid state(using ApplyUpdates). Edited lib's source to support that(WriteUpdates/CommitUpdates)
4. I have several DS open, and they are in master/details relation. After the save if you navigate to other parent row and then back - it shows old values in child rows. But DB is updated properly.
just started some basic tests with the lib. Using fpc(9.30?), firebird 2.5.
1. I need lookup field. Had to add it to inactive dataset. But then other fields are not autobuilt from db(FDefaultFields becomes false). Had to add all the fields manually.
2. dataset has option set to update only changed fields. I edit some field a few times(and save DS each time), then set it to the initial value and save. It fails, because some metadata sql is executed + it is formed invalidly. Field is not recognized as changed? changed option to update all fields - now it works.
3. I have several DS open at the same time, and need to save them together. There is no support for that. I read that old Delphi connection had smth to update several datasets at once. If one ds fails during update, then other is left in invalid state(using ApplyUpdates). Edited lib's source to support that(WriteUpdates/CommitUpdates)
4. I have several DS open, and they are in master/details relation. After the save if you navigate to other parent row and then back - it shows old values in child rows. But DB is updated properly.