Update on "boolean" not working when using SubmitChanges()

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
drichter
Posts: 20
Joined: Fri 21 Aug 2009 14:44

Update on "boolean" not working when using SubmitChanges()

Post by drichter » Mon 31 Aug 2009 13:25

When i update the a boolean value of my table/entity, it's not commited to the DB when calling SubmitChanges()...
Generally the update is working because all other updated fields are commited correctly...

Whats wrong here?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 04 Sep 2009 10:05

I have tried the following code with the 4.55.39 version of dotConnect for PostgreSQL.

Code: Select all

      DataContext1.DataContext1 ctx = new DataContext1.DataContext1();
      var query = from a in ctx.Booleantables
                  where a.Integercolumn == 1
                  select a;
      Booleantable row = query.First();
      row.Booleancolumn = true; //false ->true
      ctx.SubmitChanges();
The update works. Please update to the 4.55.39 version.

drichter
Posts: 20
Joined: Fri 21 Aug 2009 14:44

Post by drichter » Fri 04 Sep 2009 10:09

Actually, i found out that these fields are also "auto generated values", like i mentioned in this topic: http://www.devart.com/forums/viewtopic. ... 58aa8da7d5

so, this is the actual problem here..

Thanks.

Post Reply