Check duplicate values in a portal

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

Check duplicate values in a portal

Postby Karel Broer » Tue Nov 09, 2004 10:10 pm

I do have this issue...

I want to check of the number that I type into a field (in a portal) allready exist in the same field from other records (in same portal).

Is there a neat way to do this (besides a loop script..) ?
Karel Broer
ServoyCamp - http://www.servoycamp.com
User avatar
Karel Broer
 
Posts: 779
Joined: Mon May 03, 2004 12:49 am
Location: Doetinchem

Postby david » Tue Nov 09, 2004 10:17 pm

Check out the tip by Enrico posted today at Servoy Magazine. Put this question in the comments section and I'm sure he'll come up with the SQL statement you would need to use for a portal field uniqueness check. It would be good to have this extension to the tip documented.

Good question!

David
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Postby Karel Broer » Tue Nov 09, 2004 11:28 pm

Thanks David! So I did... :wink:
Karel Broer
ServoyCamp - http://www.servoycamp.com
User avatar
Karel Broer
 
Posts: 779
Joined: Mon May 03, 2004 12:49 am
Location: Doetinchem


Return to How To

Who is online

Users browsing this forum: No registered users and 3 guests