Row ID, autonumber

[cholotron]

Good Morning All,

Is there a way to number rows?

Columns
so_num, so_line
6868,1
6868,2
6868,4
6868,5

to

so_num, so_line, my_rownumber
6868,1,1
6868,2,2
6868,4,3
6868,5,4

thank you all

 

[mirtheil]

Nope, there's no way I'm aware of. PSQL doesn't support the ROWID function.

What are you trying to accomplish with the rowid?

Mirtheil

http://www.mirtheil.com

 

[cholotron]

Hi, thanks for you replay

Users complain that when they delete a "row" on our sales orders, our ERP does not "re-number" the SO Lines, according to them
it looks like something is missing, they want to avoid manually changing it.

I just wanted to know if with a SQL Script I could fix it.

thnks

john