+- Atozed Forums (https://www.atozed.com/forums)
+-- Forum: Atozed Software (https://www.atozed.com/forums/forum-1.html)
+--- Forum: IntraWeb (https://www.atozed.com/forums/forum-3.html)
+---- Forum: English (https://www.atozed.com/forums/forum-16.html)
+----- Forum: IntraWeb General Discussion (https://www.atozed.com/forums/forum-4.html)
+----- Thread: Editing databasefields (/thread-1585.html)
Editing databasefields - PaulWeem - 03-11-2020
Hi,
I am using Delphi 10.3.3 and Intraweb Ultimate 15.1.16
As far as I know, when using an IWDBEdit, you cannot edit the field as long as the DataSource is not in editmode.
I have some IWDBEdit components on my form. When I open the Dataset, I can edit the contents of any IWDBEdit on my form, and when going to the next record, these changes are stored in the database.
Even if I use an IWDBNavigator, without putting the DataSource in editmode, I can change content in IWDBEdits, which is then stored in the database without pushing the "Post" in the Navigator.
Am I assuming something that isn't there, or is this a real issue?
Regards, Paul
RE: Editing databasefields - PaulWeem - 03-11-2020
(03-11-2020, 09:35 AM)PaulWeem Wrote: Hi,
I am using Delphi 10.3.3 and Intraweb Ultimate 15.1.16
As far as I know, when using an IWDBEdit, you cannot edit the field as long as the DataSource is not in editmode.
I have some IWDBEdit components on my form. When I open the Dataset, I can edit the contents of any IWDBEdit on my form, and when going to the next record, these changes are stored in the database.
Even if I use an IWDBNavigator, without putting the DataSource in editmode, I can change content in IWDBEdits, which is then stored in the database without pushing the "Post" in the Navigator.
Am I assuming something that isn't there, or is this a real issue?
Regards, Paul
Update:
It seems IWDBEdits "think" a Dataset is in editmode.
When I add "Dataset.edit;" and "Dataset.Cancel;" after opening the Dataset, everything works as expected.
I verified this workaround on your FishFact demo, as this behaviour was reproducable in this demo.
Regards, Paul