• Registered: 2026-02-19
  • Posts: 24

Topic: SQL Query

I have a table (Cassa) with the fields
(Giorno, Cifra, record_count, id_Nuova_Causale, Anno).
I need to select all the records in the table with the value
Anno = 2025
and display the updated TableGrid1 with only those values.
I've tried everything, but it doesn't work.
Can someone give me an example of how to write the script? Thanks.

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,991

Re: SQL Query

You don't really need to write any script.  Just use the standard 'search' function (see attached).
Derek.

Post's attachments

Attachment icon ansel.zip 440.37 kb, 13 downloads since 2026-02-24 

3 Reply by Destiny (edited by Destiny 2026-02-24 16:52:19)

  • From: Crozon
  • Registered: 2021-05-05
  • Posts: 406

Re: SQL Query

Hi Derek, I found this one which searches by checkbox.

Post's attachments

Attachment icon Search by year.zip 353.2 kb, 26 downloads since 2026-02-24 

Destiny
  • Registered: 2026-02-19
  • Posts: 24

Re: SQL Query

Thanks