topic Re: Views and key fields in Application Development and Automation Discussions

Views and key fields

Former Member — Thu, 29 Mar 2007 21:20:41 GMT

I've creted a view and it has marked every field as the key. How do I uncheck the ones I don't want as the key?

Re: Views and key fields

Former Member — Thu, 29 Mar 2007 21:27:33 GMT

Hi,

<b>View never has key fie</b>lds. The tables of the view has key fields.

What do you mean by key fields in view? Please clarify.

Regards,

Re: Views and key fields

Former Member — Thu, 29 Mar 2007 22:36:29 GMT

What type view are you creating?

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 12:58:55 GMT

when you go into SE11 and look at the talbe every fiekd is checked in the key column

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:13:41 GMT

Hi Mick,

You must be looking at one of the tables(joined in the view) in SE11. If you want to remove fields as keys in a table, you'll be able to do it in SE11.

But if you want to keep the table as it is and create a view, then all the key fields of the tables have to be included in the view.

regards,

Rohit

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:22:06 GMT

I am looking at the view I created and every field is marked as a key. Is this the way it shuold look? I was expectiong to see only the keys from the tables marked as key fields in the view

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:25:54 GMT

Yes, only the fields which are keys in their respective tables will be marked as key in the view also.

Have you included all keys from the tables?

regards,

Rohit

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:39:51 GMT

I am creating a database view. maybe all fields should have a check by them in the key column but that seems odd. the fields are not all keys from the tables though

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:41:30 GMT

I have included all keys form the tables but what i am seein is that in the view every field is marked as key. How do I rmeove the ones that should not be checked. I don't know how that happened but it should not have all marked

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 13:45:36 GMT

If you do not include all key fields in all tables in your view, the system will automatially make every data field also as key field.

Also, the key fields in the table will also be marked as key in the view but other fields will not be marked.

Re: Views and key fields

Former Member — Fri, 30 Mar 2007 14:08:12 GMT

i FOUND OUT MY PROBLEM. THE KEYS FIELDS MUST ALL BE AT THE TOP OTHER WISE IT WILL MARK ALL. I MOVED THEM TO THE TOP AND IT WORKED.

THANKS