[Gambas-user] Error DataBrowser?

[Hans Lehmann]

Hello.

In a SQLite database table, there exists the field :

"flow_name" TEXT NOT NULL UNIQUE,

The DB fields are to be sorted:

DataSource1.Sort = "flow_name".

If I change the value of the field "flow_name" for example from 'nanu' 
to 'manu' and then save the changed record, an error message is displayed:

`Cannot modify record: Abort due to constraint violation`.

However, the record is still displayed with the changed value in the 
DataBrowser after closing the error message!

Notable:
If the record is sorted by a field other than "flow_name", the error 
does NOT occur.

What now - what to do?

With kind regards

Honsek