Harry
|
| Posted: 05/25/2002, 8:39 AM |
|
The Validation is not working properly in Code Charge Studio Beta 4. Whenever If I comment the line out ' If EditMode Then Where = " AND NOT (" & DataSource.Where & ")"
It Then Works. The only Drawback is that works great for a new record but if I Edit the record to change the password Etc.. It tells me that the Login Name is taken already.
I am using a ODBC Datasource with MSACCESS. I am using Asp 3.0 With Templates
Here is the Code below.
Function Validate()
Dim Validation
Dim Where
If EditMode Then Where = " AND NOT (" & DataSource.Where & ")"
If CInt(CCDLookUp("COUNT(*)", "Users", "Account=" & DBzdotdata.ToSQL(Account.Value, Account.DataType) & Where, DBzdotdata)) > 0 Then _
Account.Errors.addError("The value in field Login Name is already in database.")
Validation = ValidatingControls.Validate
CCSEventResult = CCSEvents("OnValidate")
Validate = Validation And (Errors.Count = 0)
End Function
'End Validate Method
Thanks
Harry
|
|
|
 |
CodeCharge Support
|
| Posted: 05/27/2002, 12:13 AM |
|
Harry,
this problem will be solved in next CCS release. Please watch the announcements.
|
|
|
|
|
