March 17th, 2004, 09:28 AM
Generating big numbers
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 ?!
March 17th, 2004, 02:38 PM
in FB1.5 use BIGINT
Originally Posted by chiticco
Romania it's a beautiful country ... too bad that it's populated with ... peoples!
March 18th, 2004, 03:33 AM
Ok..thanks..But still, is there a way to create formated fields from different types ? I know that is CAST word, but what about the format I've described up ?