PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Validation of fields in a Table
Validation of fields in a Table
Iniciado por brys, 26,abr. 2024 14:20 - 2 respuestas
Miembro registrado
3 mensajes
Publicado el 26,abril 2024 - 14:20
Hello, I have a Table control directly bound to a data file.
I want to be able to make some validations before the user input is sent to the database.
I'm struggling to understand what I should do and where.

Can you help me?
Miembro registrado
2 mensajes
Publicado el 27,abril 2024 - 06:56
With high likliness you want to do somthing in the Whenever Modifying even
or in the Deactivate Event, maybe you want to save some state while activating

// In Entry of the Column
vSavedVal = MySelf


// In whenever modifying Control
IF MySelf = "Test" THEN
Info("I don't like that value, resetting");
MySelf = vSavedVal
END
Miembro registrado
122 mensajes
Publicado el 29,abril 2024 - 07:52
//Exit from a row of <TableControl>

//Sample avoid same Values on two Fields
IF MySelf.InputInProgress() THEN
IF COL_Field1 = COL_Field2 THEN
Error("Fields cannot have the same Value")
ReturnToCapture()
END
END