[Gambas-user] DataView Help

[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:
>>> Dear Gianluigi,
>>>
>>> Am 11.07.23 um 16:06 schrieb Gianluigi:
>>>
>>>> here, what you just pointed out brings back to why I insist with Hans
>>>> that we want to use the tools that Gambas makes available to us.
>>>>
>>>> Not everyone who writes small business programs has the experience 
>>>> that
>>>> Benoit has, that you have or Shordi has, to name a few that we all 
>>>> know.
>>>>
>>>> Gambas shields us from so many mistakes, we only need to be smart 
>>>> enough
>>>> to understand how these tools work (of course I am talking about 
>>>> myself).
>>>
>>> Gambas cannot shield the user from caveats of the design of the 
>>> underlying database schema.
>>>
>>> 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.
>>>
>>> What is very nice about Gambas is that it makes a lot of things 
>>> easier when dealing with databases. But it doesn't change the fact 
>>> that you have to understand what the database is doing underneath. 
>>> Ignoring that can lead to very, very costly errors.
>>>
>>> I've learned this the hard way. And if, on the one hand, you concede 
>>> that I understand something about the subject, you should also take 
>>> that into account when I give advice.
>>>
>>> Alles Gute
>>>
>>> Christof Thalhofer
>>>
>>>
>>> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
>>
>>
>> Hi Christof,
>>
>> Taking one sentence out of a larger context does not get the point 
>> across.
>> Can you explain what referential integrity is for in a report where 
>> there is no deletion or modification of records?
>>
>> I have never hidden that I am an amateur and am willing to follow 
>> your suggestions, but I have never received any from you.
>> All the times I asked a question you never answered.
>>
>> Alles Gutte to you as well
>>
>> Gianluigi
>>
>>
>> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
>
> Hi Christof,
>
> When I refer to your lack of help, I am of course referring to my 
> questions about databases.
> You have helped me many times and for that I am grateful and I hope I 
> have not offended you.
> When I talk about 'report' of course I am referring to the 
> relationship between tables.
>
> Regards
>
> Gianluigi
>
>
> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----

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...

Gianluigi