Exclusive code already exists - 1499- [message 173-13]

[Former Member]

Hi,

I am getting [ Exclusive code already exists - 1499- [message 173-13]] when i'm trying to save the specific query to relevant field

[Former Member]

Hi,

The Exclusive code exists message is explaining the fact the entry is already available in the database when a new entry is tried to be entered.

in your code you have to check if the eclusive code (docEntry or Code) exist:

example:

if code exist in db table then

   update fields

else

  add fields

end if

Regards, alessandro

[Former Member]

Hi Alessandro,

This is user defined field.

I was trying to incorporate new query... then only this message appeared.

[Former Member]

Hi,

maybe this may help you to write the correct formatted search query .

[Former Member]

Hi..

Thanks a lot...

I will try this and update you.

[Former Member]

Hi ,

I tried your solution and no any improvement.

I wanted solve the problem immediately , so i restore the previous backup and prepare the UD table again from the beginning.

anyway thanks for your assistance

[Johan_H]

Hi Sarath,

What is the relevant field ? Is it  Code or Name in a user defined table ?

If it is your own user defined field, did you add a key to that field ?

Regards,

Johan

[Former Member]

Hi John,

Thanks a lot,

This is a user defined table.

I was trying to determine the existing query by pressing [Alt + Shift + F2]

No query was appeared,

Then I tried to incorporate new query, then only this Message appeared.

In the same time can you kindly explained me the way of creating a New user in SBO please.