I usually create a table that has an integer that automatically increments when I  add records - like this :

CREATE TABLE "Office" ("RecordNum" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 100000, INCREMENT BY 1),
                      "Name" VARCHAR(60) COLLATE "UNI_CI",
                      "ID" VARCHAR(60) COLLATE "UNI_CI",
                      "Address" VARCHAR(60) COLLATE "UNI_CI",
                      "Address2" VARCHAR(60) COLLATE "UNI_CI",
                      "City" VARCHAR(60) COLLATE "UNI_CI",
                      "State" VARCHAR(20) COLLATE "UNI_CI",
                      "Zip" VARCHAR(15) COLLATE "UNI_CI",
                      "Phone1" VARCHAR(20) COLLATE "UNI_CI",
                          etc....

And it works fine adding records from the ElevateDB Manager, but when I got to insert a record using my EWB application I get the following message when I

"Database commit response error: Field 'RecordNum' cannot be modified"

I have a StartTransaction in my "BeforeInsert" event, and I give the "save" method, and I my Commit statement is in my "AfterSave" event.

Maybe I can't do this with EWB?

Thanks for any help!

Jeff

Jeff,

<< And it works fine adding records from the ElevateDB Manager, but when I
got to insert a record using my EWB application I get the following message
when I

"Database commit response error: Field 'RecordNum' cannot be modified" >>

This is most likely a bug - the dataset manager is trying to modify a
read-only field/column.  I'll make sure this is fixed in the next build.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim. I'm working around it for right now

Jeff




"Tim Young [Elevate Software]" wrote:

Jeff,

<< And it works fine adding records from the ElevateDB Manager, but when I
got to insert a record using my EWB application I get the following message
when I

"Database commit response error: Field 'RecordNum' cannot be modified" >>

This is most likely a bug - the dataset manager is trying to modify a
read-only field/column.  I'll make sure this is fixed in the next build.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Jeff,

<< And it works fine adding records from the ElevateDB Manager, but when I
got to insert a record using my EWB application I get the following message
when I

"Database commit response error: Field 'RecordNum' cannot be modified"

I have a StartTransaction in my "BeforeInsert" event, and I give the "save"
method, and I my Commit statement is in my "AfterSave" event. >>

I tried to replicate this so that I can fix it for the next minor release,
and am unable to do so.  The table definition that you posted does not cause
the column to be marked as read-only (only computed and generated
(expression) columns are marked as such), and I don't see any error when
updating the table using EWB.

Tim Young
Elevate Software
www.elevatesoft.com

I am evaluating the trial of EWB 1.03 build 7 and seem t have this same issue "Database commit response error: Field 'ID' cannot be modified

I'm using EDB as a database and the ID field is a generated auto increment field and am able to successfully add rows in EDB manager. My EWB implementation includes a dataset, grid and insert button.

Is there a work around or is this still open an open bug

Many thanks

Anthony wrote:

> I am evaluating the trial of EWB 1.03 build 7 and seem t have this
> same issue "Database commit response error: Field 'ID' cannot be
> modified
>
> I'm using EDB as a database and the ID field is a generated auto
> increment field and am able to successfully add rows in EDB manager.
> My EWB implementation includes a dataset, grid and insert button.
>
> Is there a work around or is this still open an open bug


I'm fairly sure I saw this had a workaround, but I've not done it
myself so don't remember the details. Have a trawl back in this group.

--

Matthew Jones

This has now been fixed in Version 1.04 Build 1

"Matthew Jones" wrote:

Anthony wrote:

> I am evaluating the trial of EWB 1.03 build 7 and seem t have this
> same issue "Database commit response error: Field 'ID' cannot be
> modified
>
> I'm using EDB as a database and the ID field is a generated auto
> increment field and am able to successfully add rows in EDB manager.
> My EWB implementation includes a dataset, grid and insert button.
>
> Is there a work around or is this still open an open bug


I'm fairly sure I saw this had a workaround, but I've not done it
myself so don't remember the details. Have a trawl back in this group.

--

Matthew Jones