Search options (Page 1 of 7)

Hi sparrow

Thank you for your previous reply.

My situation is a little different, so I would like to explain it in more detail.

* My **Student** list is fixed. The number of members does not change during the year.
* Each student has a fixed monthly membership fee stored in the **Student** table (field: `fee`).
* The membership fee does **not** change during the year.
* Members cannot pay less than the required amount. At the beginning of every month, the exact same amount must be recorded for every student.

I created a form (auto) with:

* ComboBox3= Year
* ComboBox1 = Month
* Button1 = Register monthly fees

When I click the button, I want one SQL command to automatically insert a record for **every student** into the `Bank` table, using:

* `id_student` = Student ID
* `monthlyfee` = Student.fee
* `id_year` = Selected year
* `id_month` = Selected month

You suggested using:

```sql
INSERT INTO bank (id_student, monthlyfee, id_year, id_month)
SELECT id, fee, 2, 1
FROM student;
```

Should I execute this SQL in the **Button → SQL Query** action, or should it be executed from **Pascal Script** (for example using `SQLExecute`)?

Also, I have attached a **simplified sample** of my project. If necessary, I can attach the complete project as well.

Thank you for your help.

Hi guys
in the attached project I used a combobox (Form 2)
what I need is that Elementary teachers should only be visible for the user "Derek" and high school teacher should be visible for "Identity"
but that combobox shows all the teachers for both users.
How can I fix it?

expense tab in the frmMain has empty fields

i used a script but it shows an error

I read the parts of documentation related to thousand separator but unfortunately I couldn't find any answers
So I tried chatgpt 
it gave me two options:

procedure Form1_OnShow(Sender: TObject; Action: string);
var
  Total: Double;
begin
  Total := Dataset.Sum('Amount');
  TableGrid1.FooterText[1] := FormatFloat('#,##0', Total); // Adjust column index
end;

but dataset is not working in MVD
so there is another option suggested by chatgpt:

procedure Form1_OnShow(Sender: TObject; Action: string);
var
  qry: TDataSet;
  total: Double;
begin
  qry := SQLQuery('SELECT SUM(amount) AS total FROM sales');
  if not qry.IsEmpty then
  begin
    total := qry.FieldByName('total').AsFloat;
    TableGrid1.FooterText[1] := FormatFloat('#,##0.00', total);  // Adjust index if needed
  end;
  qry.Free;
end;

again not working
so only one option is left and thats you sparrow

hi sparrow
i have a quick question
in the last file you have uploaded, the table "Student" has 2 calculated fields:
calc_sum  &  Rem_amount
what I need to do is that when these fields are shown on the tablegrid, they should have thousand separator
is it possible for a calculated field to have thousand separator?
thanks

thank you so much sparrow
you are great
that's exactly what I had in mind.
there is only one thing
is it possible that the tuition installments are done with "percent" ?
what I need is that in the "frmtuition" when you enter a digit showing "percent" the project calculate the payment based on that percent and in another field the remaining amount is shown
or vice versa
when you enter the tuition  payment the project calculate the percent

hi sparrow and thanks a lot
1- all the patients' data are stored in just one sheet of an Excel form
2- all of the title fields of the patients are similar with different data ( each row of the Excel has about 30 cells for specific antibiotic, 30 cells for number of that antibiotic, 30 cells for unit price and 30 cells for total price) if a patient does not take a particular antibiotic, the fields regarding that specific antibiotic are empty.
3- the title of the column of the excel are the same only the number of antibiotics that each patient took is different.
4- the attached Excel is exactly the same as the original excel form but with only 10 different types of antibiotic ( the original form has 30 types of antibiotics)
thank you so much for your help

Hi Everyone
Its me again with several problems looking for solutions
I have updated the sample that "Sparrow" developed.
The price textbox (Searchform) does not work so I decided to insert an advanced search button that somehow works fine.
The patients only take medicine in 2 departments of hospital: Clinic or surgery.
so I used a checkbox and one of these 2 should always be checked.
the only problem that I have here is regarding Import button.
I have recorded many patients in Excel form and converted to CSV format but I can't import the file into the project.
I searched the forum a lot looking tor import samples but the schema of this project is different and I don't know how to import since the Excel data should be imported to different tables of the project and that's what make it difficult to import.
Please guide me through the import
thanks a lot guys specially Sparrow