[Gambas-user] DataView Help

[Christof Thalhofer]

Dear Gian,

Am 13.07.23 um 13:10 schrieb Gianluigi:
> Il 13/07/23 12:15, Gianluigi ha scritto:
>> Il 13/07/23 00:38, Gianluigi ha scritto:
>>> Il 12/07/23 20:46, Christof Thalhofer ha scritto:

>>>> For instance if in a (RDBMS) database schema there are no primary 
>>>> keys defined or if theŕe are no relations defined with foreign keys 
>>>> pointing to specific primary keys Gambas will not prevent the user 
>>>> from creating orders for nonexisting customers.
>>>>
>>>> This is one of the core tasks of an RDBMS.
>>>>
>>>> As I recall, you once tried to convince me that you didn't need 
>>>> primary and foreign key constraints ("referential integrity is not 
>>>> used in professional databases"), that it was too special, and that 
>>>> yes, Gambas could do it all.

...

> I forgot, I'd really like to know where you saw an example of my 
> database with tables without primary keys, I have no idea how you could 
> figure that out...

I didn't say that. I wanted to show an example of possible errors in the 
creation of a database schema, which an inexperienced user can make. You 
can build a Gambas application on top of that but sooner or later you 
will get crippled data.

Btw, I think this is a bit off-topic now. For others ... this adresses a 
private discussion, Gian and I had about the importance of referential 
integrity in RDBMS together with Gambas applications on top of it. In 
this context it may be of general interest after all, which is why I am 
answering here.

And Gian, AFAIK the only mail from you that I didn't answer was the one, 
in which you told me that you "think the opposite". Ok, I can tell 
things based on experience, but if you answer me that you think the 
opposite, I'm done. If that's what you'd like, think the opposite, I 
won't try to convince you further.

And don't worry, I'm not offended. :-)

Alles Gute

Christof Thalhofer

-- 
[x] nail here for new monitor