table field validation

[gogaak]

hi,

instead of providing validation at the client side or in the server script....
cant i provide validation in the tables fields...
I have a field named YearID, datatype text..

But I want to allow only text like this ==>
e.g. 'F-00'
'F-01'

Do I have to put any format property...
please do help...
thank u.

 

[wazz]

instead of providing validation at the client side or in the server script....
cant i provide validation in the tables fields...

yes

I have a field named YearID, datatype text..
But I want to allow only text like this ==>
e.g. 'F-00'
'F-01'
Do I have to put any format property...

Set the input mask to Upper Case Letter, Hyphen, Number, Number.
Something like: >L\-00

Search for Input Mask Syntax

w