Wie drucken Sie Name und Note in FASTREPORT?

[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

[haentschman]

Hi...

Zitat:

The error was in the connection settings

This is what i mean with the INI File. If is the connection hardcoded...what happens when you give your friend the EXE? Exactly that... That's why the settings should be written to an INI.
http://docwiki.embarcadero.com/Libra...Files.TIniFile

Zitat:

There is only one last question

The difference is:
With a table all records are always read...even those from 10 years ago.
With a qery you can get only the records of the last year...if you want.
Otherwise the "operation" is the same...

Zitat:

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 ?

If you want so... The SQL, with a query, creates the data.

Zitat:

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

This not a TQuery problem...it a SQL problem. Also the database structure must fulfill rules. (ForeignKey) I dont know what you want to see...
SQL information (you know):
https://www.w3schools.com/sql/
Database information:
https://en.wikipedia.org/wiki/Database_normalization

Zitat:

I almost visit GitHub website and i didn't know it is a repository

Once again to Git:
You don't have to use it. But you can use it to view the changes since the last save in the repositoriy. See picture1. More important is that you can reset the changes.
GIT is decentralized. You have one repository locally and one "copy" externally (GitHub, BitBucket)
You start only locally with GIT. (Setup: GIT + GUI Tool TortoiseGIT). Only if you cooperate with others, it is necessary to store the source code externally.
What is GIT:
https://fr.wikipedia.org/wiki/Git

Difference Tool:
BeyondCompare ...shipped with Delphi.

...to much?

Who says programming is easy? You have to learn every day.

[Alg2009]

Zitat von haentschman:

This not a TQuery problem...it a SQL problem. Also the database structure must fulfill rules. (ForeignKey) I dont know what you want to see...
SQL information (you know):

the problem was in the foreign key
thank you very very much haentschman