data validation - filters and masks

Something you want to see in a LiveCode product? Want a new forum set up for a specific topic? Talk about it here.

Moderator: Klaus

Post Reply
redpill
Posts: 21
Joined: Fri Jan 08, 2010 10:38 pm

data validation - filters and masks

Post by redpill » Thu Feb 25, 2010 8:06 am

Please implement a robust data validation feature set into Revolution.

Why? To maintain consistent and accurate data entry.

Consider the very simple scenario of requiring a user to enter data into a field. This data may be part of a primary key in a database and which must not be empty. So, why waste time manually coding a data entry validation script -- for each entry field -- when one can just set an object's "required" property?

Data validation should deal with text, numbers, dates, and times. Range checking should be a part of the feature set: a number (or date or time) should not fall out of a given range.

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Contact:

Re: data validation - filters and masks

Post by Janschenkel » Fri Feb 26, 2010 2:15 pm

The rev platform is a general-purpose development tool, not a dedicated database front-end builder. That being said, validation would be nice; but some user interfaces prefer to do the validation step once, when the user clicks the 'OK' button, and other environments call for immediate validation preventing the user from leaving the field.
Also, you don't need to copy+paste the validation code into every single field: you can use behaviors to centralize logic.

Jan Schenkel.
Last edited by Janschenkel on Fri Feb 26, 2010 2:32 pm, edited 1 time in total.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10043
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: data validation - filters and masks

Post by FourthWorld » Fri Feb 26, 2010 2:31 pm

FWIW, I've started a new project at the Rev Interoperability Group to provide an open-source field validation behavior:
http://tech.groups.yahoo.com/group/revInterop/
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

redpill
Posts: 21
Joined: Fri Jan 08, 2010 10:38 pm

Re: data validation - filters and masks

Post by redpill » Sat Feb 27, 2010 5:31 am

FourthWorld wrote:FWIW, I've started a new project at the Rev Interoperability Group to provide an open-source field validation behavior:
http://tech.groups.yahoo.com/group/revInterop/
:twisted: Now I can't get rich by creating my own and charging $99.

redpill
Posts: 21
Joined: Fri Jan 08, 2010 10:38 pm

Re: data validation - filters and masks

Post by redpill » Sat Feb 27, 2010 5:37 am

Janschenkel wrote:...Also, you don't need to copy+paste the validation code into every single field: you can use behaviors to centralize logic.

Jan Schenkel.
I knew there must be a way. Thank you.

I found the information in the online Dictionary and tried the behaviors lessons. Very nice.

(Programming in Revolution is weird.)

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10043
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: data validation - filters and masks

Post by FourthWorld » Sat Feb 27, 2010 4:21 pm

redpill wrote:
FourthWorld wrote:FWIW, I've started a new project at the Rev Interoperability Group to provide an open-source field validation behavior:
http://tech.groups.yahoo.com/group/revInterop/
:twisted: Now I can't get rich by creating my own and charging $99.
That's one of the downsides to Rev's continued growth: the community is awash in code inflation, lowering the value of many individual contributions while increasing the number of those contributions. Beats the alternative, though: a Rev languishing unloved. :)

In fact, that's one of the reasons I like to provide timely notice for any open source projects I work on, helping to avoid situations where toolmakers invest a lot of time into something that's being replicated elsewhere.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

Post Reply