1

Topic: DELPHI SQL SOME CONDITIONS ONE TABLE

Hello, help who than can, a solid hour I try to solve the task (I admit still badly enough I understand SQL and functions but programming in other languages normally)
I have a basis given on MS ACCES is filled by pupils and estimations (at each pupil of 5 various estimations and each estimation in the column). In Delphi I use DBGRID for database display
The task tracking it would be necessary to make that at pushing the button in DBGRID the information only those pupils at which was deduced is 2 and unsatisfactory estimations!

2

Re: DELPHI SQL SOME CONDITIONS ONE TABLE

Select * from data t where (t.mark1 <=2) or (t.mark2 <=2) or (t.mark3 <=2) or (t.mark4 <=2) or (t.mark5 <=2)

3

Re: DELPHI SQL SOME CONDITIONS ONE TABLE

JaDi;
It is impossible. Writes not type compatibility of the data to expression of a condition of selection

4

Re: DELPHI SQL SOME CONDITIONS ONE TABLE

Delfit> writes not type compatibility of the data
DDL tables (the list of fields and types) result.

5

Re: DELPHI SQL SOME CONDITIONS ONE TABLE

Integer if I you correctly understood (Digits).