PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Validation of fields in a Table
Validation of fields in a Table
Débuté par brys, 26 avr. 2024 14:20 - 2 réponses
Membre enregistré
3 messages
Posté le 26 avril 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?
Membre enregistré
2 messages
Posté le 27 avril 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
Membre enregistré
122 messages
Posté le 29 avril 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