How to ensure a char field is always filled

Anders Johansson

Delphi Developer

Sun, 27 Mar 2005 17:15:43 GMT

How to ensure a char field is always filled

SQL2000 and Delphi 6

I have a DBGrid and a table with a char(4) column, where pin's are entered.
How can I set up constraints so that ALL 4 characters are required?
How can I make sure only digits are accepted?

Thanks,
Anders Johansson

Adroit Softwar

Delphi Developer

Sun, 27 Mar 2005 21:08:06 GMT

Re:How to ensure a char field is always filled

Probably easier to us a field edit mask, with so beforepost logic.

Quote

"Anders Johansson" <anders.johans...@NOSPAMrangeservant.se> wrote in message

news:3da3f3a7$1@newsgroups.borland.com...

Quote

> SQL2000 and Delphi 6

> I have a DBGrid and a table with a char(4) column, where pin's are
entered.
> How can I set up constraints so that ALL 4 characters are required?
> How can I make sure only digits are accepted?

> Thanks,
> Anders Johansson

Mike Wals

Delphi Developer

Tue, 29 Mar 2005 21:37:40 GMT

Re:How to ensure a char field is always filled

Quote

"Anders Johansson" <anders.johans...@NOSPAMrangeservant.se> wrote in message

news:3da3f3a7$1@newsgroups.borland.com...

Quote

> SQL2000 and Delphi 6

> I have a DBGrid and a table with a char(4) column, where pin's are
entered.
> How can I set up constraints so that ALL 4 characters are required?
> How can I make sure only digits are accepted?

> Thanks,
> Anders Johansson

Anders,

Couldn't you use a constraint that checks that length of the item is 4
(t{*word*220} both sides within the len() function), then check to see if it's
numeric. If thery' ok, check for a decimal seperator in the data, and if
it's not there, then the data is ok otherwise fail.

example of check constraint (Untested, assume field name is PIN)
len(ltrim([PIN])) = 4 and isnumeric([PIN]) = 1 and charindex('.',[PIN]) = 0

Mike Walsh

Other Threads

1. How do I ensure that a component always takes up left half the screen

2. Can't read char fields having chars greater than 255

3. fill an array of pchar with char.

4. Filling a CHAR array

5. DBEdit automatic move to next field when field filled

6. Fields[0] not always Fields[0]??

7. DBGrid - lose last edited field (last visible on screen field is always NULL after edition)

8. Paint prog: Polygon filling, Ellipse filling

9. Creating new field in filled table.

10. Filling combo box with field values...