Aug-22-2023, 09:07 AM
Hi Forum,
My first post and also very new to Python. I need some help, please!
At the moment, when I retrieve the data from my table, it displays as below.
-------- -------- -------- --------- --
JOHN SMITH K8AC DEFAULT
DAVID SMITH C2TT DEFAULT
KEVIN HART AC2D ADMIN
JASON STATHAM T13T SUPERUSER
-------- -------- -------- --------- --
I am hoping to assign a line number to each row and at the same time stores the Primary UKey value to the line number, something like below
-------- -------- -------- --------- --
L1 JOHN SMITH K8AC DEFAULT
L2 DAVID SMITH C2TT DEFAULT
L3 KEVIN HART AC2D ADMIN
L4 JASON STATHAM T13T SUPERUSER
-------- -------- -------- --------- --
So that on the subsequent coding, I can simply retrieve the line number and edit that record rather than having to type the UKey value to identify the record I want to edit or delete. Thank you for the help!
My first post and also very new to Python. I need some help, please!
At the moment, when I retrieve the data from my table, it displays as below.
-------- -------- -------- --------- --
JOHN SMITH K8AC DEFAULT
DAVID SMITH C2TT DEFAULT
KEVIN HART AC2D ADMIN
JASON STATHAM T13T SUPERUSER
-------- -------- -------- --------- --
I am hoping to assign a line number to each row and at the same time stores the Primary UKey value to the line number, something like below
-------- -------- -------- --------- --
L1 JOHN SMITH K8AC DEFAULT
L2 DAVID SMITH C2TT DEFAULT
L3 KEVIN HART AC2D ADMIN
L4 JASON STATHAM T13T SUPERUSER
-------- -------- -------- --------- --
So that on the subsequent coding, I can simply retrieve the line number and edit that record rather than having to type the UKey value to identify the record I want to edit or delete. Thank you for the help!