CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 how to cheak before inserting record in database :-(

Print topic Send  topic

Author Message
Imran
Posted: 04/30/2004, 11:48 PM

:-(:-(:-(:-(


HI
I am newbie to CCS. I am not able to understand how can I cheek any condition before inserting the new record for example I have Social Security Column in my form where I taking values to store in database but before inserting the record I want to make sure this Social security number is not there to avoid duplication or errors. I figure out in CCS there is Before insert function in which I can retrieve the record which is associated with that given social security number and If that social security number is there then how I stop the execution of that insert statement can any one pls give me some direction
Thanks
Imran:-(
peterr


Posts: 5971
Posted: 05/01/2004, 12:48 AM

Set the "Unique" property of a field to prevent duplicates.
Or you can implement custom validation as shown at:
http://docs.codecharge.com/studio/html/ProgrammingTechn...Validation.html
http://docs.codecharge.com/studio/html/ProgrammingTechn...Validation.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.