[Gambas-user] DataView Help
chrisml at deganius.de
Thu Jul 13 13:44:42 CEST 2023
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
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. :-)
[x] nail here for new monitor
More information about the User