[Gambas-user] Error DataBrowser?

T Lee Davidson t.lee.davidson at gmail.com
Wed Aug 31 00:42:54 CEST 2022


On 8/27/22 10:35, Hans Lehmann wrote:
> 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?
> 

File a bug report?


-- 
Lee


More information about the User mailing list