2007 Sep 20 6:31 PM
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
2007 Sep 20 6:35 PM
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
2007 Sep 20 6:37 PM
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.. ?
2007 Sep 20 6:49 PM
Naveen - I get a hard error if I try to create a table with more than 16 key fields (4.7).
Rob
2007 Sep 20 7:01 PM
2007 Sep 20 8:05 PM
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |