Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
5
Erster Beitrag:
vor 4 Jahren, 8 Monaten
Letzter Beitrag:
vor 4 Jahren, 8 Monaten
Beteiligte Autoren:
Yogi Yang, DerekT, Allard, Paulo Oliveira

Need advise on this Analysis

Startbeitrag von Yogi Yang am 20.05.2013 13:49

This is the Analysis of a personal accounting system that was originally developed in Delphi 3 in 1999 and then just recompiled again in Delphi 7 many years later. The software is using BDE (a .dbf based data file system).

[attachment 354 Ana.jpg]

Here wfCO stores main company details, myCo stores sub company/department info, myIT stores Items info, mySL stores Ledger info, myPW stores User name and Password info for login, myTR stores all pre defined accounts info, myVR stores all vouchers info and myAna stores master Analysis code.

As you can see none of the tables are related/linked to each other in any way. All the requied data loading is done in code but as WD allows one to do something easily without over too much coding I would like to know if anyone suggest me as to what changed should I make to this analysis so that it works properly in WD and reduces my coding work?

TIA

Yogi Yang

Antworten:

Hi,
Well you could add relations between the files. A cool feature hyperfile gives you is that you can specify whether a related file should be mutated as well or absolutely not.

Say for instance you have an order file and a orderline file. The order file has the order and the specific lines of the order or in the orderline file. You can specify that if an order is deleted than the orderlines with the same Id ( secondary key) will be deleted as well. I you specify this a deletion of an order results automaticly in the deletion of the orderlines as well, no coding needed.

Regards
Allard

Just add a relationship in the analysis and you will see what I mean

von Allard - am 20.05.2013 23:29
Quote
Allard
Just add a relationship in the analysis and you will see what I mean

Thanks,

I am aware about that. I have used such features in other RDBMS.

Will try that out with HF also.

Regards,

Yogi Yang

von Yogi Yang - am 21.05.2013 06:32
The links can help you in some other situations.
what about the quality of the data, if you defined the links you can ensure that you can´t add departments for one company that doesn't exist and so on.
If you decide to use queries the links can help you in the JOINS.

I didn't check you analysis in detail but it looks that you need to define some more keys to use
links and probably they can improve the performance of your app.

von Paulo Oliveira - am 21.05.2013 08:58
Quote
Paulo Oliveira
The links can help you in some other situations.
what about the quality of the data, if you defined the links you can ensure that you can´t add departments for one company that doesn't exist and so on.
If you decide to use queries the links can help you in the JOINS.

I didn't check you analysis in detail but it looks that you need to define some more keys to use
links and probably they can improve the performance of your app.


Treat this one with caution - my experience with the query generator (especially from v17) is that all, or many, of the files with links to main file selected and quite often included in the generated joins regardless of whether they are contained in the query.
Then you get the 'There are x ways of doing this, please select' window which provides a number of unusable solutions.

von DerekT - am 22.05.2013 08:42
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.