Subject | Re: Opdating ID field |
---|---|
Author | mivi71dk |
Post date | 2002-08-13T06:35:52Z |
Thank you
I didn't know I could do it that way.
Michael
--- In ib-support@y..., "svein_erling" <svein.erling.tysvaer@k...>
wrote:
I didn't know I could do it that way.
Michael
--- In ib-support@y..., "svein_erling" <svein.erling.tysvaer@k...>
wrote:
> Hi Michael!more complicated...
>
> Why don't you just use a generator and do
>
> UPDATE <table>
> SET <newfield> TO gen_id(<generator>, 1)
>
> If you want them to be numbered in a particular order things get
>
> HTH,
> Set