topic Table Creation & Primary Keys in Application Development and Automation Discussions

Table Creation & Primary Keys

Former Member — Fri, 20 Mar 2009 09:06:39 GMT

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

Re: Table Creation & Primary Keys

Former Member — Fri, 20 Mar 2009 09:16:06 GMT

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.

Re: Table Creation & Primary Keys

Former Member — Fri, 20 Mar 2009 09:22:24 GMT

hi,

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

thanks

Re: Table Creation & Primary Keys

Former Member — Fri, 20 Mar 2009 09:37:02 GMT

Hi:

Take that another field as secondary key.

Regards

Shashi