topic Re: Key fields in a custom table in Application Development and Automation Discussions

Key fields in a custom table

Former Member — Thu, 20 Sep 2007 17:31:49 GMT

I created a custom table and I tried to make all fields as 'key' fields.My table has more than 20 fields.But it does not allow me to assign more than 16 key fields.Is there any other way to provide that?

Thanks & Regards,

Savitha

Re: Key fields in a custom table

Former Member — Thu, 20 Sep 2007 17:35:08 GMT

Why do you want all fields as key? To do a SELECT using all the keys, you would have to know all of the values in advance and therefore wouldn't need a table.

Rob

Re: Key fields in a custom table

Former Member — Thu, 20 Sep 2007 17:37:25 GMT

savitha,

You can have as many key fields as you want, but you can not go over the 255 byte length for the total of all key fields. You will get a warning for over 120, as it says that there is limited functionality with a key over 120 in length.

but, I am bit confused.. y do u need all the fields as key fields.. ?

Re: Key fields in a custom table

Former Member — Thu, 20 Sep 2007 17:49:14 GMT

Naveen - I get a hard error if I try to create a table with more than 16 key fields (4.7).

Rob

Re: Key fields in a custom table

Former Member — Thu, 20 Sep 2007 18:01:16 GMT

Hi Rob,

I got this information in the same SDN search only.......

I am checking for the link... once I will get it ... i will post the link

here u go ROB.............

Re: Key fields in a custom table

Former Member — Thu, 20 Sep 2007 19:05:08 GMT

Well, it may be release dependent. I did get a hard error.

Rob