SQL help

[Ruslan Zasukhin]

On 1/3/14, 4:46 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:

> I've been thinking that a sequence maintained with a trigger might be
> very useful for other things too. I never thought of numbering
> sequentially the voyages of each vessel. It solves some other
> problems. Right now voyage numbers increment from zero at the start of
> each new year (which is what caused the problem) but there is no
> reason why I can't have an extra field which has every voyage for that
> vessel down through the years.

Do you talk about CERATE SEQUENCE?


For simple case, consider SERIAL32 or SERIAL64 pseudo-types,
As even more simple things.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]