UltraGrid SQL update only visible rows

111 Views Asked by Marvin L At 12 April 2025 at 18:12

I have a ultragrid table with filled data:

I want to set the visible rows to kd_aktiv = 0

I have a

`foreach` (`UltraGridRow` row in `ultraGridVorgaenge.Rows`)

at the moment and then a command like this "UPDATE KUNDEN SET KD_AKTIV = 0" but it updates all of the customer to 0 but I want only the visible.

Do I have to do it with a where at the end of the SQL statement?

There are 0 best solutions below