March 17th, 2004, 01:38 PM
|
 |
Contributing User
|
|
Join Date: Jun 2003
Location: Bucharest
Posts: 72
Time spent in forums: 2 h 18 m 28 sec
Reputation Power: 10
|
|
Quote: | Originally Posted by chiticco Hi, please give me some clues abot my problem please:
how can I generate big-unique numbers for a field through a procedure or a trigger ? I want to insert automatically in a field big and unique numbers(8-10 numbers long) when I do an INSERT action. Maybe if I can code the number like:
DDMM(day and month)0000XY (it must be 10 numbers long, not less so I fill to the right with 0-es). As you can see the field is VARCHAR(10) but it can be an INTEGER as well, only that I don't know how to do it(setting a generator in advance with value = 1000000000 is ok ? Isn't it too big for a generator ?).
Can I do that in a Firebird action ?! |
in FB1.5 use BIGINT
__________________
Romania it's a beautiful country ... too bad that it's populated with ... peoples!
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Generating big numbers
Linear Mode
