Atozed Forums
Editing databasefields - Printable Version

+- Atozed Forums (https://www.atozed.com/forums)
+-- Forum: Atozed Software Products (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