PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Relations in Windev
Relations in Windev
Iniciado por luciano3210, 20,dic. 2014 15:58 - 2 respuestas
Publicado el 20,diciembre 2014 - 15:58
I use Clarion for more than 20 years. For various reasons I'm looking for another development environment. From about 10 days I'm using the free version of Windev (Express). I know that to make good use of a new environment must "forget" the old. My greatest difficulties I found them in establishing the relationships between files. I'm used with those of clarion: one-to-may, many to one, one to one and many to many.
In Windev should be more or less the same, with the addition of cardinality. And here were born my doubts. I have seen examples that I find in the tutorial, but the answers to the questions to determine the cardinality not convince me (I would have responded differently). Also I found a study on relations at: http://www.tomjewett.com/dbdesign/dbdesign.php . and even here the examples are in contrast to what was suggested in the tutorial. If someone wants to help me in understanding it would be very happy.
Thanks and best regards

Luciano

luciano3210NOSPAM@hotmail.com
Publicado el 22,diciembre 2014 - 20:46
Hi,

Maybe it is due to strange translation from french to english ?
But you can be confident. Management of cardinalities is perfect with Windev.

ex : parent [1,1] [0,n] child
One parent may have 0 to n children.
One chlid must have 1 and only 1 parent.
Publicado el 23,diciembre 2014 - 16:00
Thanks Joel you were very clear. So I ask you: why in the tutorial n. 5 (Full application) (Windev 19 Express) we find:
Customer (0,n) > (0,1) Orders / Orders (0,n) > (0,1) Order Line /Product (0,n) > (0,1) Order Line
in Clarion I would have done:
Customer (one to may) <- ->> Orders / Orders (one to many) <-->> Order Line / Product (one to many) <-->> Order Line
Surely there is something you still do not understand...
Thanks for your kind help

Luciano