Table Creation & Primary Keys

[Former Member]

Hi there

I have a table with the 1st 3 fields as primary keys. I now need to change this to other fields.. But these fields are in the middle of the table. Apparently the primary keys must be the first fields in the table so I have to move the fields I need up. The problem is it will influence my XI/PI development cause Im using substrings to get the correct fields and If I change the order of the fields my interfaces will not work anymore.. I there a way to set the primary keys without changing the order of the fields?

Thanks,

Jan

[Former Member]

Hi Jan,

I think there is no other way to do it. All the primary keys should be declared in continuation at the begining of the table. Try to change your XI/PI development according to these entries.

Regards,

Swapna.

[Former Member]

hi,

primary keys should be declared at the begining of the table.....

thanks

[Former Member]

Hi:

Take that another field as secondary key.

Regards

Shashi