topic Re: Condition limit for key table in Application Development and Automation Discussions

Condition limit for key table

Former Member — Tue, 27 Oct 2009 10:44:50 GMT

I want to create a condition table in V/05 and I can't add to this primary key with size bigger then 100. How can I add my own field into table A* with more length of fields. It is possible to add own field not in primary key or something?

Re: Condition limit for key table

Jelena_Perfiljeva — Tue, 27 Oct 2009 20:29:20 GMT

It is not feasible. 100 characters should be more than enough. If it's not, you might want to re-think your design. Condition records are supposed to be based on just a few key fields, which shouldn't be that long. Why do you need so much space?

Re: Condition limit for key table

Former Member — Tue, 27 Oct 2009 20:48:30 GMT

I must add to this condition some text fields, this is a reason and in table KONP there aren't any for this.

Re: Condition limit for key table

Jelena_Perfiljeva — Wed, 28 Oct 2009 13:14:41 GMT

Conditions should not be based on the text fields, only on the unique identifiers, such as material # or customer #. For example, if you base a condition on a material description and later someone changes the description, the condition won't work. The material number, on the other hand, cannot be changed. This is like database table design 101. Not even to mention the language aspect of the text fields.

Change your design to use unique (and short) identifiers.

Re: Condition limit for key table

Former Member — Wed, 28 Oct 2009 18:22:36 GMT

Everything is clear but how can I add longer text fields into this condition tables? This texts must be connected with conditions.

Edited by: Kosmo on Oct 28, 2009 7:22 PM

Re: Condition limit for key table

Jelena_Perfiljeva — Wed, 28 Oct 2009 18:33:08 GMT

You can't do this. Not sure how I can explain this any clearer...