Page 1 of 1
VL SP2 Identity Column
Posted: Fri May 18, 2018 12:29 am
by jyoung
Not really a question or an answer and I don't know when this showed up, I assume in SP2.
- Capture.PNG (7.84 KiB) Viewed 12863 times
- Capture2.PNG (4.19 KiB) Viewed 12863 times
No more System Variables for Identifiers!
This makes me happier than it probably should. Lol.
-Joe
Re: VL SP2 Identity Column
Posted: Mon May 21, 2018 2:41 pm
by bark
Hi Joe
You assume correctly. I found this in the SP2 readme
- SP2_identity column.JPG (72.56 KiB) Viewed 12834 times
Re: VL SP2 Identity Column
Posted: Wed May 23, 2018 11:08 pm
by atostaine
Can the returned RRN not equal the actual RRN? I think it's possible to increment the next value outside of an insert.
ALTER TABLE ORDER
ALTER COLUMN ORDERNO
RESTART WITH 5
Re: VL SP2 Identity Column
Posted: Thu May 24, 2018 8:41 pm
by Stewart Marshall
jyoung wrote: Fri May 18, 2018 12:29 am
No more System Variables for Identifiers!
This makes me happier than it probably should. Lol.
-Joe
Me too.
Oddly though, after 25+ years incrementing a number by one, I recently encountered the idea that all identifiers should probably be 10 digit Base64 randomised values, giving 1,152,921,504,606,846,976 possible values.
Re: VL SP2 Identity Column
Posted: Wed Jun 27, 2018 4:09 am
by atostaine
I just submitted an incident. We are seeing the identity column check disappearing when checking out a file for update.
Art