updating table contents

[mikemalin]

Let's say I have a table that has two columns: UID and Description.
For example:

UID Description
1 Alpha
2 Beta
3 Gamma

Now let's say I want to change it a little to something like:

UID Description
1 Alpha
2 Beta
3 Delta
4 Gamma

Is there any code I could run to achieve this? One thought, although
I'm not sure if this would work, would be to find UID 3 in the table
and change it to 4 then add the new "3-Delta" item to the table.

Any help is appreciated.

TIA.
Mike

 

[carina ferreira]

Let's say I have a table that has two columns: UID and Description.
For example:

UID Description
1 Alpha
2 Beta
3 Gamma

Now let's say I want to change it a little to something like:

UID Description
1 Alpha
2 Beta
3 Delta
4 Gamma

Is there any code I could run to achieve this? One thought, although
I'm not sure if this would work, would be to find UID 3 in the table
and change it to 4 then add the new "3-Delta" item to the table.

Any help is appreciated.

TIA.
Mike

 

[Mike]

Did something not get posted with your message?