[ic] Creating UNIQUE NUMBER
Kevin Walsh
interchange-users@interchange.redhat.com
Tue Mar 19 03:47:00 2002
> etc/new.number
>
> set it as follow:
>
> #COUNTER-1.0
> what every you want number to start from eg. TEST000
>
> ...snip...
>
> Database mydb COLUMN_DEF "my_id=INT(9) NOT NULL PRIMARY KEY"
>
You will not be able to store a value like 'TEST000' into an
INTEGER column. Try some form of CHAR column type instead.
--
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin@cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/