MRev

Hi Surfvite, I am coming back on this issue of single vs multiple fields constraint for defining the uniqueness of a row. You mentioned the MCD (Modele Conceptuel de Donnees), and recent trend of going for a unique field. Do you have any link to explanations on the subject. I tried to find some but could not. I need to figure out a simple solution (without going into creating a field which is the hash of the concatenation of those fields, trigger, etc.). You state it is a trend, ok. But then how...

Hello Surfvite, Thanks a lot, this solved the matter!

Hello Surfvite, Understood, thanks. Michel On Sat, Jul 16, 2022 at 7:34 AM surfvite surfvite@users.sourceforge.net wrote: Hello, Indeed, NSbase manages simple constraints, which has been the general trend for several years: simplicity of the MCD and improved performance. just convert your schema.... Unique constraint https://sourceforge.net/p/nsbase/forum/general/thread/36732a0a25/?limit=25#182e Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/nsbase/forum/general/...

Hi again! I bumped into another hurdle. I attach the app and the error message. I define a very simple test table, then created a view on it. When I make changes on fields in the table, no problem. Then I try the same change in the view, I get the attached error message. I did some tests, and it looks that it has to do with having a boolean field in the definition of the view (at least, it appears to be!). Creating an almost identical view to the first one but omitting the boolean field, no problem...

Hello! I am new to NSBase, started to play with it quite a bit, it is really a jewel of a RAD!! I have one point I could not solve so far, though: how do you define a constraint on a table where a combination of several fields has to be unique. In SQLite, I would define the constraint UNIQUE (field1, field2, ...) ON CONFLICT REPLACE, for example. I see NSBase allows a unique constraint on a single field, but did not find how to make it work on a combination of several fields. Thanks in advance! ...