Page 1 of 1

Unable to uncheck unique index

Posted: Tue 27 Dec 2016 13:03
by bsienn
While creating index, by default the unique checkbox is checked.
Unable to uncheck unique index check mark.

Also table names doesn't retain camel notation...?

Column already exist, already mentioned in this thread.
viewtopic.php?f=23&t=34759

Re: Unable to uncheck unique index

Posted: Tue 27 Dec 2016 15:04
by alexa
While creating index, by default the unique checkbox is checked.
Unable to uncheck unique index check mark.
You need to unselect the 'Unique' property in the right section of the window.
Also table names doesn't retain camel notation...?
Column already exist, already mentioned in this thread.
viewtopic.php?f=23&t=34759
We will investigate this when developing the next product builds.

Re: Unable to uncheck unique index

Posted: Wed 28 Dec 2016 10:15
by bsienn
Thanks Alexa.

Didn't noticed the unique check mark on right side. Thanks working as intended.

Re: Unable to uncheck unique index

Posted: Wed 28 Dec 2016 11:13
by alexa
Thank you for the reply. Please let us know if any questions arise.

Re: Unable to uncheck unique index

Posted: Wed 28 Dec 2016 14:39
by bsienn
alexa wrote:Thank you for the reply. Please let us know if any questions arise.

Hi Alexa,

Updating column as unique doesn't work. had to update through query. Please note.

Re: Unable to uncheck unique index

Posted: Wed 28 Dec 2016 15:03
by alexa
Could you please clarify it and describe the steps to reproduce step by step? Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

Re: Unable to uncheck unique index

Posted: Thu 29 Dec 2016 06:52
by bsienn
alexa wrote:Could you please clarify it and describe the steps to reproduce step by step? Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
Hi Alexa,

Regarding the tablename being converted to lowercase, I just searched and found that its not dbForge issue; its actually related to mysql configuration on windows. by default its configured to convert table names to lowercase. setting lower_case_table_names = 2 in my.ini of mysql allows uppercase table names.

Regarding the unique check mark issue, the unique was not applying on the column as there was unique index already applied.

If the unique won't apply if there is an unique index, than maybe there should be a prompt telling unique index already applied, better disable the unique check mark in case of unique index already applied.

Everything else is working fine. Thanks for your quick response and time helping me out.
I'm a new developer and dbForge Express user, sorry for misunderstanding.

Happy new year Alexa :)

Re: Unable to uncheck unique index

Posted: Thu 29 Dec 2016 11:57
by alexa
Thank you for the reply.

We will take this into account.

A happy new year to you too.