Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Key fields in a custom table

Former Member
0 Likes
1,065

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

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

5 REPLIES 5
Read only

Former Member
0 Likes
976

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

Read only

Former Member
0 Likes
976

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.. ?

Read only

0 Likes
976

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

Rob

Read only

0 Likes
976

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.............

Read only

0 Likes
976

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

Rob