kevind
Posts: 251
|
| Posted: 10/13/2006, 1:19 PM |
|
CCS 2.x
When I validate 2 date fields I get an error.
I have field StartDate and field EndDate, both Date fields in MS Access 2000 database.
I have validation turned on for form Submit button.
I have simple rule in EndDate field of StartDate.value>=EndDate.value.
The StartDate field is hidden (I used a label initially, but validation doesn't work with one field as label and another as Textbox). The date format string is dd-mmm-yyyy, but I have tried other formats - always the 2 fields are the same formats.
All updates are straight forward, nothing custom.
When I put an EndDate earlier than StartDate the proper error msg comes up on the form:
End Date must be after Start Date
When I make sure that EndDate is equal to or greater than StartDate the validation error is not displayed. Instead I get an ODBC error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '# #'. (Microsoft OLE DB Provider for ODBC Drivers)
Can anyone think of something I'm missing here ? Where can I put debug code in the Record form to see what the SQL statement is ?
thanks,
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
 |
kevind
Posts: 251
|
| Posted: 10/17/2006, 10:55 AM |
|
Scratch that - solved, must have been some bad code generated, recreated the record form and it worked.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
|
