topic Unique Key creation in Application Development and Automation Discussions

Unique Key creation

Former Member — Wed, 20 Feb 2008 10:48:36 GMT

Hi gurus,

Can anybody help me out in creation of unique key table. My problem is if suppose say country is there as a field and in that field i have to enter 10 entries say hyd, bbsr, chennai...my problem is say if i enter bbsr and the next time if i wrongly enter the bbsr again then the system should promt entery already exist. And one more thing there should not be any foreign key relation with the table, i can create foreign key relation but with out that.

I just want to know can we give that unique key to the field.

so that the entries that we are give should not be repeated.

Please help out its very very urgent for me.

Thanks in Advance.

Re: Unique Key creation

mahaboob_pathan — Wed, 20 Feb 2008 11:08:14 GMT

hi,

while creating the table

select both the check box's in data element

when u enter the field name.

and save and activate it.

Re: Unique Key creation

Former Member — Wed, 20 Feb 2008 13:36:49 GMT

hi,

u can do it by eithr way u may click check box in front of field while creating table and activate it so that field is declared as a key or when u using that table in ur program while declaring that table in data declration explicitly declare that field as key by writing AS KEY FIELD.. in front of the declaration of table

thanks

Please give points