[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Creating UNIQUE NUMBER
> 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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/