Wie drucken Sie Name und Note in FASTREPORT?

[haentschman]

...see previous post.

Three Questions:
1. you programming for yourself?
2. you use a version control system?
3. which delphi version do you use -> add this to your profile.

[Alg2009]

Zitat von haentschman:

...see previous post.

Three Questions:
1. you programming for yourself? yes
2. you use a version control system? no
3. which delphi version do you use -> add this to your profile. ok

Do you want to help me?

[haentschman]

Zitat:

Do you want to help me?

whereby? The project you have...

Zitat:

you use a version control system? no

GIT video tutorial with TortoiseGIT (GUI): https://www.youtube.com/channel/UCO2...8iSssbN66eECLA
GIT TortoiseGIT install: https://www.youtube.com/watch?v=fNPLuJTTto0

...if you want "command line", you found more videos/tutorials.

[Alg2009]

What do I do with the TortoiseGIT!?
I no longer understand what you mean?

i have a simple question and you have the answer why don't you give me the answer instead of asking me to install program that I don't want

[haentschman]

Hi...

Zitat:

i have a simple question and you have the answer why don't you give me the answer

The answer you have! You just have to deal with it and see what has changed in the source code. https://www.delphipraxis.net/1473854-post19.html

Zitat:

instead of asking me to install program that I don't want

Then I can not help you anymore. You have not understood what a version control system is needed for and why it is needed. The links was only for information...

...i am out.

[Alg2009]

Zitat von haentschman:

...see previous post.

Forgive me and thank you very match
i didn't see The attached file in the previous reply

I benefited a lot from you and learned new things like "TfoSettings" Which I did not understand and why you added a new Unit? I will try to understand it

thank you very very match haentschman for your help

[Alg2009]

Believe me, you gave me a code that I've never seen before so understanding it sounds difficult.
You have added things that I did not know like(New unit)

Now i understand you why you asked about 'Version control System'

I'll be in hiding for two or three days to understand what you explained to me earlier and I'm back
By the way the code did not work

[Klaus01]

you can remove these 5 Units from the uses that are underlined.

Grüße
Klaus

[haentschman]

Sorry. These units mad* was automatic add to the project. This is a tool to finding errors... I should have to delete them for you.

Zitat:

By the way the code did not work

...i know. It's an easy mistake that I have left as it is...from me. You have to find it out yourself. Write the error message here.

Zitat:

what i do:
* formatting
* naming
* SQL was wrong
* assignment of the query to the report
* delete unused report datasets
* editing report

formatting:
http://docwiki.embarcadero.com/RADSt...ng_Source_Code

naming:
* All components should have a prefix. 2 to 4 signs. example: fo = Form, edt = Edit, mem = Memo and so on... You can choose it yourself.
previos Unit6 -> Settings only the name has changed!
previos TForm6 -> TfoSettings only the name has changed!
https://wiki.delphi-jedi.org/wiki/Pr...ge_Style_Guide

SQL was wrong:
...you can see (btnParamètresClick)

assignment of the query to the report:

Delphi-Quellcode:

dmData.frxDatasetReportMaster.DataSet := dmData.qryReport;
dmData.frxEtudiant.ShowReport;

delete unused report datasets:
...from the DatamoduleEtudiant.

editing report:
New names assigned to the report.

[Alg2009]

Hello,

Zitat:

It's an easy mistake that I have left as it is...from me. You have to find it out yourself. Write the error message here.

The error was in the connection settings

I almost visit GitHub website and i didn't know it is a repository thank you for all the information that will help me in the future


There is only one last question
You said

Zitat von haentschman:

- Never use DB tables. Better use Querys.

That's means i link all the tables together with JOIN(inner,Left or Right) the question is If, for example, we add another table to the database let it be 'Group' -->the relation between Student and Group is one to many(Each student has one group, and each group has more than one student)

We write two queries the first to show the students and their grades And the other to show the students and their group or only one query ?

because if we write one query the result it will be wrong

Code:

SELECT E.ID, E.NOM, E.PRENOM, GroupName,LE.NOMLECON, LE.NOTE FROM ETUDIANT E
JOIN ETUDLECON LO ON E.ID = LO.ID
JOIN LECON LE ON LO.LECONID = LE.LECONID
JOIN Group G ON G.GroupID = E.GroupID