Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Update and Delete an ADO-Dataset
Tue, Mar 12 2013 6:56 AMPermanent Link

Peter

Hello,

i have an ADO-Dataset. Displaying my data in a bound grid using the local web server (in the IDE) works as expected.

The Database-Table contains two columns: an ID-Field (primary key, autoincrement) and a Text-Field.

my Problem:

If i want to add an entry to this table i must remove the ID-Field out of the dataset. Otherwise i get the (correct) Error-Message that the field ID cannot be modified (because of the autoincrement-property).

But if i remove the ID-Field, i am not able to update oder delete a dataset-entry. Errormessage: "Cannot find the row for updating" (because of the missing ID).

---- zippp ----

procedure TForm1.cmdInsertClick(Sender: TObject);
begin
  Database.StartTransaction;
  try
     DevServer1_PT1.Insert;
     DevServer1_PT1.Columns['Lala'].AsString:='New entry';
     DevServer1_PT1.Save;
     Database.Commit;
  except
     Database.Rollback;
     raise;
  end;
end;

procedure TForm1.cmdUpdateClick(Sender: TObject);
begin
  Database.StartTransaction;
  try
     DevServer1_PT1.Update;
     DevServer1_PT1.Columns['Lala'].AsString:='Updated entry';
     DevServer1_PT1.Save;
     Database.Commit;
  except
     Database.Rollback;
     raise;
  end;
end;

procedure TForm1.cmdDeleteClick(Sender: TObject);
begin
  Database.StartTransaction;
  try
     DevServer1_PT1.Delete;
     Database.Commit;
  except
     Database.Rollback;
     raise;
  end;
end;

---- zappp ----

How can i solve this problem?

Thanks in advance & Greetings ... Peter
---
Sorry for my weird english
Tue, Mar 12 2013 4:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< How can i solve this problem? >>

This (autoinc fields being treated as read-only) is a bug in the current
build, and will be fixed in the next build, hopefully by the end of this
week or next Monday.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Mar 13 2013 4:13 AMPermanent Link

Peter

Hello Tim,

> hopefully by the end of this week or next Monday.

sounds good. I'm looking forward to the new version! Smile

Thanks & Greetings ... Peter
---
Sorry for my weird english
Fri, Mar 22 2013 6:26 PMPermanent Link

Peter

<gently_knocking>

 any news?

</gently_knocking>

Greetings ... Peter
---
Sorry for my weird english
Fri, Mar 22 2013 6:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< any news? >>

Still working on it.  I'm making some pretty significant changes to the way
that events are dispatched in the framework in order to trim down the memory
profile of controls, and it's taking a little longer than expected.
However, the good thing is that it allows me to get rid of a lot of extra
and confusing code for IE, which will make the framework a lot more stable
and easier to change.

Tim Young
Elevate Software
www.elevatesoft.com
Image