PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → Validation of fields in a Table
Validation of fields in a Table
Started by brys, Apr., 26 2024 2:20 PM - 2 replies
#1
Registered member
3 messages
Posted on April, 26 2024 - 2:20 PM
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?
#2
Registered member
2 messages
Posted on April, 27 2024 - 6:56 AM
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
#3
Registered member
122 messages
Posted on April, 29 2024 - 7:52 AM
//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
→ Go back to WINDEV 2024